topic Re: [resolved] Identity Column in Talend Studio

[resolved] Identity Column

_AnonymousUser — Wed, 17 Sep 2014 18:27:01 GMT

Hi all,
How to load the data into red shift tables with identity column.
I am getting below error.
Exception in component tRedshiftOutput_1
org.postgresql.util.PSQLException: ERROR: cannot set an identity column to a value
Thanks,
Raja.

Re: [resolved] Identity Column

Anonymous — Wed, 17 Sep 2014 20:48:08 GMT

Identity columns are typically columns which should not be written by the insert statement instead the value will be taken from an implicit sequence by the database it self.
You should remove this column from the schema and let the database fill this column.

Re: [resolved] Identity Column

Naresh3 — Thu, 18 Sep 2014 02:57:27 GMT

Thanks.. Jlolling