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_--