public inbox for [email protected]  

help / color / mirror / Atom feed

doc page: ALTER VIEW
3+ messages / 3 participants
[nested] [flat]

* doc page: ALTER VIEW
@ 2013-01-02 16:58  Sahagian, David <[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-02-09 13:31  Peter Eisentraut <[email protected]>
  parent: Sahagian, David <[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-02-09 16:44  Tom Lane <[email protected]>
  parent: Peter Eisentraut <[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