public inbox for [email protected]
help / color / mirror / Atom feeddoc page: ALTER VIEW
3+ messages / 3 participants
[nested] [flat]
* doc page: ALTER VIEW
@ 2013-01-02 16:58 Sahagian, David <[email protected]>
2013-02-09 13:31 ` Re: doc page: ALTER VIEW Peter Eisentraut <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Sahagian, David @ 2013-01-02 16:58 UTC (permalink / raw)
To: pgsql-docs
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, . . ."
Thanks,
-dvs-
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: doc page: ALTER VIEW
2013-01-02 16:58 doc page: ALTER VIEW Sahagian, David <[email protected]>
@ 2013-02-09 13:31 ` Peter Eisentraut <[email protected]>
2013-02-09 16:44 ` Re: doc page: ALTER VIEW Tom Lane <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Eisentraut @ 2013-02-09 13:31 UTC (permalink / raw)
To: Sahagian, David <[email protected]>; +Cc: pgsql-docs
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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: doc page: ALTER VIEW
2013-01-02 16:58 doc page: ALTER VIEW Sahagian, David <[email protected]>
2013-02-09 13:31 ` Re: doc page: ALTER VIEW Peter Eisentraut <[email protected]>
@ 2013-02-09 16:44 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2013-02-09 16:44 UTC (permalink / raw)
To: Peter Eisentraut <[email protected]>; +Cc: Sahagian, David <[email protected]>; pgsql-docs
Peter Eisentraut <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-02-09 16:44 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-02 16:58 doc page: ALTER VIEW Sahagian, David <[email protected]>
2013-02-09 13:31 ` Peter Eisentraut <[email protected]>
2013-02-09 16:44 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox