diff options
Diffstat (limited to 'doc/src')
23 files changed, 859 insertions, 103 deletions
diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml index a922e933e16..b40f82246e7 100644 --- a/doc/src/sgml/ref/allfiles.sgml +++ b/doc/src/sgml/ref/allfiles.sgml @@ -1,45 +1,20 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.53 2003/03/20 07:02:07 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.54 2003/06/27 14:45:25 petere Exp $ PostgreSQL documentation Complete list of usable sgml source files in this directory. --> -<!-- these will go into the "operators" reference chapter --> -<!entity all system "all.sgml"> -<!entity any system "any.sgml"> -<!entity between system "between.sgml"> -<!entity in system "in.sgml"> -<!entity like system "like.sgml"> - -<!-- these will go into the "functions" reference chapter --> -<!entity avg system "avg.sgml"> -<!entity cast system "cast.sgml"> -<!entity charLength system "char_length.sgml"> -<!entity count system "count.sgml"> -<!entity currentDate system "current_date.sgml"> -<!entity currentTime system "current_time.sgml"> -<!entity currentTimestamp system "current_timestamp.sgml"> -<!entity currentUser system "current_user.sgml"> -<!entity exists system "exists.sgml"> -<!entity extract system "extract.sgml"> -<!entity initcap system "initcap.sgml"> -<!entity lower system "lower.sgml"> -<!entity lpad system "lpad.sgml"> -<!entity max system "max.sgml"> -<!entity min system "min.sgml"> -<!entity position system "position.sgml"> -<!entity rpad system "rpad.sgml"> -<!entity substring system "substring.sgml"> -<!entity sum system "sum.sgml"> -<!entity translate system "translate.sgml"> -<!entity trim system "trim.sgml"> -<!entity upper system "upper.sgml"> - <!-- SQL commands --> <!entity abort system "abort.sgml"> +<!entity alterAggregate system "alter_aggregate.sgml"> +<!entity alterConversion system "alter_conversion.sgml"> <!entity alterDatabase system "alter_database.sgml"> <!entity alterDomain system "alter_domain.sgml"> +<!entity alterFunction system "alter_function.sgml"> <!entity alterGroup system "alter_group.sgml"> +<!entity alterLanguage system "alter_language.sgml"> +<!entity alterOperatorClass system "alter_opclass.sgml"> +<!entity alterSchema system "alter_schema.sgml"> <!entity alterSequence system "alter_sequence.sgml"> <!entity alterTable system "alter_table.sgml"> <!entity alterTrigger system "alter_trigger.sgml"> diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml new file mode 100644 index 00000000000..972accd7565 --- /dev/null +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -0,0 +1,128 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_aggregate.sgml,v 1.1 2003/06/27 14:45:25 petere Exp $ +PostgreSQL documentation +--> + +<refentry id="SQL-ALTERAGGREGATE"> + <refmeta> + <refentrytitle id="SQL-ALTERAGGREGATE-TITLE">ALTER AGGREGATE</refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>ALTER AGGREGATE</refname> + <refpurpose>change the definition of an aggregate function</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable> ) RENAME TO <replaceable>newname</replaceable> +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + <command>ALTER AGGREGATE</command> changes the definition of an + aggregate function. The only functionality is to rename the + aggregate function. + </para> + </refsect1> + + <refsect1> + <title>Parameters</title> + + <variablelist> + <varlistentry> + <term><replaceable class="parameter">name</replaceable></term> + <listitem> + <para> + The name (optionally schema-qualified) of an existing aggregate function. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">type</replaceable></term> + <listitem> + <para> + The argument data type of the aggregate function, or + <literal>*</literal> if the function accepts any data type. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">newname</replaceable></term> + <listitem> + <para> + The new name of the aggregate function. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>ALTER AGGREGATE</computeroutput></term> + <listitem> + <para> + Message returned if the command was successful. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Examples</title> + + <para> + To rename the aggregate function <literal>myavg</literal> for type + <type>integer</type> to <literal>my_average</literal>: +<programlisting> +ALTER AGGREGATE myavg(integer) RENAME TO my_average; +</programlisting> + </para> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + There is no <command>ALTER AGGREGATE</command> statement in the SQL + standard. + </para> + </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-createaggregate" endterm="sql-createaggregate-title"></member> + <member><xref linkend="sql-dropaggregate" endterm="sql-dropaggregate-title"></member> + </simplelist> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml new file mode 100644 index 00000000000..b2767405ca8 --- /dev/null +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -0,0 +1,117 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_conversion.sgml,v 1.1 2003/06/27 14:45:25 petere Exp $ +PostgreSQL documentation +--> + +<refentry id="SQL-ALTERCONVERSION"> + <refmeta> + <refentrytitle id="SQL-ALTERCONVERSION-TITLE">ALTER CONVERSION</refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>ALTER CONVERSION</refname> + <refpurpose>change the definition of a conversion</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable> +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + <command>ALTER CONVERSION</command> changes the definition of a + conversion. The only functionality is to rename the conversion. + </para> + </refsect1> + + <refsect1> + <title>Parameters</title> + + <variablelist> + <varlistentry> + <term><replaceable class="parameter">name</replaceable></term> + <listitem> + <para> + The name (optionally schema-qualified) of an existing conversion. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">newname</replaceable></term> + <listitem> + <para> + The new name of the conversion. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>ALTER CONVERSION</computeroutput></term> + <listitem> + <para> + Message returned if the command was successful. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Examples</title> + + <para> + To rename the conversion <literal>iso_8859_1_to_utf_8</literal> to + <literal>latin1_to_unicode</literal>: +<programlisting> +ALTER CONVERSION iso_8859_1_to_utf_8 RENAME TO latin1_to_unicode; +</programlisting> + </para> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + There is no <command>ALTER CONVERSION</command> statement in the SQL + standard. + </para> + </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-createconversion" endterm="sql-createconversion-title"></member> + <member><xref linkend="sql-dropconversion" endterm="sql-dropconversion-title"></member> + </simplelist> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 326f784918c..12447d6b0a7 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.6 2003/04/15 13:25:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.7 2003/06/27 14:45:25 petere Exp $ PostgreSQL documentation --> @@ -18,6 +18,8 @@ PostgreSQL documentation <synopsis> ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> SET <replaceable>variable</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT } ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replaceable>variable</replaceable> + +ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>newname</replaceable> </synopsis> </refsynopsisdiv> @@ -25,20 +27,29 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replacea <title>Description</title> <para> - <command>ALTER DATABASE</command> is used to change the session - default of a run-time configuration variable for a - <productname>PostgreSQL</productname> database. Whenever a new - session is subsequently started in that database, the specified - value becomes the session default value. - The database-specific default - overrides whatever setting is present in <filename>postgresql.conf</> - or has been received from the <command>postmaster</command> command line. + <command>ALTER DATABASE</command> is used to change the attributes + of a database. </para> <para> - Only the database owner or a superuser can change the session defaults for a + The first two forms change the session default of a run-time + configuration variable for a <productname>PostgreSQL</productname> + database. Whenever a new session is subsequently started in that + database, the specified value becomes the session default value. + The database-specific default overrides whatever setting is present + in <filename>postgresql.conf</> or has been received from the + <command>postmaster</command> command line. Only the database + owner or a superuser can change the session defaults for a database. </para> + + <para> + The third form changes the name of the database. Only the database + owner can rename a database, and only if he has the + <literal>CREATEDB</literal> privilege. The current database cannot + be renamed. (Connect to a different database if you need to do + that.) + </para> </refsect1> <refsect1> @@ -76,7 +87,16 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replacea </para> </listitem> </varlistentry> - </variablelist> + + <varlistentry> + <term><replaceable>newname</replaceable></term> + <listitem> + <para> + The new name of the database. + </para> + </listitem> + </varlistentry> + </variablelist> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml new file mode 100644 index 00000000000..621350980b8 --- /dev/null +++ b/doc/src/sgml/ref/alter_function.sgml @@ -0,0 +1,127 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_function.sgml,v 1.1 2003/06/27 14:45:25 petere Exp $ +PostgreSQL documentation +--> + +<refentry id="SQL-ALTERFUNCTION"> + <refmeta> + <refentrytitle id="SQL-ALTERFUNCTION-TITLE">ALTER FUNCTION</refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>ALTER FUNCTION</refname> + <refpurpose>change the definition of a function</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +ALTER FUNCTION <replaceable>name</replaceable> ( [ <replaceable class="parameter">type</replaceable> [, ...] ] ) RENAME TO <replaceable>newname</replaceable> +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + <command>ALTER FUNCTION</command> changes the definition of a + function. The only functionality is to rename the function. + </para> + </refsect1> + + <refsect1> + <title>Parameters</title> + + <variablelist> + <varlistentry> + <term><replaceable class="parameter">name</replaceable></term> + <listitem> + <para> + The name (optionally schema-qualified) of an existing function. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">type</replaceable></term> + <listitem> + <para> + The data type of an argument of the function. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">newname</replaceable></term> + <listitem> + <para> + The new name of the function. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>ALTER FUNCTION</computeroutput></term> + <listitem> + <para> + Message returned if the command was successful. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Examples</title> + + <para> + To rename the function <literal>sqrt</literal> for type + <type>integer</type> to <literal>square_root</literal>: +<programlisting> +ALTER FUNCTION sqrt(integer) RENAME TO square_root; +</programlisting> + </para> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + There is an <command>ALTER FUNCTION</command> statement in the SQL + standard, but it does not provide the option to rename the + function. + </para> + </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-createfunction" endterm="sql-createfunction-title"></member> + <member><xref linkend="sql-dropfunction" endterm="sql-dropfunction-title"></member> + </simplelist> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index f036916a46e..6d0695b9384 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.9 2003/04/15 13:25:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.10 2003/06/27 14:45:25 petere Exp $ PostgreSQL documentation --> @@ -11,13 +11,15 @@ PostgreSQL documentation <refnamediv> <refname>ALTER GROUP</refname> - <refpurpose>add users to a group or remove users from a group</refpurpose> + <refpurpose>change a user group</refpurpose> </refnamediv> <refsynopsisdiv> <synopsis> ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> ADD USER <replaceable class="PARAMETER">username</replaceable> [, ... ] ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> DROP USER <replaceable class="PARAMETER">username</replaceable> [, ... ] + +ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> RENAME TO <replaceable>newname</replaceable> </synopsis> </refsynopsisdiv> @@ -25,16 +27,16 @@ ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> DROP USER <re <title>Description</title> <para> - <command>ALTER GROUP</command> is used to add or remove users from a - group. Only database superusers can use this command. - Adding a user to a group does not create the user. Similarly, removing - a user from a group does not drop the user itself. + <command>ALTER GROUP</command> is used to change a user group. The + first two variants add or remove users from a group. Only database + superusers can use this command. Adding a user to a group does not + create the user. Similarly, removing a user from a group does not + drop the user itself. </para> <para> - Use <xref linkend="SQL-CREATEGROUP" endterm="SQL-CREATEGROUP-title"> - to create a new group and <xref linkend="SQL-DROPGROUP" - endterm="SQL-DROPGROUP-title"> to remove a group. + The third variant changes the name of the group. Only a database + superuser can rename groups. </para> </refsect1> @@ -60,6 +62,15 @@ ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> DROP USER <re </para> </listitem> </varlistentry> + + <varlistentry> + <term><replaceable>newname</replaceable></term> + <listitem> + <para> + The new name of the group. + </para> + </listitem> + </varlistentry> </variablelist> </refsect1> @@ -104,6 +115,16 @@ ALTER GROUP workers DROP USER beth; standard. The concept of roles is similar. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-creategroup" endterm="sql-creategroup-title"></member> + <member><xref linkend="sql-dropgroup" endterm="sql-dropgroup-title"></member> + </simplelist> + </refsect1> + </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/alter_language.sgml b/doc/src/sgml/ref/alter_language.sgml new file mode 100644 index 00000000000..2c922d58830 --- /dev/null +++ b/doc/src/sgml/ref/alter_language.sgml @@ -0,0 +1,107 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.1 2003/06/27 14:45:25 petere Exp $ +PostgreSQL documentation +--> + +<refentry id="SQL-ALTERLANGUAGE"> + <refmeta> + <refentrytitle id="SQL-ALTERLANGUAGE-title">ALTER LANGUAGE</refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>ALTER LANGUAGE</refname> + <refpurpose>change the definition of a procedural language</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +ALTER LANGUAGE <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable> +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + <command>ALTER LANGUAGE</command> changes the definition of a + language. The only functionality is to rename the language. Only + a superuser can rename languages. + </para> + </refsect1> + + <refsect1> + <title>Parameter</title> + + <variablelist> + <varlistentry> + <term><replaceable>name</replaceable></term> + <listitem> + <para> + Name of a language + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable>newname</replaceable></term> + <listitem> + <para> + The new name of the language + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>ALTER LANGUAGE</computeroutput></term> + <listitem> + <para> + Message returned if the alteration was successful. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + There is no <command>ALTER LANGUAGE</command> statement in the SQL + standard. + </para> + </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-createlanguage" endterm="sql-createlanguage-title"></member> + <member><xref linkend="sql-droplanguage" endterm="sql-droplanguage-title"></member> + </simplelist> + </refsect1> + +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> diff --git a/doc/src/sgml/ref/alter_opclass.sgml b/doc/src/sgml/ref/alter_opclass.sgml new file mode 100644 index 00000000000..5a9694c73a8 --- /dev/null +++ b/doc/src/sgml/ref/alter_opclass.sgml @@ -0,0 +1,116 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_opclass.sgml,v 1.1 2003/06/27 14:45:26 petere Exp $ +PostgreSQL documentation +--> + +<refentry id="SQL-ALTEROPCLASS"> + <refmeta> + <refentrytitle id="SQL-ALTEROPCLASS-TITLE">ALTER OPERATOR CLASS</refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>ALTER OPERATOR CLASS</refname> + <refpurpose>change the definition of an operator class</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +ALTER OPERATOR CLASS <replaceable>name</replaceable> USING <replaceable class="parameter">index_method</replaceable> RENAME TO <replaceable>newname</replaceable> +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + <command>ALTER OPERATOR CLASS</command> changes the definition of + an operator class. The only functionality is to rename the + operator class. + </para> + </refsect1> + + <refsect1> + <title>Parameters</title> + + <variablelist> + <varlistentry> + <term><replaceable class="parameter">name</replaceable></term> + <listitem> + <para> + The name (optionally schema-qualified) of an existing operator + class. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">index_method</replaceable></term> + <listitem> + <para> + The name of the index method this operator class is for. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">newname</replaceable></term> + <listitem> + <para> + The new name of the operator class. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>ALTER OPERATOR CLASS</computeroutput></term> + <listitem> + <para> + Message returned if the command was successful. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + There is no <command>ALTER OPERATOR CLASS</command> statement in + the SQL standard. + </para> + </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-createopclass" endterm="sql-createopclass-title"></member> + <member><xref linkend="sql-dropopclass" endterm="sql-dropopclass-title"></member> + </simplelist> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml new file mode 100644 index 00000000000..6e3c78c9c7c --- /dev/null +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -0,0 +1,108 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.1 2003/06/27 14:45:26 petere Exp $ +PostgreSQL documentation +--> + +<refentry id="SQL-ALTERSCHEMA"> + <refmeta> + <refentrytitle id="SQL-ALTERSCHEMA-title">ALTER SCHEMA</refentrytitle> + <refmiscinfo>SQL - Schema Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>ALTER SCHEMA</refname> + <refpurpose>change the definition of a schema</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +ALTER SCHEMA <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable> +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + <command>ALTER SCHEMA</command> changes the definition of a schema. + The only functionality is to rename the schema. To rename a schema + you must own the schema and have the privilege + <literal>CREATE</literal> for the database. + </para> + </refsect1> + + <refsect1> + <title>Parameter</title> + + <variablelist> + <varlistentry> + <term><replaceable>name</replaceable></term> + <listitem> + <para> + Name of a schema + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable>newname</replaceable></term> + <listitem> + <para> + The new name of the schema + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Diagnostics</title> + + <variablelist> + <varlistentry> + <term><computeroutput>ALTER SCHEMA</computeroutput></term> + <listitem> + <para> + Message returned if the alteration was successful. + </para> + </listitem> + </varlistentry> + </variablelist> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + There is no <command>ALTER SCHEMA</command> statement in the SQL + standard. + </para> + </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-createschema" endterm="sql-createschema-title"></member> + <member><xref linkend="sql-dropschema" endterm="sql-dropschema-title"></member> + </simplelist> + </refsect1> + +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 121b4253ac3..95de7a592d5 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.27 2003/04/15 13:25:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.28 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -25,6 +25,8 @@ where <replaceable class="PARAMETER">option</replaceable> can be: | CREATEUSER | NOCREATEUSER | VALID UNTIL '<replaceable class="PARAMETER">abstime</replaceable>' +ALTER USER <replaceable class="PARAMETER">username</replaceable> RENAME TO <replaceable>newname</replaceable> + ALTER USER <replaceable class="PARAMETER">username</replaceable> SET <replaceable>variable</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT } ALTER USER <replaceable class="PARAMETER">username</replaceable> RESET <replaceable>variable</replaceable> </synopsis> @@ -48,7 +50,13 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable> RESET <replacea </para> <para> - The second and the third variant change a user's session default for + The second variant changes the name of the user. Only a database + superuser can rename user accounts. The session user cannot be + renamed. (Connect as a different user if you need to do that.) + </para> + + <para> + The third and the fourth variant change a user's session default for a specified configuration variable. Whenever the user subsequently starts a new session, the specified value becomes the session default, overriding whatever setting is present in <filename>postgresql.conf</> @@ -131,6 +139,15 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable> RESET <replacea </varlistentry> <varlistentry> + <term><replaceable>newname</replaceable></term> + <listitem> + <para> + The new name of the user. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><replaceable>variable</replaceable></term> <term><replaceable>value</replaceable></term> <listitem> diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index 940343efde5..2aff0636713 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_aggregate.sgml,v 1.25 2003/04/22 10:08:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_aggregate.sgml,v 1.26 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -231,14 +231,6 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( </refsect1> <refsect1> - <title>Notes</title> - - <para> - Use <command>DROP AGGREGATE</command> to drop aggregate functions. - </para> - </refsect1> - - <refsect1> <title>Examples</title> <para> @@ -255,6 +247,15 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( standard does not provide for user-defined aggregate function. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-alteraggregate" endterm="sql-alteraggregate-title"></member> + <member><xref linkend="sql-dropaggregate" endterm="sql-dropaggregate-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index b7d73626d67..382c5089832 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_conversion.sgml,v 1.9 2003/06/24 23:29:25 momjian Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_conversion.sgml,v 1.10 2003/06/27 14:45:26 petere Exp $ --> <refentry id="SQL-CREATECONVERSION"> <refmeta> @@ -171,10 +171,11 @@ CREATE CONVERSION myconv FOR 'UNICODE' TO 'LATIN1' FROM myfunc; <refsect1 id="sql-createconversion-seealso"> <title>See Also</title> - <para> - <xref linkend="sql-createfunction" endterm="sql-createfunction-title">, - <xref linkend="sql-dropconversion" endterm="sql-dropconversion-title"> - </para> + <simplelist type="inline"> + <member><xref linkend="sql-alterconversion" endterm="sql-alterconversion-title"></member> + <member><xref linkend="sql-createfunction" endterm="sql-createfunction-title"></member> + <member><xref linkend="sql-dropconversion" endterm="sql-dropconversion-title"></member> + </simplelist> </refsect1> </refentry> diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index c4b26ac3b4e..4e1978c6eec 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.47 2003/04/22 10:08:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.48 2003/06/27 14:45:26 petere Exp $ --> <refentry id="SQL-CREATEFUNCTION"> @@ -404,6 +404,7 @@ CREATE FUNCTION add(integer, integer) RETURNS integer <title>See Also</title> <para> + <xref linkend="sql-alterfunction" endterm="sql-alterfunction-title">, <xref linkend="sql-dropfunction" endterm="sql-dropfunction-title">, <xref linkend="sql-grant" endterm="sql-grant-title">, <xref linkend="sql-load" endterm="sql-load-title">, diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 12e34365b98..d26eb48911d 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_language.sgml,v 1.32 2003/04/22 10:08:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_language.sgml,v 1.33 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -238,16 +238,15 @@ CREATE LANGUAGE plsample <refsect1> <title>See Also</title> - <para> - <simplelist type="inline"> - <member><xref linkend="app-createlang"></member> - <member><xref linkend="sql-createfunction" endterm="sql-createfunction-title"></member> - <member><xref linkend="app-droplang"></member> - <member><xref linkend="sql-droplanguage" endterm="sql-droplanguage-title"></member> - <member><xref linkend="sql-grant" endterm="sql-grant-title"></member> - <member><xref linkend="sql-revoke" endterm="sql-revoke-title"></member> - </simplelist> - </para> + <simplelist type="inline"> + <member><xref linkend="sql-alterlanguage" endterm="sql-alterlanguage-title"></member> + <member><xref linkend="sql-createfunction" endterm="sql-createfunction-title"></member> + <member><xref linkend="sql-droplanguage" endterm="sql-droplanguage-title"></member> + <member><xref linkend="sql-grant" endterm="sql-grant-title"></member> + <member><xref linkend="sql-revoke" endterm="sql-revoke-title"></member> + <member><xref linkend="app-createlang"></member> + <member><xref linkend="app-droplang"></member> + </simplelist> </refsect1> </refentry> diff --git a/doc/src/sgml/ref/create_opclass.sgml b/doc/src/sgml/ref/create_opclass.sgml index 0891edc9adf..eddb8e71287 100644 --- a/doc/src/sgml/ref/create_opclass.sgml +++ b/doc/src/sgml/ref/create_opclass.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_opclass.sgml,v 1.7 2003/04/22 10:08:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_opclass.sgml,v 1.8 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -217,16 +217,6 @@ CREATE OPERATOR CLASS <replaceable class="parameter">name</replaceable> [ DEFAUL </refsect1> <refsect1> - <title>Notes</title> - - <para> - Refer to - <xref linkend="sql-dropopclass" endterm="sql-dropopclass-title"> - to delete user-defined operator classes from a database. - </para> - </refsect1> - - <refsect1> <title>Examples</title> <para> @@ -263,6 +253,15 @@ CREATE OPERATOR CLASS gist__int_ops standard. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-alteropclass" endterm="sql-alteropclass-title"></member> + <member><xref linkend="sql-dropopclass" endterm="sql-dropopclass-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index 9f32a8f342e..e70d29a37b8 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_schema.sgml,v 1.5 2003/04/22 10:08:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_schema.sgml,v 1.6 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -123,10 +123,6 @@ CREATE SCHEMA AUTHORIZATION <replaceable class="parameter">username</replaceable privilege for the current database. (Of course, superusers bypass this check.) </para> - - <para> - Use <command>DROP SCHEMA</command> to remove a schema. - </para> </refsect1> <refsect1> @@ -196,6 +192,16 @@ CREATE VIEW hollywood.winners AS <literal>CREATE</> privilege on his schema to someone else. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-alterschema" endterm="sql-alterschema-title"></member> + <member><xref linkend="sql-dropschema" endterm="sql-dropschema-title"></member> + </simplelist> + </refsect1> + </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/drop_aggregate.sgml b/doc/src/sgml/ref/drop_aggregate.sgml index 539d578653a..49915626a5c 100644 --- a/doc/src/sgml/ref/drop_aggregate.sgml +++ b/doc/src/sgml/ref/drop_aggregate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.22 2003/05/04 02:23:16 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.23 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -124,6 +124,7 @@ DROP AGGREGATE myavg(integer); <title>See Also</title> <simplelist type="inline"> + <member><xref linkend="sql-alteraggregate" endterm="sql-alteraggregate-title"></member> <member><xref linkend="sql-createaggregate" endterm="sql-createaggregate-title"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index 6e785a84a8f..d9c795c445a 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_conversion.sgml,v 1.4 2003/05/04 02:23:16 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_conversion.sgml,v 1.5 2003/06/27 14:45:26 petere Exp $ --> <refentry id="SQL-DROPCONVERSION"> <refmeta> @@ -79,6 +79,7 @@ DROP CONVERSION myname; <title>See Also</title> <simplelist type="inline"> + <member><xref linkend="sql-alterconversion" endterm="sql-alterconversion-title"></member> <member><xref linkend="sql-createconversion" endterm="sql-createconversion-title"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index 10504630ff9..1a62a00f482 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.24 2003/05/04 02:23:16 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.25 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -126,6 +126,7 @@ DROP FUNCTION sqrt(integer); <simplelist type="inline"> <member><xref linkend="sql-createfunction" endterm="sql-createfunction-title"></member> + <member><xref linkend="sql-alterfunction" endterm="sql-alterfunction-title"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 5e7a77f8cf0..ad67a95d442 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.16 2003/05/04 02:23:16 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.17 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -118,7 +118,9 @@ DROP LANGUAGE plsample; <title>See Also</title> <simplelist type="inline"> + <member><xref linkend="sql-alterlanguage" endterm="sql-alterlanguage-title"></member> <member><xref linkend="sql-createlanguage" endterm="sql-createlanguage-title"></member> + <member><xref linkend="app-droplang"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/drop_opclass.sgml b/doc/src/sgml/ref/drop_opclass.sgml index 3e54959a48d..cb0aebd7103 100644 --- a/doc/src/sgml/ref/drop_opclass.sgml +++ b/doc/src/sgml/ref/drop_opclass.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.3 2003/05/04 02:23:16 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.4 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -116,6 +116,7 @@ DROP OPERATOR CLASS widget_ops USING btree; <title>See Also</title> <simplelist type="inline"> + <member><xref linkend="sql-alteropclass" endterm="sql-alteropclass-title"></member> <member><xref linkend="sql-createopclass" endterm="sql-createopclass-title"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index 5411b257991..b8f706b0c77 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_schema.sgml,v 1.2 2003/05/04 02:23:16 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_schema.sgml,v 1.3 2003/06/27 14:45:26 petere Exp $ PostgreSQL documentation --> @@ -120,6 +120,7 @@ DROP SCHEMA mystuff CASCADE; <title>See Also</title> <simplelist type="inline"> + <member><xref linkend="sql-alterschema" endterm="sql-alterschema-title"></member> <member><xref linkend="sql-createschema" endterm="sql-createschema-title"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/reference.sgml b/doc/src/sgml/reference.sgml index 9799489b77e..b7d2cf1c307 100644 --- a/doc/src/sgml/reference.sgml +++ b/doc/src/sgml/reference.sgml @@ -1,5 +1,5 @@ <!-- reference.sgml -$Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.44 2003/03/25 16:15:38 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.45 2003/06/27 14:45:25 petere Exp $ PostgreSQL Reference Manual --> @@ -38,9 +38,15 @@ PostgreSQL Reference Manual </partintro> &abort; + &alterAggregate; + &alterConversion; &alterDatabase; &alterDomain; + &alterFunction; &alterGroup; + &alterLanguage; + &alterOperatorClass; + &alterSchema; &alterSequence; &alterTable; &alterTrigger; |