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