Question

1
Replies
327
Views
X
hussinbashak Member since 2016 6 posts
Virtusa
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

Clone pc_work table to store work objects in new table name?

Hi team,

I am trying to clone pc_work table to store work objects in new table name.Modified script to update the table name. After executing script, getting exception like

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pc_work_pk" for table "pc_work_externalinsert"

ERROR: relation "pc_work_pk" already exists

********** Error **********

ERROR: relation "pc_work_pk" already exists
SQL state: 42P07

Please let us know if any suggestions.

Thanks,

Hussain

Data Integration
Moderation Team has archived post
Share this page LinkedIn