diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_function.sgml | 10 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_view.sgml | 10 |
2 files changed, 18 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 0c35ded26c9..ce6141107a7 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.84.2.1 2009/09/03 22:11:13 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.84.2.2 2009/10/02 18:13:10 tgl Exp $ --> <refentry id="SQL-CREATEFUNCTION"> @@ -562,6 +562,14 @@ CREATE FUNCTION foo(int, int default 42) ... <literal>USAGE</literal> privilege on the language. </para> + <para> + When <command>CREATE OR REPLACE FUNCTION</> is used to replace an + existing function, the ownership and permissions of the function + do not change. All other function properties are assigned the + values specified or implied in the command. You must own the function + to replace it (this includes being a member of the owning role). + </para> + </refsect1> <refsect1 id="sql-createfunction-examples"> diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index 1a3281dda62..64c8f2102f6 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_view.sgml,v 1.41 2009/01/27 12:40:15 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_view.sgml,v 1.41.2.1 2009/10/02 18:13:10 tgl Exp $ PostgreSQL documentation --> @@ -149,6 +149,14 @@ CREATE VIEW vista AS SELECT text 'Hello World' AS hello; used by the view. </para> + <para> + When <command>CREATE OR REPLACE VIEW</> is used on an + existing view, only the view's defining SELECT rule is changed. + Other view properties, including ownership, permissions, and non-SELECT + rules, remain unchanged. You must own the view + to replace it (this includes being a member of the owning role). + </para> + </refsect1> <refsect1> |