Re: [postgresSQL] [bug] Two or more different types of constraints with same name creates ambiguity while drooping. - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [postgresSQL] [bug] Two or more different types of constraints with same name creates ambiguity while drooping.
Date
Msg-id 20160330162635.GA966810@alvherre.pgsql
Whole thread Raw
In response to Re: [postgresSQL] [bug] Two or more different types of constraints with same name creates ambiguity while drooping.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [postgresSQL] [bug] Two or more different types of constraints with same name creates ambiguity while drooping.
List pgsql-hackers
Tom Lane wrote:

> What we need is a unique index on pg_constraint.
>
> The problem with that is that pg_constraint contains both table-related
> and type (domain) related constraints; but it strikes me that we could
> probably create a unique index on (conrelid, contypid, conname).

Weren't you proposing elsewhere to split pg_constraint in two catalogs,
one for table constraint and another for domain constraints?  That seems
a cleaner solution to me.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Password identifiers, protocol aging and SCRAM protocol
Next
From: José Luis Tallón
Date:
Subject: Re: Password identifiers, protocol aging and SCRAM protocol