Question

1
Replies
372
Views
Close popover
hussin basha (hussinbashak)
Virtusa

Virtusa
IN
hussinbashak Member since 2016 6 posts
Virtusa
Posted: May 27, 2018
Last activity: May 27, 2018
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