I have table T1 with columns C1,C2,C3.
Column C1 does not allow null values and has default value (next_val from sequence)
when i try to execute statement like "insert into T1(C2,C3) values (val1,val2)
I get the error:
OLE DB provider "PGNP" for linked server "testPGNP" returned message "ERROR: null value in column "C1" violates not-null constraint
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "PGNP" for linked server "testPGNP" could not INSERT INTO table "[testPGNP].[testPGNP].[public].[T1]".