X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 88979D1C94B for ; Thu, 4 Mar 2004 15:08:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95270-10 for ; Thu, 4 Mar 2004 11:08:12 -0400 (AST) Received: from cri.ensmp.fr (orgenoy.ensmp.fr [193.48.171.195]) by svr1.postgresql.org (Postfix) with ESMTP id 0F614D1B470 for ; Thu, 4 Mar 2004 11:08:08 -0400 (AST) Received: from sablons.cri.ensmp.fr (sablons.cri.ensmp.fr [10.2.14.143]) by cri.ensmp.fr (8.11.2/8.11.2/mx-cri-CRI) with ESMTP id i24F7tI11521; Thu, 4 Mar 2004 16:07:55 +0100 (MET) Date: Thu, 4 Mar 2004 16:07:54 +0100 (CET) From: Fabien COELHO X-X-Sender: coelho@sablons.cri.ensmp.fr Reply-To: Fabien COELHO To: Bruce Momjian Cc: Tom Lane , Jan Wieck , PostgreSQL Patches Subject: Re: "ALSO" keyword to "CREATE RULE" patch In-Reply-To: <200403041452.i24Equw00423@candle.pha.pa.us> Message-ID: References: <200403041452.i24Equw00423@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/119 X-Sequence-Number: 10050 > I thought the syntax came from Berkeley. We can add ALSO if folks like > it. I can't think of cases where we have keywords for both on and off > behavior, and allow a default if the keyword is missing. ALTER TABLE ... DROP CONSTRAINT ... [ RESTRICT | CASCADE ] CREATE TABLE ... [ WITH OIDS | WITHOUT OIDS ] CREATE USER [ CREATEDB | NOCREATEDB ] ... IMHO, from the language design point of view, it seems better if all options have a name. -- Fabien.