Highlighted

Changing Primary Key of schema from Custom to Auto PK

Avatar

Avatar

inamw21812872

Avatar

inamw21812872

inamw21812872

07-08-2019

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 failed

08:00:51 - XSV-350122 An error occurred and the process has been stopped.

Replies

Highlighted

Avatar

Avatar

John_T_Smith

Avatar

John_T_Smith

John_T_Smith

07-08-2019

Please post the name of the program you use so a Moderator may move this message to that forum

-A program would be Photoshop or Dreamweaver or Muse or Premiere Pro or ???

Highlighted

Avatar

Avatar

Nancy_OShea

Avatar

Nancy_OShea

Nancy_OShea

07-08-2019

This appears to be a question about SQL syntax rather than an Adobe  product.  See if this helps you.

How to change PRIMARY KEY of an existing PostgreSQL table? · GitHub

Highlighted

Avatar

Avatar

John_Waller

Avatar

John_Waller

John_Waller

07-08-2019

Seems to be related to Adobe Campaign. Not sure.

Custom Primary Key

Highlighted

Avatar

Avatar

Abambo

Avatar

Abambo

Abambo

07-08-2019

Campaign is also my guess! And before flooding the fora, inamw21812872 should first answer our questions as this will not lead to qualified answers as such a SQL database access is not necessary with CC products.

But I supposed John moved from Forum comments​ and it shouldn‘t be in Adobe Creative Cloud​ at all.

Highlighted

Avatar

Avatar

inamw21812872

Avatar

inamw21812872

inamw21812872

08-08-2019

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

Highlighted

Avatar

Avatar

Abambo

Avatar

Abambo

Abambo

08-08-2019

Discussion successfully moved from Adobe Creative Cloud to Adobe Campaign Classic

Adobe Campaign Standard​ or Adobe Campaign Classic​ ?

I moved to campaign classic now. A different moderator can move to standard or even still a different forum if that is necessary.