search

pgadmin-org / pgadmin3

Archive of the pgAdmin III project
https://www.pgadmin.org/
Other
177 stars 82 forks source link

Can not create new primary key or unique constaraint with PgSQL 9.6 (RM #2397) #413

Open dpage opened 7 years ago

dpage commented 7 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2397 Originally created by Maxim Zakharov at 2017-05-12 03:57:49 UTC.

The following error is shown when one tries to create an Unique Constraint for a table:

pgAdmin III

An error has occurred:

ERROR: column "amgettuple" does not exist LINE 1: ..._am WHERE EXISTS (SELECT 1 FROM pg_proc WHERE oid=amgettuple... ^

OK

The same for new Primary Key index creation, see http://stackoverflow.com/questions/40904102/trying-to-set-constraint-new-primary-key-in-table-but-getting-an-error-colum

The patch attached solves this issue

dpage commented 7 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2291 Originally created by Maxim Zakharov at 2017-05-12 03:57:15 UTC.

https://pgadmin-archive.postgresql.org/redmine/2397/2291-new-index-constaint.patch