Search Postgresql Archives

Updateable VIEWS and the manual

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I just noticed the following statement in the CREATE VIEW documentation (9.2 and 9.1):

    Currently, views are read only: the system will not allow an insert,
    update, or delete on a view. You can get the effect of an updatable view by
    creating rules that rewrite inserts, etc. on the view into appropriate actions
    on other tables. For more information see CREATE RULE.

Wouldn't it make more sense to refer to INSTEAD OF triggers?

My understanding was that an INSTEAD OF trigger was preferred over a rule nowadays.

Regards
Thomas



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux