From david.sahagian@emc.com Mon Jun 1 08:15:47 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TqRiP-0000rn-AM for pgsql-docs@arkaria.postgresql.org; Wed, 02 Jan 2013 17:02:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TqRiO-00063f-8c for pgsql-docs@arkaria.postgresql.org; Wed, 02 Jan 2013 17:02:52 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TqReQ-0005xG-G1 for pgsql-docs@postgresql.org; Wed, 02 Jan 2013 16:58:46 +0000 Received: from hop-nat-141.emc.com ([168.159.213.141] helo=mexforward.lss.emc.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TqReO-0000nD-AH for pgsql-docs@postgresql.org; Wed, 02 Jan 2013 16:58:45 +0000 Received: from hop04-l1d11-si04.isus.emc.com (HOP04-L1D11-SI04.isus.emc.com [10.254.111.24]) by mexforward.lss.emc.com (Switch-3.4.3/Switch-3.4.3) with ESMTP id r02Gwawn003554 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 2 Jan 2013 11:58:39 -0500 Received: from mailhub.lss.emc.com (mailhubhoprd04.lss.emc.com [10.254.222.226]) by hop04-l1d11-si04.isus.emc.com (RSA Interceptor) for ; Wed, 2 Jan 2013 11:58:26 -0500 Received: from mxhub34.corp.emc.com (mxhub34.corp.emc.com [10.254.93.82]) by mailhub.lss.emc.com (Switch-3.4.3/Switch-3.4.3) with ESMTP id r02GwPQD014105 for ; Wed, 2 Jan 2013 11:58:26 -0500 Received: from mx22a.corp.emc.com ([169.254.1.39]) by mxhub34.corp.emc.com ([::1]) with mapi; Wed, 2 Jan 2013 11:58:25 -0500 From: "Sahagian, David" To: "pgsql-docs@postgresql.org" Date: Wed, 2 Jan 2013 11:58:24 -0500 Subject: doc page: ALTER VIEW Thread-Topic: doc page: ALTER VIEW Thread-Index: Ac3pCmCwpHsyuPcMS+mnO77HKfRvPQ== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_F3CBFBA88397EA498B22A05FFA9EC49D0109AD75DCMX22Acorpemcc_" MIME-Version: 1.0 X-EMM-MHVC: 1 X-Pg-Spam-Score: -0.5 (/) 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 --_000_F3CBFBA88397EA498B22A05FFA9EC49D0109AD75DCMX22Acorpemcc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 addit= ion to [ON INSERT rule]. "A default value associated with a view column is inserted into INSERT stat= ements on the view before the view's ON INSERT rule is applied, . . ." Thanks, -dvs- --_000_F3CBFBA88397EA498B22A05FFA9EC49D0109AD75DCMX22Acorpemcc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

On the doc page = for ALTER VIEW . . .

In the discussion about SET/DROP DEFAULT,=

I am thinking that [instead-of insert trigger] sho= uld be mentioned in addition to [ON INSERT rule].

“A default value associated with a view column is inserted in= to INSERT= statements on the view before the view's = ON INSERT= rule is applied, . . .”

Thanks,

-dvs-

= --_000_F3CBFBA88397EA498B22A05FFA9EC49D0109AD75DCMX22Acorpemcc_-- From peter_e@gmx.net Mon Jun 1 08:15:47 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U4AXG-0003SS-5F for pgsql-docs@arkaria.postgresql.org; Sat, 09 Feb 2013 13:32:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U4AXF-0003OB-4x for pgsql-docs@arkaria.postgresql.org; Sat, 09 Feb 2013 13:32:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U4AXE-0003O5-D5 for pgsql-docs@postgresql.org; Sat, 09 Feb 2013 13:32:04 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U4AXB-00041J-En for pgsql-docs@postgresql.org; Sat, 09 Feb 2013 13:32:03 +0000 Received: from mailout-de.gmx.net ([10.1.76.32]) by mrigmx.server.lan (mrigmx001) with ESMTP (Nemesis) id 0Ly8b5-1Uyedp1YA9-015ZeZ for ; Sat, 09 Feb 2013 14:32:00 +0100 Received: (qmail invoked by alias); 09 Feb 2013 13:31:59 -0000 Received: from pool-108-52-108-60.phlapa.fios.verizon.net (EHLO [192.168.1.5]) [108.52.108.60] by mail.gmx.net (mp032) with SMTP; 09 Feb 2013 14:31:59 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX195DrQ+Opl51uQ3wdbHyOoHTpYzkTzZYr/exquWno VxezjlZhAM9+RI Message-ID: <1360416715.22094.1.camel@vanquo.pezone.net> Subject: Re: doc page: ALTER VIEW From: Peter Eisentraut To: "Sahagian, David" Cc: "pgsql-docs@postgresql.org" Date: Sat, 09 Feb 2013 08:31:55 -0500 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.4.4-1 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 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 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. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs From tgl@sss.pgh.pa.us Mon Jun 1 08:15:47 2026 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