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

Commite6c1fba

Browse files
author
Thomas G. Lockhart
committed
Add more new pages.
1 parente57cfd8 commite6c1fba

File tree

6 files changed

+837
-0
lines changed

6 files changed

+837
-0
lines changed

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

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -27,6 +27,11 @@
2727
&declare;
2828
&delete;
2929
&dropFunction;
30+
&listen;
31+
&load;
32+
&lock;
33+
&move;
34+
&notify;
3035
&reset;
3136
&revoke;
3237
&rollback;

‎doc/src/sgml/ref/listen.sgml

Lines changed: 148 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,148 @@
1+
<REFENTRY ID="SQL-LISTEN">
2+
<REFMETA>
3+
<REFENTRYTITLE>
4+
LISTEN
5+
</REFENTRYTITLE>
6+
<REFMISCINFO>SQL - Language Statements</REFMISCINFO>
7+
</REFMETA>
8+
<REFNAMEDIV>
9+
<REFNAME>
10+
LISTEN
11+
</REFNAME>
12+
<REFPURPOSE>
13+
Listen for notification on a relation
14+
</REFPURPOSE>
15+
16+
<REFSYNOPSISDIV>
17+
<REFSYNOPSISDIVINFO>
18+
<DATE>1998-09-01</DATE>
19+
</REFSYNOPSISDIVINFO>
20+
<SYNOPSIS>
21+
LISTEN <REPLACEABLE CLASS="PARAMETER">classname</REPLACEABLE>
22+
</SYNOPSIS>
23+
24+
<REFSECT2 ID="R2-SQL-LISTEN-1">
25+
<REFSECT2INFO>
26+
<DATE>1998-09-01</DATE>
27+
</REFSECT2INFO>
28+
<TITLE>
29+
Inputs
30+
</TITLE>
31+
<PARA>
32+
</PARA>
33+
<VARIABLELIST>
34+
<VARLISTENTRY>
35+
<TERM>
36+
<REPLACEABLE CLASS="PARAMETER">classname</REPLACEABLE>
37+
</TERM>
38+
<LISTITEM>
39+
<PARA>
40+
Table object used for notification.
41+
42+
</VARIABLELIST>
43+
44+
</REFSECT2>
45+
46+
<REFSECT2 ID="R2-SQL-LISTEN-2">
47+
<REFSECT2INFO>
48+
<DATE>1998-04-15</DATE>
49+
</REFSECT2INFO>
50+
<TITLE>
51+
Outputs
52+
</TITLE>
53+
<PARA>
54+
</PARA>
55+
<VARIABLELIST>
56+
<VARLISTENTRY>
57+
<TERM>
58+
LISTEN
59+
</TERM>
60+
<LISTITEM>
61+
<PARA>
62+
Message returned upon successful completion of registration.
63+
64+
</VARIABLELIST>
65+
66+
</REFSECT2>
67+
</REFSYNOPSISDIV>
68+
69+
<REFSECT1 ID="R1-SQL-LISTEN-1">
70+
<REFSECT1INFO>
71+
<DATE>1998-04-15</DATE>
72+
</REFSECT1INFO>
73+
<TITLE>
74+
Description
75+
</TITLE>
76+
<PARA>
77+
LISTEN is used to register the current backend as a listener on the relation
78+
<REPLACEABLE CLASS="PARAMETER">classname</REPLACEABLE>.
79+
When the command
80+
<command>NOTIFY <REPLACEABLE CLASS="PARAMETER">classname</REPLACEABLE></command>
81+
is called either from within a rule or at the query level, the
82+
frontend applications corresponding to the listening backends
83+
are notified. When the backend process exits, this registration
84+
is cleared.
85+
86+
<para>
87+
This event notification is performed through the libpq protocol
88+
and frontend application interface. The application program
89+
must call the routine
90+
<function>PQnotifies</function>
91+
in order to find out the name of the class to which a given
92+
notification corresponds. If this code is not included in
93+
the application, the event notification will be queued and
94+
never be processed.
95+
96+
<REFSECT2 ID="R2-SQL-LISTEN-3">
97+
<REFSECT2INFO>
98+
<DATE>1998-04-15</DATE>
99+
</REFSECT2INFO>
100+
<TITLE>
101+
Notes
102+
</TITLE>
103+
<para>
104+
Note that <REPLACEABLE CLASS="PARAMETER">classname</REPLACEABLE>
105+
needs not to be a valid class name but can be any string valid as a name up to 32
106+
characters long.
107+
108+
<para>
109+
A restriction in some previous releases of
110+
<productname>Postgres</productname> that a
111+
<REPLACEABLE CLASS="PARAMETER">classname</REPLACEABLE>
112+
which does not correspond to an actual table must be enclosed in double-quotes
113+
is no longer present.
114+
115+
</REFSECT2>
116+
117+
<REFSECT1 ID="R1-SQL-LISTEN-2">
118+
<TITLE>
119+
Usage
120+
</TITLE>
121+
<PARA>
122+
<ProgramListing>
123+
postgres=> listen virtual;
124+
LISTEN
125+
postgres=> notify virtual;
126+
NOTIFY
127+
ASYNC NOTIFY of 'virtual' from backend pid '11239' received
128+
</ProgramListing>
129+
130+
</REFSECT1>
131+
132+
<REFSECT1 ID="R1-SQL-LISTEN-3">
133+
<TITLE>
134+
Compatibility
135+
</TITLE>
136+
<PARA>
137+
</PARA>
138+
139+
<REFSECT2 ID="R2-SQL-LISTEN-4">
140+
<REFSECT2INFO>
141+
<DATE>1998-09-01</DATE>
142+
</REFSECT2INFO>
143+
<TITLE>
144+
SQL92
145+
</TITLE>
146+
<PARA>
147+
There is no LISTEN statement in <acronym>SQL92</acronym>.
148+
</REFENTRY>

‎doc/src/sgml/ref/load.sgml

Lines changed: 157 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,157 @@
1+
<REFENTRY ID="SQL-LOAD">
2+
<REFMETA>
3+
<REFENTRYTITLE>
4+
LOAD
5+
</REFENTRYTITLE>
6+
<REFMISCINFO>SQL - Language Statements</REFMISCINFO>
7+
</REFMETA>
8+
<REFNAMEDIV>
9+
<REFNAME>
10+
LOAD
11+
</REFNAME>
12+
<REFPURPOSE>
13+
Dynamically loads an object file
14+
</REFPURPOSE>
15+
16+
<REFSYNOPSISDIV>
17+
<REFSYNOPSISDIVINFO>
18+
<DATE>1998-09-01</DATE>
19+
</REFSYNOPSISDIVINFO>
20+
<SYNOPSIS>
21+
<REPLACEABLE CLASS="PARAMETER">
22+
</REPLACEABLE>
23+
LOAD '<REPLACEABLE CLASS="PARAMETER">filename</REPLACEABLE>'
24+
</SYNOPSIS>
25+
26+
<REFSECT2 ID="R2-SQL-LOAD-1">
27+
<REFSECT2INFO>
28+
<DATE>1998-09-01</DATE>
29+
</REFSECT2INFO>
30+
<TITLE>
31+
Inputs
32+
</TITLE>
33+
<PARA>
34+
</PARA>
35+
<VARIABLELIST>
36+
<VARLISTENTRY>
37+
<TERM>
38+
<REPLACEABLE CLASS="PARAMETER">filename</REPLACEABLE>
39+
</TERM>
40+
<LISTITEM>
41+
<PARA>
42+
Object file for dynamic loading.
43+
44+
</VARIABLELIST>
45+
46+
</REFSECT2>
47+
48+
<REFSECT2 ID="R2-SQL-LOAD-2">
49+
<REFSECT2INFO>
50+
<DATE>1998-04-15</DATE>
51+
</REFSECT2INFO>
52+
<TITLE>
53+
Outputs
54+
</TITLE>
55+
<PARA>
56+
</PARA>
57+
<VARIABLELIST>
58+
<VARLISTENTRY>
59+
<TERM>
60+
LOAD
61+
</TERM>
62+
<LISTITEM>
63+
<PARA>
64+
65+
</VARIABLELIST>
66+
67+
</REFSECT2>
68+
</REFSYNOPSISDIV>
69+
70+
<REFSECT1 ID="R1-SQL-LOAD-1">
71+
<REFSECT1INFO>
72+
<DATE>1998-04-15</DATE>
73+
</REFSECT1INFO>
74+
<TITLE>
75+
Description
76+
</TITLE>
77+
<PARA>
78+
Loads an object (or ".o") file into the
79+
<productname>Postgres</productname> backend address space. Once a
80+
file is loaded, all functions in that file can be accessed. This
81+
function is used in support of ADT's.
82+
83+
<para>
84+
If a file is not loaded using
85+
<command>LOAD</command>,
86+
the file will be loaded automatically the first time the
87+
function is called by <productname>Postgres</productname>.
88+
<command>LOAD</command>
89+
can also be used to reload an object file if it has been edited and
90+
recompiled. Only objects created from C language files are supported
91+
at this time.
92+
93+
<REFSECT2 ID="R2-SQL-LOAD-3">
94+
<REFSECT2INFO>
95+
<DATE>1998-04-15</DATE>
96+
</REFSECT2INFO>
97+
<TITLE>
98+
Notes
99+
</TITLE>
100+
<PARA>
101+
Functions in loaded object files should not call functions in other
102+
object files loaded through the
103+
<command>LOAD</command>
104+
command, meaning, for example, that all functions in file A should
105+
call each other, functions in the standard or math libraries, or in
106+
Postgres itself. They should not call functions defined in a different
107+
loaded file B. This is because if B is reloaded, the Postgres loader is
108+
not able to relocate the calls from the functions in A into
109+
the new address space of B. If B is not reloaded, however, there will
110+
not be a problem.
111+
112+
<para>
113+
Object files must be compiled to contain position independent code.
114+
For example,
115+
on DECstations you must use
116+
<application>/bin/cc</application>
117+
with the "-G 0" option when compiling object files to be
118+
loaded.
119+
120+
<para>
121+
Note that if you are porting <productname>Postgres</productname>
122+
to a new platform, <command>LOAD</command>
123+
will have to work in order to support ADTs.
124+
125+
</REFSECT2>
126+
127+
<REFSECT1 ID="R1-SQL-LOAD-2">
128+
<TITLE>
129+
Usage
130+
</TITLE>
131+
<PARA>
132+
<ProgramListing>
133+
--Load the file /usr/postgres/demo/circle.o
134+
--
135+
LOAD "/usr/postgres/demo/circle.o"
136+
</ProgramListing>
137+
138+
</REFSECT1>
139+
140+
<REFSECT1 ID="R1-SQL-LOAD-3">
141+
<TITLE>
142+
Compatibility
143+
</TITLE>
144+
<PARA>
145+
</PARA>
146+
147+
<REFSECT2 ID="R2-SQL-LOAD-4">
148+
<REFSECT2INFO>
149+
<DATE>1998-04-15</DATE>
150+
</REFSECT2INFO>
151+
<TITLE>
152+
SQL92
153+
</TITLE>
154+
<PARA>
155+
There is no LOAD statement in <acronym>SQL92</acronym>.
156+
157+
</REFENTRY>

0 commit comments

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