since ‎08-03-2018
‎10-12-2019
inamw21812872
Level 2
Re: Changing Primary Key of schema from Custom to Auto PK
Avatar

inamw21812872

inamw21812872
- Adobe Campaign Classic
Yes Adobe Campaign... How do we do it using xml updates?

Views

4.5K

Like

1

Replies

0
How to delete records where Primary Key is NULL?
Avatar

inamw21812872

inamw21812872
- Adobe Campaign Classic
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.

Views

2.8K

Likes

2

Replies

5
Changing Primary Key of schema from Custom to Auto PK
Avatar

inamw21812872

inamw21812872
- Adobe Campaign Classic
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...

Views

4.8K

Like

1

Replies

6
Likes from