Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U4DXv-0001uF-5Q for pgsql-docs@arkaria.postgresql.org; Sat, 09 Feb 2013 16:44:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U4DXu-0007fb-Lk for pgsql-docs@arkaria.postgresql.org; Sat, 09 Feb 2013 16:44:58 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U4DXu-0007fW-3w for pgsql-docs@postgresql.org; Sat, 09 Feb 2013 16:44:58 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U4DXr-0008Un-Qf for pgsql-docs@postgresql.org; Sat, 09 Feb 2013 16:44:57 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r19GioFn006008; Sat, 9 Feb 2013 11:44:50 -0500 (EST) From: Tom Lane To: Peter Eisentraut cc: "Sahagian, David" , "pgsql-docs@postgresql.org" Subject: Re: doc page: ALTER VIEW In-reply-to: <1360416715.22094.1.camel@vanquo.pezone.net> References: <1360416715.22094.1.camel@vanquo.pezone.net> Comments: In-reply-to Peter Eisentraut message dated "Sat, 09 Feb 2013 08:31:55 -0500" Date: Sat, 09 Feb 2013 11:44:50 -0500 Message-ID: <6007.1360428290@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org Peter Eisentraut writes: > On Wed, 2013-01-02 at 11:58 -0500, Sahagian, David wrote: >> On the doc page for ALTER VIEW . . . >> >> In the discussion about SET/DROP DEFAULT, >> I am thinking that [instead-of insert trigger] should be mentioned in addition to [ON INSERT rule]. >> >> "A default value associated with a view column is inserted into INSERT statements on the view before the view's ON INSERT rule is applied, . . ." > This paragraph was rewritten as part of the updatable views patch, and > it appears to now say what you wanted. Looking at this page, it occurred to me that there really ought to be an explicit example of using SET DEFAULT. So I added one. regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs