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
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