since
10-12-2019
Level 2
Re: Changing Primary Key of schema from Custom to Auto PK
inamw21812872
- Adobe Campaign Classic
4.5K
1
0
inamw21812872
Yes Adobe Campaign... How do we do it using xml updates?
Views
Like
Replies
How to delete records where Primary Key is NULL?
inamw21812872
- Adobe Campaign Classic
2.8K
2
5
inamw21812872
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
Likes
Replies
Changing Primary Key of schema from Custom to Auto PK
inamw21812872
- Adobe Campaign Classic
4.8K
1
6
inamw21812872
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
Like
Replies
