Skip to content

Commit b256f24

Browse files
peterepetere
committed
First batch of object rename commands.
1 parent 5bac7d1 commit b256f24

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

60 files changed

+2018
-442
lines changed

‎doc/src/sgml/ref/allfiles.sgml

+7-32
Original file line numberDiff line numberDiff line change
@@ -1,45 +1,20 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.53 2003/03/20 07:02:07 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.54 2003/06/27 14:45:25 petere Exp $
33
PostgreSQL documentation
44
Complete list of usable sgml source files in this directory.
55
-->
66

7-
<!-- these will go into the "operators" reference chapter -->
8-
<!entity all system "all.sgml">
9-
<!entity any system "any.sgml">
10-
<!entity between system "between.sgml">
11-
<!entity in system "in.sgml">
12-
<!entity like system "like.sgml">
13-
14-
<!-- these will go into the "functions" reference chapter -->
15-
<!entity avg system "avg.sgml">
16-
<!entity cast system "cast.sgml">
17-
<!entity charLength system "char_length.sgml">
18-
<!entity count system "count.sgml">
19-
<!entity currentDate system "current_date.sgml">
20-
<!entity currentTime system "current_time.sgml">
21-
<!entity currentTimestamp system "current_timestamp.sgml">
22-
<!entity currentUser system "current_user.sgml">
23-
<!entity exists system "exists.sgml">
24-
<!entity extract system "extract.sgml">
25-
<!entity initcap system "initcap.sgml">
26-
<!entity lower system "lower.sgml">
27-
<!entity lpad system "lpad.sgml">
28-
<!entity max system "max.sgml">
29-
<!entity min system "min.sgml">
30-
<!entity position system "position.sgml">
31-
<!entity rpad system "rpad.sgml">
32-
<!entity substring system "substring.sgml">
33-
<!entity sum system "sum.sgml">
34-
<!entity translate system "translate.sgml">
35-
<!entity trim system "trim.sgml">
36-
<!entity upper system "upper.sgml">
37-
387
<!-- SQL commands -->
398
<!entity abort system "abort.sgml">
9+
<!entity alterAggregate system "alter_aggregate.sgml">
10+
<!entity alterConversion system "alter_conversion.sgml">
4011
<!entity alterDatabase system "alter_database.sgml">
4112
<!entity alterDomain system "alter_domain.sgml">
13+
<!entity alterFunction system "alter_function.sgml">
4214
<!entity alterGroup system "alter_group.sgml">
15+
<!entity alterLanguage system "alter_language.sgml">
16+
<!entity alterOperatorClass system "alter_opclass.sgml">
17+
<!entity alterSchema system "alter_schema.sgml">
4318
<!entity alterSequence system "alter_sequence.sgml">
4419
<!entity alterTable system "alter_table.sgml">
4520
<!entity alterTrigger system "alter_trigger.sgml">

‎doc/src/sgml/ref/alter_aggregate.sgml

+128
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,128 @@
1+
<!--
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_aggregate.sgml,v 1.1 2003/06/27 14:45:25 petere Exp $
3+
PostgreSQL documentation
4+
-->
5+
6+
<refentry id="SQL-ALTERAGGREGATE">
7+
<refmeta>
8+
<refentrytitle id="SQL-ALTERAGGREGATE-TITLE">ALTER AGGREGATE</refentrytitle>
9+
<refmiscinfo>SQL - Language Statements</refmiscinfo>
10+
</refmeta>
11+
12+
<refnamediv>
13+
<refname>ALTER AGGREGATE</refname>
14+
<refpurpose>change the definition of an aggregate function</refpurpose>
15+
</refnamediv>
16+
17+
<refsynopsisdiv>
18+
<synopsis>
19+
ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable> ) RENAME TO <replaceable>newname</replaceable>
20+
</synopsis>
21+
</refsynopsisdiv>
22+
23+
<refsect1>
24+
<title>Description</title>
25+
26+
<para>
27+
<command>ALTER AGGREGATE</command> changes the definition of an
28+
aggregate function. The only functionality is to rename the
29+
aggregate function.
30+
</para>
31+
</refsect1>
32+
33+
<refsect1>
34+
<title>Parameters</title>
35+
36+
<variablelist>
37+
<varlistentry>
38+
<term><replaceable class="parameter">name</replaceable></term>
39+
<listitem>
40+
<para>
41+
The name (optionally schema-qualified) of an existing aggregate function.
42+
</para>
43+
</listitem>
44+
</varlistentry>
45+
46+
<varlistentry>
47+
<term><replaceable class="parameter">type</replaceable></term>
48+
<listitem>
49+
<para>
50+
The argument data type of the aggregate function, or
51+
<literal>*</literal> if the function accepts any data type.
52+
</para>
53+
</listitem>
54+
</varlistentry>
55+
56+
<varlistentry>
57+
<term><replaceable class="parameter">newname</replaceable></term>
58+
<listitem>
59+
<para>
60+
The new name of the aggregate function.
61+
</para>
62+
</listitem>
63+
</varlistentry>
64+
</variablelist>
65+
</refsect1>
66+
67+
<refsect1>
68+
<title>Diagnostics</title>
69+
70+
<variablelist>
71+
<varlistentry>
72+
<term><computeroutput>ALTER AGGREGATE</computeroutput></term>
73+
<listitem>
74+
<para>
75+
Message returned if the command was successful.
76+
</para>
77+
</listitem>
78+
</varlistentry>
79+
</variablelist>
80+
</refsect1>
81+
82+
<refsect1>
83+
<title>Examples</title>
84+
85+
<para>
86+
To rename the aggregate function <literal>myavg</literal> for type
87+
<type>integer</type> to <literal>my_average</literal>:
88+
<programlisting>
89+
ALTER AGGREGATE myavg(integer) RENAME TO my_average;
90+
</programlisting>
91+
</para>
92+
</refsect1>
93+
94+
<refsect1>
95+
<title>Compatibility</title>
96+
97+
<para>
98+
There is no <command>ALTER AGGREGATE</command> statement in the SQL
99+
standard.
100+
</para>
101+
</refsect1>
102+
103+
<refsect1>
104+
<title>See Also</title>
105+
106+
<simplelist type="inline">
107+
<member><xref linkend="sql-createaggregate" endterm="sql-createaggregate-title"></member>
108+
<member><xref linkend="sql-dropaggregate" endterm="sql-dropaggregate-title"></member>
109+
</simplelist>
110+
</refsect1>
111+
</refentry>
112+
113+
<!-- Keep this comment at the end of the file
114+
Local variables:
115+
mode: sgml
116+
sgml-omittag:nil
117+
sgml-shorttag:t
118+
sgml-minimize-attributes:nil
119+
sgml-always-quote-attributes:t
120+
sgml-indent-step:1
121+
sgml-indent-data:t
122+
sgml-parent-document:nil
123+
sgml-default-dtd-file:"../reference.ced"
124+
sgml-exposed-tags:nil
125+
sgml-local-catalogs:"/usr/lib/sgml/catalog"
126+
sgml-local-ecat-files:nil
127+
End:
128+
-->

‎doc/src/sgml/ref/alter_conversion.sgml

+117
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,117 @@
1+
<!--
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_conversion.sgml,v 1.1 2003/06/27 14:45:25 petere Exp $
3+
PostgreSQL documentation
4+
-->
5+
6+
<refentry id="SQL-ALTERCONVERSION">
7+
<refmeta>
8+
<refentrytitle id="SQL-ALTERCONVERSION-TITLE">ALTER CONVERSION</refentrytitle>
9+
<refmiscinfo>SQL - Language Statements</refmiscinfo>
10+
</refmeta>
11+
12+
<refnamediv>
13+
<refname>ALTER CONVERSION</refname>
14+
<refpurpose>change the definition of a conversion</refpurpose>
15+
</refnamediv>
16+
17+
<refsynopsisdiv>
18+
<synopsis>
19+
ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable>
20+
</synopsis>
21+
</refsynopsisdiv>
22+
23+
<refsect1>
24+
<title>Description</title>
25+
26+
<para>
27+
<command>ALTER CONVERSION</command> changes the definition of a
28+
conversion. The only functionality is to rename the conversion.
29+
</para>
30+
</refsect1>
31+
32+
<refsect1>
33+
<title>Parameters</title>
34+
35+
<variablelist>
36+
<varlistentry>
37+
<term><replaceable class="parameter">name</replaceable></term>
38+
<listitem>
39+
<para>
40+
The name (optionally schema-qualified) of an existing conversion.
41+
</para>
42+
</listitem>
43+
</varlistentry>
44+
45+
<varlistentry>
46+
<term><replaceable class="parameter">newname</replaceable></term>
47+
<listitem>
48+
<para>
49+
The new name of the conversion.
50+
</para>
51+
</listitem>
52+
</varlistentry>
53+
</variablelist>
54+
</refsect1>
55+
56+
<refsect1>
57+
<title>Diagnostics</title>
58+
59+
<variablelist>
60+
<varlistentry>
61+
<term><computeroutput>ALTER CONVERSION</computeroutput></term>
62+
<listitem>
63+
<para>
64+
Message returned if the command was successful.
65+
</para>
66+
</listitem>
67+
</varlistentry>
68+
</variablelist>
69+
</refsect1>
70+
71+
<refsect1>
72+
<title>Examples</title>
73+
74+
<para>
75+
To rename the conversion <literal>iso_8859_1_to_utf_8</literal> to
76+
<literal>latin1_to_unicode</literal>:
77+
<programlisting>
78+
ALTER CONVERSION iso_8859_1_to_utf_8 RENAME TO latin1_to_unicode;
79+
</programlisting>
80+
</para>
81+
</refsect1>
82+
83+
<refsect1>
84+
<title>Compatibility</title>
85+
86+
<para>
87+
There is no <command>ALTER CONVERSION</command> statement in the SQL
88+
standard.
89+
</para>
90+
</refsect1>
91+
92+
<refsect1>
93+
<title>See Also</title>
94+
95+
<simplelist type="inline">
96+
<member><xref linkend="sql-createconversion" endterm="sql-createconversion-title"></member>
97+
<member><xref linkend="sql-dropconversion" endterm="sql-dropconversion-title"></member>
98+
</simplelist>
99+
</refsect1>
100+
</refentry>
101+
102+
<!-- Keep this comment at the end of the file
103+
Local variables:
104+
mode: sgml
105+
sgml-omittag:nil
106+
sgml-shorttag:t
107+
sgml-minimize-attributes:nil
108+
sgml-always-quote-attributes:t
109+
sgml-indent-step:1
110+
sgml-indent-data:t
111+
sgml-parent-document:nil
112+
sgml-default-dtd-file:"../reference.ced"
113+
sgml-exposed-tags:nil
114+
sgml-local-catalogs:"/usr/lib/sgml/catalog"
115+
sgml-local-ecat-files:nil
116+
End:
117+
-->

‎doc/src/sgml/ref/alter_database.sgml

+31-11
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.6 2003/04/15 13:25:08 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.7 2003/06/27 14:45:25 petere Exp $
33
PostgreSQL documentation
44
-->
55

@@ -18,27 +18,38 @@ PostgreSQL documentation
1818
<synopsis>
1919
ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> SET <replaceable>variable</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT }
2020
ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replaceable>variable</replaceable>
21+
22+
ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>newname</replaceable>
2123
</synopsis>
2224
</refsynopsisdiv>
2325

2426
<refsect1>
2527
<title>Description</title>
2628

2729
<para>
28-
<command>ALTER DATABASE</command> is used to change the session
29-
default of a run-time configuration variable for a
30-
<productname>PostgreSQL</productname> database. Whenever a new
31-
session is subsequently started in that database, the specified
32-
value becomes the session default value.
33-
The database-specific default
34-
overrides whatever setting is present in <filename>postgresql.conf</>
35-
or has been received from the <command>postmaster</command> command line.
30+
<command>ALTER DATABASE</command> is used to change the attributes
31+
of a database.
3632
</para>
3733

3834
<para>
39-
Only the database owner or a superuser can change the session defaults for a
35+
The first two forms change the session default of a run-time
36+
configuration variable for a <productname>PostgreSQL</productname>
37+
database. Whenever a new session is subsequently started in that
38+
database, the specified value becomes the session default value.
39+
The database-specific default overrides whatever setting is present
40+
in <filename>postgresql.conf</> or has been received from the
41+
<command>postmaster</command> command line. Only the database
42+
owner or a superuser can change the session defaults for a
4043
database.
4144
</para>
45+
46+
<para>
47+
The third form changes the name of the database. Only the database
48+
owner can rename a database, and only if he has the
49+
<literal>CREATEDB</literal> privilege. The current database cannot
50+
be renamed. (Connect to a different database if you need to do
51+
that.)
52+
</para>
4253
</refsect1>
4354

4455
<refsect1>
@@ -76,7 +87,16 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replacea
7687
</para>
7788
</listitem>
7889
</varlistentry>
79-
</variablelist>
90+
91+
<varlistentry>
92+
<term><replaceable>newname</replaceable></term>
93+
<listitem>
94+
<para>
95+
The new name of the database.
96+
</para>
97+
</listitem>
98+
</varlistentry>
99+
</variablelist>
80100
</refsect1>
81101

82102
<refsect1>

0 commit comments

Comments
 (0)