I somehow have some entries in my schema where PK Attribute is NULL.I
created the workflow by querying those rows and added Delete Data Step..
but records wont get deleted.. Error message is PK cant be NULL.
I have a requirement where i want to change the Primary Key from
internal to Auto PK.. How do i do it?If i change the key and update
database structure .. i get this error message;08:00:51 - PGS-220000
PostgreSQL error: ERROR: could not create unique index "schemaName_id"
DETAIL: Key (ischemaid)=(0) is duplicated. 08:00:51 - WDB-200001 SQL
statement 'CREATE UNIQUE INDEX XXXXXXXXXXXXX_id ON XXXXXXXXXXXXXXX could
not be executed.08:00:51 - The update of the physical structure of the
database has f...