VMware Tanzu Greenplum

View Only

dldwp=# ALTER TABLE x_HIST drop CONSTRAINT x_pkey; ERROR: constraint "x_pkey" does not exist Table has PK

Srinivasa Inaganti posted Jan 11, 2019 05:24 PM

Broadcom Employee Peter O'Donovan posted Jan 11, 2019 06:45 PM

Hello Srinivasa,

Error message suggests that the table x_HIST does not have a constraint called x_pkey. Have you confirmed that it exists? Do a "\d+ x_HIST" to view the contraints.

Please also note that the community is a place to ask questions, but you have asked none in this.

Regards,

Peter

Srinivasa Inaganti posted Jan 11, 2019 06:47 PM

Thanks working with support on this. From: 0-2yf13tt54forwi.9po5om9cj25pabkw.ypb2ugx4yhd26xzk@mt41la5aoplgubny.wuplozcyvv5nmo8.u-yqazmag.na62.chatter.salesforce.com At: 01/11/19 10:45:47To: Srinivasa Inaganti (BLOOMBERG/ PRINCETON ) Subject: Peter O'Donovan answered you: dldwp=# ALTER TABLE x_HIST drop CONSTRAINT x_pkey; ERROR: constraint "x_pkey" does not exist Table has PK Hello Srinivasa, Error message suggests that the table x_HIST does not have a constraint called x_pkey. Have you confirmed that it exists? Do a "\d+ x_HIST" to view the contraints. Please also note that the community is a place to ask questions, but you have asked none in this. Regards, Peter Peter O'Donovan (Pivotal) Hello Srinivasa, Error message suggests that the table x_HIST does not have a constraint called x_pkey. Have you confirmed that it exists? Do a "\d+ x_HIST" to view the contraints. Please also note that the community is a place to ask questions, but you have asked none in this. Regards, Peter View/Answer or reply to this email Original post Srinivasa Inaganti (Bloomberg) asked a question. Friday, January 11, 2019 9:24 AM dldwp=# ALTER TABLE x_HIST drop CONSTRAINT x_pkey; ERROR: constraint "x_pkey" does not exist Table has PK Peter O'Donovan (Pivotal) Hello Srinivasa, Error message suggests that the table x_HIST does not have a constraint called x_pkey. Have you confirmed that it exists? Do a "\d+ x_HIST" to view the contraints. Please also note that the community is a place to ask questions, but you have asked none in this. Regards, Peter Friday, January 11, 2019 10:45 AM

Srinivasa Inaganti posted Jan 11, 2019 06:52 PM

Yes verified. Issue is it's missing from pg_constraint table and working with support to fix.