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

Commit1ac838e

Browse files
author
Thomas G. Lockhart
committed
Minor updates for release.
Split reference pages for CREATE TABLE AS and SELECT INTO to allow psgml (the emacs parser) to handle parsing.
1 parent5e84d58 commit1ac838e

19 files changed

+2988
-2810
lines changed

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

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -72,6 +72,7 @@
7272
<!entity createRule system "create_rule.sgml">
7373
<!entity createSequence system "create_sequence.sgml">
7474
<!entity createTable system "create_table.sgml">
75+
<!entity createTableAs system "create_table_as.sgml">
7576
<!entity createTrigger system "create_trigger.sgml">
7677
<!entity createType system "create_type.sgml">
7778
<!entity createUser system "create_user.sgml">
@@ -104,6 +105,7 @@
104105
<!entity revoke system "revoke.sgml">
105106
<!entity rollback system "rollback.sgml">
106107
<!entity select system "select.sgml">
108+
<!entity selectInto system "select_into.sgml">
107109
<!entity set system "set.sgml">
108110
<!entity show system "show.sgml">
109111
<!entity unlisten system "unlisten.sgml">

‎doc/src/sgml/ref/alter_user.sgml‎

Lines changed: 128 additions & 128 deletions
Original file line numberDiff line numberDiff line change
@@ -1,22 +1,22 @@
1-
<REFENTRY ID="SQL-ALTERUSER">
2-
<REFMETA>
3-
<REFENTRYTITLE>
1+
<refentry id="SQL-ALTERUSER">
2+
<refmeta>
3+
<refentrytitle>
44
ALTER USER
5-
</REFENTRYTITLE>
6-
<REFMISCINFO>SQL - Language Statements</REFMISCINFO>
7-
</REFMETA>
8-
<REFNAMEDIV>
9-
<REFNAME>
5+
</refentrytitle>
6+
<refmiscinfo>SQL - Language Statements</refmiscinfo>
7+
</refmeta>
8+
<refnamediv>
9+
<refname>
1010
ALTER USER
11-
</REFNAME>
12-
<REFPURPOSE>
11+
</refname>
12+
<refpurpose>
1313
Modifies user account information
14-
</REFPURPOSE>
14+
</refpurpose>
1515
</refnamediv>
16-
<REFSYNOPSISDIV>
17-
<REFSYNOPSISDIVINFO>
18-
<DATE>1998-09-08</DATE>
19-
</REFSYNOPSISDIVINFO>
16+
<refsynopsisdiv>
17+
<refsynopsisdivinfo>
18+
<date>1998-09-08</date>
19+
</refsynopsisdivinfo>
2020
<synopsis>
2121
ALTER USER <replaceable class="PARAMETER">username</replaceable>
2222
[ WITH PASSWORD <replaceable class="PARAMETER">password</replaceable> ]
@@ -26,109 +26,109 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable>
2626
[ VALID UNTIL '<replaceable class="PARAMETER">abstime</replaceable>' ]
2727
</synopsis>
2828

29-
<REFSECT2 ID="R2-SQL-ALTERUSER-1">
30-
<REFSECT2INFO>
31-
<DATE>1998-09-08</DATE>
32-
</REFSECT2INFO>
33-
<TITLE>
29+
<refsect2 id="R2-SQL-ALTERUSER-1">
30+
<refsect2info>
31+
<date>1998-09-08</date>
32+
</refsect2info>
33+
<title>
3434
Inputs
35-
</TITLE>
36-
<PARA>
35+
</title>
36+
<para>
3737
Refer to <command>CREATE USER</command> for a detailed description of each
3838
clause.
3939
</para>
40-
<VARIABLELIST>
41-
<VARLISTENTRY>
42-
<TERM>
43-
<REPLACEABLE CLASS="PARAMETER"> username </REPLACEABLE>
44-
</TERM>
45-
<LISTITEM>
46-
<PARA>
40+
<variablelist>
41+
<varlistentry>
42+
<term>
43+
<replaceable class="PARAMETER"> username </replaceable>
44+
</term>
45+
<listitem>
46+
<para>
4747
The Postgres account name of the user whose details are to be altered.
48-
</PARA>
49-
</LISTITEM>
50-
</VARLISTENTRY>
48+
</para>
49+
</listitem>
50+
</varlistentry>
5151

52-
<VARLISTENTRY>
53-
<TERM>
54-
<REPLACEABLE CLASS="PARAMETER"> password </REPLACEABLE>
55-
</TERM>
56-
<LISTITEM>
57-
<PARA>
52+
<varlistentry>
53+
<term>
54+
<replaceable class="PARAMETER"> password </replaceable>
55+
</term>
56+
<listitem>
57+
<para>
5858
The new password to be used for this account.
59-
</PARA>
60-
</LISTITEM>
61-
</VARLISTENTRY>
59+
</para>
60+
</listitem>
61+
</varlistentry>
6262

63-
<VARLISTENTRY>
64-
<TERM>
65-
<REPLACEABLE CLASS="PARAMETER"> groupname </REPLACEABLE>
66-
</TERM>
67-
<LISTITEM>
68-
<PARA>
63+
<varlistentry>
64+
<term>
65+
<replaceable class="PARAMETER"> groupname </replaceable>
66+
</term>
67+
<listitem>
68+
<para>
6969
The name of an access group into which this account is to be put.
70-
</PARA>
71-
</LISTITEM>
72-
</VARLISTENTRY>
70+
</para>
71+
</listitem>
72+
</varlistentry>
7373

74-
<VARLISTENTRY>
75-
<TERM>
76-
<REPLACEABLE CLASS="PARAMETER"> abstime </REPLACEABLE>
77-
</TERM>
78-
<LISTITEM>
79-
<PARA>
74+
<varlistentry>
75+
<term>
76+
<replaceable class="PARAMETER"> abstime </replaceable>
77+
</term>
78+
<listitem>
79+
<para>
8080
The date (and, optionally, the time)
8181
at which this user's access is to be terminated.
82-
</PARA>
83-
</LISTITEM>
84-
</VARLISTENTRY>
85-
</VARIABLELIST>
86-
</REFSECT2>
82+
</para>
83+
</listitem>
84+
</varlistentry>
85+
</variablelist>
86+
</refsect2>
8787

88-
<REFSECT2 ID="R2-SQL-ALTERUSER-2">
89-
<REFSECT2INFO>
90-
<DATE>1998-09-08</DATE>
91-
</REFSECT2INFO>
92-
<TITLE>
88+
<refsect2 id="R2-SQL-ALTERUSER-2">
89+
<refsect2info>
90+
<date>1998-09-08</date>
91+
</refsect2info>
92+
<title>
9393
Outputs
94-
</TITLE>
95-
<PARA>
96-
<VARIABLELIST>
97-
<VARLISTENTRY>
98-
<TERM>
94+
</title>
95+
<para>
96+
<variablelist>
97+
<varlistentry>
98+
<term>
9999
<returnvalue>ALTER USER</returnvalue>
100-
</TERM>
101-
<LISTITEM>
102-
<PARA>
100+
</term>
101+
<listitem>
102+
<para>
103103
Message returned if the alteration was successful.
104-
</PARA>
105-
</LISTITEM>
106-
</VARLISTENTRY>
104+
</para>
105+
</listitem>
106+
</varlistentry>
107107

108-
<VARLISTENTRY>
109-
<TERM>
108+
<varlistentry>
109+
<term>
110110
<returnvalue>ERROR: alterUser: user "username" does not exist</returnvalue>
111-
</TERM>
112-
<LISTITEM>
113-
<PARA>
111+
</term>
112+
<listitem>
113+
<para>
114114
Error message returned if the user specified doesn't
115115
exist.
116116
</para>
117117
</listitem>
118118
</varlistentry>
119119
</variablelist>
120120
</para>
121-
</REFSECT2>
122-
</REFSYNOPSISDIV>
121+
</refsect2>
122+
</refsynopsisdiv>
123123

124-
<REFSECT1 ID="R1-SQL-ALTERUSER-1">
125-
<REFSECT1INFO>
126-
<DATE>1998-09-08</DATE>
127-
</REFSECT1INFO>
128-
<TITLE>
124+
<refsect1 id="R1-SQL-ALTERUSER-1">
125+
<refsect1info>
126+
<date>1998-09-08</date>
127+
</refsect1info>
128+
<title>
129129
Description
130-
</TITLE>
131-
<PARA>
130+
</title>
131+
<para>
132132
<command>ALTER USER</command> is used to change the attributes of a user's
133133
<productname>Postgres</productname> account.
134134
Please note that it is not possible
@@ -137,21 +137,21 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable>
137137
<productname>Postgres</productname>
138138
user or any user with read and modify permissions on
139139
"pg_shadow" to alter user passwords.
140-
</PARA>
140+
</para>
141141
<para>
142142
If any of the clauses of the alter user statement are
143143
omitted, the corresponding value in the "pg_shadow" table
144144
is left unchanged.
145145
</para>
146146

147-
<REFSECT2 ID="R2-SQL-ALTERUSER-3">
148-
<REFSECT2INFO>
149-
<DATE>1998-09-08</DATE>
150-
</REFSECT2INFO>
151-
<TITLE>
147+
<refsect2 id="R2-SQL-ALTERUSER-3">
148+
<refsect2info>
149+
<date>1998-09-08</date>
150+
</refsect2info>
151+
<title>
152152
Notes
153-
</TITLE>
154-
<PARA>
153+
</title>
154+
<para>
155155
<command>ALTER USER</command> statement
156156
is a <productname>Postgres</productname>
157157
language extension.
@@ -162,37 +162,37 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable>
162162
account.
163163
</para>
164164
<para>
165-
In the current release (v6.4), the IN GROUP clause is parsed
165+
In the current release (v6.5), the IN GROUP clause is parsed
166166
but has no affect. When it is fully implemented, it is
167167
intended to modify the pg_group relation.
168168
</para>
169-
</REFSECT2>
169+
</refsect2>
170170
</refsect1>
171171

172-
<REFSECT1 ID="R1-SQL-ALTERUSER-2">
173-
<TITLE>
172+
<refsect1 id="R1-SQL-ALTERUSER-2">
173+
<title>
174174
Usage
175-
</TITLE>
176-
<PARA>
175+
</title>
176+
<para>
177177
Change a user password
178-
</PARA>
179-
<ProgramListing>
178+
</para>
179+
<programlisting>
180180
ALTER USER davide WITH PASSWORD hu8jmn3;
181-
</ProgramListing>
181+
</programlisting>
182182
<para>
183183
Change a user's valid until date
184184
</para>
185-
<ProgramListing>
185+
<programlisting>
186186
ALTER USER manuel VALID UNTIL 'Jan 31 2030';
187-
</ProgramListing>
187+
</programlisting>
188188
<para>
189189
Change a user's valid until date, specifying that his
190190
authorisation should expire at midday on 4th May 1998 using
191191
the time zone which is one hour ahead of UTC
192192
</para>
193-
<ProgramListing>
193+
<programlisting>
194194
ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';
195-
</ProgramListing>
195+
</programlisting>
196196
<para>
197197
Give a user the ability to create other users and new databases.
198198
</para>
@@ -205,36 +205,36 @@ ALTER USER miriam CREATEUSER CREATEDB;
205205
<programlisting>
206206
ALTER USER miriam IN GROUP sales, payroll;
207207
</programlisting>
208-
</REFSECT1>
208+
</refsect1>
209209

210-
<REFSECT1 ID="R1-SQL-ALTERUSER-3">
211-
<TITLE>
210+
<refsect1 id="R1-SQL-ALTERUSER-3">
211+
<title>
212212
Compatibility
213-
</TITLE>
214-
<PARA>
215-
</PARA>
213+
</title>
214+
<para>
215+
</para>
216216

217-
<REFSECT2 ID="R2-SQL-ALTERUSER-4">
218-
<REFSECT2INFO>
219-
<DATE>1998-09-08</DATE>
220-
</REFSECT2INFO>
221-
<TITLE>
217+
<refsect2 id="R2-SQL-ALTERUSER-4">
218+
<refsect2info>
219+
<date>1998-09-08</date>
220+
</refsect2info>
221+
<title>
222222
SQL92
223-
</TITLE>
224-
<PARA>
223+
</title>
224+
<para>
225225
There is no <command>ALTER USER</command> statement in
226226
<acronym>SQL92</acronym>.
227227
The standard leaves
228228
the definition of users to the implementation.
229-
</PARA>
229+
</para>
230230
</refsect2>
231231
</refsect1>
232-
</REFENTRY>
232+
</refentry>
233233

234234
<!-- Keep this comment at the end of the file
235235
Local variables:
236236
mode: sgml
237-
sgml-omittag:t
237+
sgml-omittag:nil
238238
sgml-shorttag:t
239239
sgml-minimize-attributes:nil
240240
sgml-always-quote-attributes:t

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp