doc page: ALTER VIEW
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-
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
Peter Eisentraut <peter_e@gmx.net> 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