Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A8C5B64FCCB for ; Sun, 28 Dec 2008 10:49:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07470-02 for ; Sun, 28 Dec 2008 10:49:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f19.google.com (mail-bw0-f19.google.com [209.85.218.19]) by mail.postgresql.org (Postfix) with ESMTP id A4ACF64FC2F for ; Sun, 28 Dec 2008 10:49:29 -0400 (AST) Received: by bwz12 with SMTP id 12so11922404bwz.19 for ; Sun, 28 Dec 2008 06:49:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=yF4YAdQfzlq1QWiFaJ3nMrPppDBCSXLKZvo0Pr1sRxc=; b=luhJ3L9aSLHZO4vU/ZXnZ15hSIxLxHatHS9SGAb3UIRsDN0vrjOM15H+2AcgNg614z 8ri2Xw30DaXXs6tC1JkGT3zgTNMOfIKFXW8ORXhBNF2UUAjXEQVo+dMfVlRNaVjxgZEi mNUgvxVdcKHsR1At9DtgOrOWoIEJ0j6ck4yRs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=YHMiHzXaWozRIUiTJdrG+ktp976Vp2u0kfng3JwDiH30WAxKRnBC1XApETpttRPspu omSfpNbTyEtdP7LeAr79vwZwq80fyc+eBMfkqIlwyOLEPPNA4hsrsRwXLuqqnpLNWDql 3HVGxkTtdICE3yZYXxlC5au+DGpuoogTJ5TeM= Received: by 10.223.114.208 with SMTP id f16mr9291898faq.91.1230475767760; Sun, 28 Dec 2008 06:49:27 -0800 (PST) Received: by 10.223.107.134 with HTTP; Sun, 28 Dec 2008 06:49:27 -0800 (PST) Message-ID: <603c8f070812280649t6be5f784h91a40d6049abeae0@mail.gmail.com> Date: Sun, 28 Dec 2008 09:49:27 -0500 From: "Robert Haas" To: "Bernd Helmle" Subject: Re: WIP: Automatic view update rules Cc: "Jaime Casanova" , "Bernd Helmle" , pgsql-hackers@postgresql.org In-Reply-To: <61043.91.48.33.48.1230474598.squirrel@tooney.at.xencon.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2849137C693B65CC8E86411C@imhotep.credativ.de> <94CF655A8D0DC7D5B4B81D8B@imhotep.credativ.de> <603c8f070811112006q906b3a6o59a66228b7fc997@mail.gmail.com> <7F84532C73CB3279DE8436E0@imhotep.credativ.de> <603c8f070811131344n5c087057p11f94780dae80885@mail.gmail.com> <603c8f070811252043r75db3e83v2eba1611452ee62e@mail.gmail.com> <3073cc9b0812250943x23547116ud956d8ab111e55bf@mail.gmail.com> <61043.91.48.33.48.1230474598.squirrel@tooney.at.xencon.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/1841 X-Sequence-Number: 130470 >> 2) Another less important bug, the WITH CHECK OPTION is accepted even >> when that functionality is not implemented. >> >> updatable_views=# create or replace view v2 as select * from foo where >> id < 10 with check option; >> NOTICE: CREATE VIEW will create implicit INSERT/UPDATE/DELETE rules >> CREATE VIEW > What do we want in this case? We can throw an error telling that CHECK > OPTION isn't supported yet or simply issueing a warning. +1 for an error. ...Robert