Received: from myst.fourpalms.org (fourpalms.org [64.3.68.148]) by postgresql.org (Postfix) with ESMTP id F272547595C for ; Sun, 10 Mar 2002 20:37:39 -0500 (EST) Received: from fourpalms.org (localhost.localdomain [127.0.0.1]) by myst.fourpalms.org (Postfix) with ESMTP id 0D5FC7DBEA; Sun, 10 Mar 2002 17:37:43 -0800 (PST) Message-ID: <3C8C0A67.5EA7B830@fourpalms.org> Date: Sun, 10 Mar 2002 17:37:43 -0800 From: Thomas Lockhart Organization: Yes X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.8-34.1mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Peter Eisentraut Cc: Tom Lane , PostgreSQL Development Subject: Re: Uniqueness of rule, constraint, and trigger names References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/446 X-Sequence-Number: 19921 > > 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