One Star

[resolved] Create database table index

I am trying to have talend create an index on a Postgres database. If i put this in the table query on a tPostgresInput:
"CREATE INDEX \"INDIX\"
ON working
USING btree
(\"RECORDID\", \"SOURCE\")"

It actually works fine, the index is created, but I get an error:
Exception in component tPostgresqlInput_1
org.postgresql.util.PSQLException: No results were returned by the query.
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)

Any other way to do this? Or turn off errors?
Thanks Marc
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] Create database table index

Figured it out
tRowGenerate (1 row) ----Iterate---->tPostgresSQLRow
2 REPLIES
One Star

Re: [resolved] Create database table index

Figured it out
tRowGenerate (1 row) ----Iterate---->tPostgresSQLRow
One Star

Re: [resolved] Create database table index

Hi Marc,
I am looking to create multiple indexes on a table, please can you elaborate on what the configuration of your tRowGenerator looks like for the index creation as well as what the tXXXRow looks loke.
Thanks
glongi