Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de
	[53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id DAA34287;
	Thu, 13 Apr 2000 03:41:56 -0400 (EDT) (envelope-from wieck@debis.com)
Received: by orion.SAPserv.Hamburg.dsh.de for docs@postgreSQL.org
	id m12fe8I-0003knC; Thu, 13 Apr 100 09:33 MET DST
Message-Id: <m12fe8I-0003knC@orion.SAPserv.Hamburg.dsh.de>
From: wieck@debis.com (Jan Wieck)
Subject: Re: [HACKERS] TODO doc items
In-Reply-To: <200004130428.AAA06245@candle.pha.pa.us> from Bruce Momjian at
	"Apr 13, 2000 00:28:04 am"
To: Bruce Momjian <pgman@candle.pha.pa.us>
Date: Thu, 13 Apr 2000 09:33:46 +0200 (CEST)
CC: PostgreSQL-development <pgsql-hackers@postgresql.org>,
	PostgreSQL-documentation <docs@postgresql.org>
Reply-To: Jan Wieck <wieck@debis.com>
X-Mailer: ELM [version 2.4ME+ PL68 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200004/65

Bruce Momjian wrote:

> Here are the open doc items.  Should we consider ecpg.sgml as up-to-date
> as it needs to be for 7.0?  Can I get someone working on the other
> items, hopefully the authors?
>
> ---------------------------------------------------------------------------
>
> > New CREATE CONSTRAINT TRIGGER and SET CONSTRAINTS commands(Jan)
>
> No man page yet.  Not sure what command SET CONSTRAINT applies to.
>

    CREATE CONSTRAINT TRIGGER is used from inside of CREATE/ALTER
    TABLE and by pg_dump  to  create  the  special  triggers  for
    referential  integrity. Dunno if we really need a manpage for
    it.

    SET CONSTRAINTS is the SQL3 specified command to  change  the
    default behaviour of constraints WRT deferring in the current
    transaction.

    Syntax is:

        SET CONSTRAINTS {ALL | <constraintlist>} <mode>

        <constraintlist> := comma separated list of deferrable
                            constraint names

        <mode> := DEFERRED | IMMEDIATE

    In deferred mode, the actual check of the constraint is  held
    back  until  either it's mode is explicitly set to IMMEDIATE,
    or until COMMIT.  This is actually only done for foreign  key
    constraints,  so  it  does  not  apply  to  UNIQUE  or  other
    constraints.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #