Skip to content

Commit 9a9f335

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 parent 4835f6a commit 9a9f335

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)