diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-12-02 16:17:53 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-12-02 16:18:18 -0500 |
| commit | 7e487c1b0acbb26a481e64570dcbfe39b3e54abb (patch) | |
| tree | 1c17e64e17b5cc7a7f5957b82b98924e58c6dc95 | |
| parent | d08fd1f849ba7419b79094e6cf863b6c190784b5 (diff) | |
| download | postgresql-7e487c1b0acbb26a481e64570dcbfe39b3e54abb.tar.gz postgresql-7e487c1b0acbb26a481e64570dcbfe39b3e54abb.zip | |
Recommend triggers, not rules, in the CREATE VIEW reference page.
We've generally recommended use of INSTEAD triggers over rules since that
feature was added; but this old text in the CREATE VIEW reference page
didn't get the memo. Noted by Thomas Kellerer.
| -rw-r--r-- | doc/src/sgml/ref/create_view.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index 417f8c38e7e..77fc6c489c7 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -117,9 +117,12 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW <replaceable class="PARAMETER">n <para> 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 + view by creating <literal>INSTEAD</> triggers on the view, which + must convert attempted inserts, etc. on the view into appropriate actions on other tables. For more information see - <xref linkend="sql-createrule">. + <xref linkend="sql-createtrigger">. Another possibility is to create + rules (see <xref linkend="sql-createrule">), but in practice triggers + are easier to understand and use correctly. </para> <para> |