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

Commit9a9f335

Browse files
author
Thomas G. Lockhart
committed
Add information on SET SESSION CHARACTERISTICS.
Fix references to pg_hba.conf(5) since that is no longer a man page.Make minor repairs to "Compatibility" subsections.
1 parent4835f6a commit9a9f335

File tree

8 files changed

+178
-39
lines changed

8 files changed

+178
-39
lines changed

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

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.19 2000/06/18 21:24:51 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.20 2000/07/14 15:27:14 thomas Exp $
33
Postgres documentation
44
Complete list of usable sgml source files in this directory.
55
-->
@@ -98,6 +98,7 @@ Complete list of usable sgml source files in this directory.
9898
<!entity select system "select.sgml">
9999
<!entity selectInto system "select_into.sgml">
100100
<!entity set system "set.sgml">
101+
<!entity setSession system "set_session.sgml">
101102
<!entity setConstraints system "set_constraints.sgml">
102103
<!entity setTransaction system "set_transaction.sgml">
103104
<!entity show system "show.sgml">

‎doc/src/sgml/ref/commands.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.26 2000/06/18 21:24:51 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.27 2000/07/14 15:27:14 thomas Exp $
33
Postgres documentation
44
-->
55

@@ -73,6 +73,7 @@ Postgres documentation
7373
&selectInto;
7474
&set;
7575
&setConstraints;
76+
&setSession;
7677
&setTransaction;
7778
&show;
7879
&truncate;

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.30 2000/06/09 01:43:57 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.31 2000/07/14 15:27:14 thomas Exp $
33
Postgres documentation
44
-->
55

@@ -1849,7 +1849,7 @@ CREATE TABLE distributors (
18491849
<title>
18501850
Compatibility
18511851
</title>
1852-
1852+
18531853
<refsect2 id="R2-SQL-CREATETABLE-4">
18541854
<title>
18551855
SQL92

‎doc/src/sgml/ref/create_user.sgml

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.14 2000/03/27 17:14:42 thomas Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.15 2000/07/14 15:27:14 thomas Exp $
33
Postgres documentation
44
-->
55

@@ -75,7 +75,8 @@ CREATE USER <replaceable class="PARAMETER">username</replaceable>
7575
Sets the user's password. If you do not plan to use password
7676
authentication you can omit this option, otherwise the user
7777
won't be able to connect to a password-authenticated server.
78-
See pg_hba.conf(5) or the administrator's guide for details on
78+
See the chapter on client authentication in the
79+
<citetitle>Administrator's Guide</citetitle> for details on
7980
how to set up authentication mechanisms.
8081
</para>
8182
</listitem>

‎doc/src/sgml/ref/set.sgml

Lines changed: 14 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.45 2000/06/18 21:24:52 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.46 2000/07/14 15:27:14 thomas Exp $
33
Postgres documentation
44
-->
55

@@ -392,13 +392,19 @@ SELECT CURRENT_TIMESTAMP AS today;
392392
<refsect1 id="R1-SQL-SET-3">
393393
<title>Compatibility</title>
394394

395-
<para>
396-
The second syntax shown above (<literal>SET TIME ZONE</literal>)
397-
attempts to mimic <acronym>SQL92</acronym>. However, SQL allows
398-
only numeric time zone offsets. All other parameter settings as
399-
well as the first syntax shown above are a
400-
<productname>Postgres</productname> extension.
401-
</para>
395+
<refsect2 id="R2-SQL-SET-4">
396+
<title>
397+
SQL92
398+
</title>
399+
400+
<para>
401+
The second syntax shown above (<literal>SET TIME ZONE</literal>)
402+
attempts to mimic <acronym>SQL92</acronym>. However, SQL allows
403+
only numeric time zone offsets. All other parameter settings as
404+
well as the first syntax shown above are a
405+
<productname>Postgres</productname> extension.
406+
</para>
407+
</refsect2>
402408
</refsect1>
403409
</refentry>
404410

‎doc/src/sgml/ref/set_constraints.sgml

Lines changed: 28 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.1 2000/06/18 21:24:54 petere Exp $ -->
1+
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.2 2000/07/14 15:27:14 thomas Exp $ -->
22
<refentry id="SQL-SET-CONSTRAINTS">
33
<refmeta>
44
<refentrytitle id="SQL-SET-CONSTRAINTS-title">SET CONSTRAINTS</refentrytitle>
@@ -44,10 +44,33 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">constraint</replaceable>
4444
</para>
4545
</refsect1>
4646

47-
<refsect1>
47+
<refsect1 id="R1-SQL-SET-CONSTRAINT-3">
4848
<title>Compatibility</title>
49-
<para>
50-
SQL92, SQL99
51-
</para>
49+
50+
<refsect2 id="R2-SQL-SET-CONSTRAINT-4">
51+
<title>SQL92, SQL99</title>
52+
53+
<para>
54+
<command>SET CONSTRAINT</command> is defined in
55+
<acronym>SQL92</acronym> and <acronym>SQL99</acronym>.
56+
</para>
57+
</refsect2>
5258
</refsect1>
5359
</refentry>
60+
61+
<!-- Keep this comment at the end of the file
62+
Local variables:
63+
mode:sgml
64+
sgml-omittag:nil
65+
sgml-shorttag:t
66+
sgml-minimize-attributes:nil
67+
sgml-always-quote-attributes:t
68+
sgml-indent-step:1
69+
sgml-indent-data:t
70+
sgml-parent-document:nil
71+
sgml-default-dtd-file:"../reference.ced"
72+
sgml-exposed-tags:nil
73+
sgml-local-catalogs:("/usr/lib/sgml/catalog")
74+
sgml-local-ecat-files:nil
75+
End:
76+
-->

‎doc/src/sgml/ref/set_session.sgml

Lines changed: 91 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,91 @@
1+
<!--
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/set_session.sgml,v 1.1 2000/07/14 15:27:14 thomas Exp $
3+
Postgres documentation
4+
-->
5+
6+
<refentry id="SQL-SET-SESSION">
7+
<refmeta>
8+
<refentrytitle id="SQL-SET-SESSION-TITLE">SET</refentrytitle>
9+
<refmiscinfo>SQL - Language Statements</refmiscinfo>
10+
</refmeta>
11+
<refnamediv>
12+
<refname>SET SESSION CHARACTERISTICS</refname>
13+
<refpurpose>Set per-session run-time parameters</refpurpose>
14+
</refnamediv>
15+
<refsynopsisdiv>
16+
<synopsis>
17+
SET SESSION CHARACTERISTICS TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
18+
SET SESSION CHARACTERISTICS TIME ZONE { '<replaceable class="PARAMETER">timezone</replaceable>' | LOCAL | DEFAULT }
19+
</synopsis>
20+
</refsynopsisdiv>
21+
22+
<refsect1 id="R1-SQL-SET-SESSION-1">
23+
<title>Description</title>
24+
<para>
25+
<command>SET SESSION CHARACTERISTICS</command> changes the run-time
26+
environment for the entire <acronym>SQL</acronym>
27+
session. Currently, transaction isolation level and time zone can
28+
be specified by this command.
29+
</para>
30+
31+
<para>
32+
Use <xref linkend="SQL-SHOW" endterm="SQL-SHOW-title"> to show the
33+
current setting of a parameters.
34+
</para>
35+
36+
<para>
37+
Refer to <xref linkend="SQL-SET-TRANSACTION" endterm="SQL-SET-TRANSACTION-TITLE">
38+
and to <xref linkend="SQL-SET" endterm="SQL-SET-TITLE"> for more
39+
information on allowed parameters.
40+
</para>
41+
</refsect1>
42+
43+
<refsect1>
44+
<title>Examples</title>
45+
46+
<para>
47+
Set the timezone for Berkeley, California, using double quotes to
48+
preserve the uppercase attributes of the time zone specifier (note
49+
that the date/time format is ISO here):
50+
51+
<screen>
52+
SET SESSION CHARACTERISTICS TIME ZONE "PST8PDT";
53+
SELECT CURRENT_TIMESTAMP AS today;
54+
55+
today
56+
------------------------
57+
1998-07-14 07:41:21-07
58+
</screen>
59+
</para>
60+
</refsect1>
61+
62+
<refsect1 id="R1-SQL-SET-SESSION-3">
63+
<title>Compatibility</title>
64+
65+
<refsect2 id="R2-SQL-SET-SESSION-4">
66+
<title>SQL99</title>
67+
68+
<para>
69+
<command>SET SESSION</command> is defined in
70+
<acronym>SQL99</acronym>.
71+
</para>
72+
</refsect2>
73+
</refsect1>
74+
</refentry>
75+
76+
<!-- Keep this comment at the end of the file
77+
Local variables:
78+
mode:sgml
79+
sgml-omittag:nil
80+
sgml-shorttag:t
81+
sgml-minimize-attributes:nil
82+
sgml-always-quote-attributes:t
83+
sgml-indent-step:1
84+
sgml-indent-data:t
85+
sgml-parent-document:nil
86+
sgml-default-dtd-file:"../reference.ced"
87+
sgml-exposed-tags:nil
88+
sgml-local-catalogs:("/usr/lib/sgml/catalog")
89+
sgml-local-ecat-files:nil
90+
End:
91+
-->

‎doc/src/sgml/ref/set_transaction.sgml

Lines changed: 36 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
1-
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.1 2000/06/18 21:24:54 petere Exp $ -->
1+
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.2 2000/07/14 15:27:14 thomas Exp $ -->
22
<refentry id="SQL-SET-TRANSACTION">
33
<refmeta>
4-
<refentrytitle id="SQL-SET-TRANSACTION-title">SET TRANSACTION</refentrytitle>
4+
<refentrytitle id="SQL-SET-TRANSACTION-TITLE">SET TRANSACTION</refentrytitle>
55
<refmiscinfo>SQL - Language Statements</refmiscinfo>
66
</refmeta>
77
<refnamediv>
@@ -66,28 +66,44 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
6666
</para>
6767
</refsect1>
6868

69-
<refsect1>
69+
<refsect1 id="R1-SQL-SET-TRANSACTION-3">
7070
<title>Compatibility</title>
7171

72-
<para>
73-
SQL92, SQL99
74-
</para>
72+
<refsect2 id="R2-SQL-SET-TRANSACTION-4">
73+
<title>SQL92, SQL99</title>
7574

76-
<para>
77-
SERIALIZABLE is the default level in <acronym>SQL</acronym>.
78-
Postgres does not provide the isolation levels <option>READ
79-
UNCOMMITTED</option> and <option>REPEATABLE READ</option>. Because
80-
of multi-version concurrency control, the serializable level is not
81-
truly serializable. See the <citetitle>User's Guide</citetitle> for
82-
details.
83-
</para>
75+
<para>
76+
SERIALIZABLE is the default level in <acronym>SQL</acronym>.
77+
Postgres does not provide the isolation levels <option>READ
78+
UNCOMMITTED</option> and <option>REPEATABLE READ</option>. Because
79+
of multi-version concurrency control, the serializable level is not
80+
truly serializable. See the <citetitle>User's Guide</citetitle> for
81+
details.
82+
</para>
8483

85-
<para>
86-
In <acronym>SQL</acronym> there are two other transaction
87-
characteristics that can be set with this command: whether the
88-
transaction is read-only and the size of the diagnostics area.
89-
Neither of these concepts are supported in Postgres.
90-
</para>
84+
<para>
85+
In <acronym>SQL</acronym> there are two other transaction
86+
characteristics that can be set with this command: whether the
87+
transaction is read-only and the size of the diagnostics area.
88+
Neither of these concepts are supported in Postgres.
89+
</para>
90+
</refsect2>
9191
</refsect1>
9292
</refentry>
9393

94+
<!-- Keep this comment at the end of the file
95+
Local variables:
96+
mode:sgml
97+
sgml-omittag:nil
98+
sgml-shorttag:t
99+
sgml-minimize-attributes:nil
100+
sgml-always-quote-attributes:t
101+
sgml-indent-step:1
102+
sgml-indent-data:t
103+
sgml-parent-document:nil
104+
sgml-default-dtd-file:"../reference.ced"
105+
sgml-exposed-tags:nil
106+
sgml-local-catalogs:("/usr/lib/sgml/catalog")
107+
sgml-local-ecat-files:nil
108+
End:
109+
-->

0 commit comments

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