Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Changing Primary Key of schema from Custom to Auto PK

Avatar

Avatar
Validate 1
Level 2
inamw21812872
Level 2

Likes

4 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
inamw21812872
Level 2

Likes

4 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
inamw21812872
Level 2

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

Avatar

Avatar
Boost 5
Level 2
John_T_Smith
Level 2

Likes

5 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 5
Level 2
John_T_Smith
Level 2

Likes

5 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
John_T_Smith
Level 2

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 ???

Avatar

Avatar
Boost 1
Level 1
Nancy_OShea
Level 1

Likes

2 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Nancy_OShea
Level 1

Likes

2 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Nancy_OShea
Level 1

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

Avatar

Avatar
Boost 1
Level 1
John_Waller
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
John_Waller
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
John_Waller
Level 1

07-08-2019

Seems to be related to Adobe Campaign. Not sure.

Custom Primary Key

Avatar

Avatar
Boost 5
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
Abambo
Level 2

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.

Avatar

Avatar
Validate 1
Level 2
inamw21812872
Level 2

Likes

4 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
inamw21812872
Level 2

Likes

4 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
inamw21812872
Level 2

08-08-2019

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

Avatar

Avatar
Boost 5
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Level 2
Abambo
Level 2

Likes

9 likes

Total Posts

23 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
Abambo
Level 2

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.