Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitb256f24

Browse files
committed
First batch of object rename commands.
1 parent5bac7d1 commitb256f24

File tree

60 files changed

+2018
-442
lines changed

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

Lines changed: 7 additions & 32 deletions
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

Lines changed: 128 additions & 0 deletions
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+
-->
Lines changed: 117 additions & 0 deletions
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

Lines changed: 31 additions & 11 deletions
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)
[8]ページ先頭
©2009-2025 Movatter.jp