topic Re: [resolved] Create database table index in Talend Studio

[resolved] Create database table index

Anonymous — Sat, 16 Nov 2024 13:24:54 GMT

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

Re: [resolved] Create database table index

Anonymous — Sat, 29 May 2010 04:20:08 GMT

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

Re: [resolved] Create database table index

Anonymous — Tue, 22 Mar 2011 15:29:24 GMT

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