Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Lockhart
Subject Re: Uniqueness of rule, constraint, and trigger names
Date
Msg-id 3C8C0A67.5EA7B830@fourpalms.org
Whole thread Raw
In response to Re: Uniqueness of rule, constraint, and trigger names  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
> > 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.

Speaking of which, I was looking at
 CREATE ASSERTION/DROP ASSERTION

in (what I think is) SQL99. It has enough restrictions on use that I'm
not yet sure what exactly it is supposed to do, and am not sure if it is
close to equivalent to something we already have. Anyone know?
                  - Thomas

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Reverting SET SESSION AUTHORIZATION command
Next
From: Peter Eisentraut
Date:
Subject: Re: Do we still have locking problems with concurrent