topic [resolved] insert into postgres table only some columns in Talend Studio

[resolved] insert into postgres table only some columns

ilmp — Sat, 16 Nov 2024 13:23:39 GMT

fails with "null value in column "column_name" violates not-null constraint"
Hello,
I want to insert two values in a postgre table with more than two columns.
The primary key has a sequence. So will be filled automaticly.
If I try. I get the error message above.
What ist the correct approach for this task?
Thank you for your help!
Christian

Re: [resolved] insert into postgres table only some columns

Anonymous — Sun, 13 Jun 2010 03:16:58 GMT

Hello
Is there one column called "column_name" and it is defined not null in your table?
Best regards
Shong

Re: [resolved] insert into postgres table only some columns

ilmp — Tue, 15 Jun 2010 15:18:13 GMT

Hello Shong,
you brought me on the right path. Thank you very much!
It was not an error of my job. It was an error of my Postgres DB.
The column name "column_name" was so strange that I was not sensitiv enough.
ALTER TABLE <table_name> ALTER COLUMN column_name DROP NOT NULL;
ALTER SEQUENCE <sequence_name> restart with 251;
Best regards,
Christian