One Star

[resolved] Identity Column

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Seventeen Stars

Re: [resolved] Identity Column

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. 
2 REPLIES
Seventeen Stars

Re: [resolved] Identity Column

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. 
One Star

Re: [resolved] Identity Column

Thanks.. Jlolling