Re: Uniqueness of rule, constraint, and trigger names - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Uniqueness of rule, constraint, and trigger names
Date
Msg-id Pine.LNX.4.30.0203102031360.684-100000@peter.localdomain
Whole thread Raw
In response to Uniqueness of rule, constraint, and trigger names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> The SQL spec is not a great deal of help on this, since it doesn't
> have rules or triggers at all.

The SQL spec has triggers, and their names are supposed to be
globally unique.

> For constraints, it requires database-wide uniqueness of constraint
> names --- a rule I doubt anyone is going to favor adopting for
> Postgres.

This should probably be schema-wide, which poses much less of a problem.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: numeric/decimal docs bug?
Next
From: Peter Eisentraut
Date:
Subject: Re: Reverting SET SESSION AUTHORIZATION command