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 8824DD1CA8F for ; Thu, 4 Mar 2004 15:13:35 +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 04869-07 for ; Thu, 4 Mar 2004 11:13:36 -0400 (AST) Received: from cri.ensmp.fr (orgenoy.ensmp.fr [193.48.171.195]) by svr1.postgresql.org (Postfix) with ESMTP id 99937D1C968 for ; Thu, 4 Mar 2004 11:13:32 -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 i24FDJI11799; Thu, 4 Mar 2004 16:13:19 +0100 (MET) Date: Thu, 4 Mar 2004 16:13:19 +0100 (CET) From: Fabien COELHO 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/40 X-Sequence-Number: 9971 > 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 Coelho - coelho@cri.ensmp.fr