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

Commit62651c0

Browse files
committed
Editorial work on xfunc chapter --- better explanations about SQL
functions handling composite types and sets, various minor cleanups.
1 parentb93939a commit62651c0

File tree

3 files changed

+289
-152
lines changed

3 files changed

+289
-152
lines changed

‎doc/src/sgml/dfunc.sgml‎

Lines changed: 12 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,15 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/dfunc.sgml,v 1.14 2001/05/19 09:01:10 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/dfunc.sgml,v 1.15 2001/10/26 19:58:12 tgl Exp $
33
-->
44

55
<sect2 id="dfunc">
66
<title id="dfunc-title">Compiling and Linking Dynamically-Loaded Functions</title>
77

88
<para>
99
Before you are able to use your
10-
<productname>PostgreSQL</productname> extensionfunction written in
11-
C theyneed tobe compiled and linked in a special wayin order to
12-
allow it tobe dynamically loaded as needed by the server. To be
10+
<productname>PostgreSQL</productname> extensionfunctions written in
11+
C, theymustbe compiled and linked in a special wayto produce a file
12+
that canbe dynamically loaded by the server. To be
1313
precise, a <firstterm>shared library</firstterm> needs to be created.
1414
</para>
1515

@@ -31,7 +31,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/dfunc.sgml,v 1.14 2001/05/19 09:01:10 peter
3131
be created as <firstterm>position-independent code</firstterm>
3232
(<acronym>PIC</acronym>), which conceptually means that they can be
3333
placed at an arbitrary location in memory when they are loaded by the
34-
executable. (Object files intended for executables are not compiled
34+
executable. (Object files intended for executables areusuallynot compiled
3535
that way.) The command to link a shared library contains special
3636
flags to distinguish it from linking an executable. --- At least
3737
this is the theory. On some systems the practice is much uglier.
@@ -263,16 +263,14 @@ gcc -shared -o foo.so foo.o
263263
The resulting shared library file can then be loaded into
264264
<productname>Postgres</productname>. When specifying the file name
265265
to the <command>CREATE FUNCTION</command> command, one must give it
266-
the name of the shared library file (ending in
267-
<filename>.so</filename>) rather than the intermediate object file.
268-
269-
<note>
270-
<para>
271-
Actually, <productname>Postgres</productname> does not care what
272-
you name the file as long as it is a shared library file.
273-
</para>
274-
</note>
266+
the name of the shared library file, not the intermediate object file.
267+
Note that the system's standard shared-library extension (usually
268+
<literal>.so</literal> or <literal>.sl</literal>) can be omitted from
269+
the <command>CREATE FUNCTION</command> command, and normally should
270+
be omitted for best portability.
271+
</para>
275272

273+
<para>
276274
Refer back to <xref linkend="xfunc-c-dynload"> about where the
277275
server expects to find the shared library files.
278276
</para>

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

Lines changed: 14 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/load.sgml,v 1.9 2001/09/03 12:57:50 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/load.sgml,v 1.10 2001/10/26 19:58:12 tgl Exp $
33
-->
44

55
<refentry id="SQL-LOAD">
@@ -10,7 +10,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/ref/load.sgml,v 1.9 2001/09/03 12:57:50 pet
1010

1111
<refnamediv>
1212
<refname>LOAD</refname>
13-
<refpurpose>load or reload a sharedobject file</refpurpose>
13+
<refpurpose>load or reload a sharedlibrary file</refpurpose>
1414
</refnamediv>
1515

1616
<refsynopsisdiv>
@@ -23,13 +23,22 @@ LOAD '<replaceable class="PARAMETER">filename</replaceable>'
2323
<title>Description</title>
2424

2525
<para>
26-
Loads a sharedobject file into the PostgreSQL backend's address
26+
Loads a sharedlibrary file into the PostgreSQL backend's address
2727
space. If the file had been loaded previously, it is first
2828
unloaded. This command is primarily useful to unload and reload a
29-
shared object file if it has been changed. To make use of the
30-
shared object, a function needs to be declared using the <xref
29+
shared library file that has been changed since the backend first
30+
loaded it. To make use of the
31+
shared library, function(s) in it need to be declared using the <xref
3132
linkend="sql-createfunction"> command.
3233
</para>
34+
35+
<para>
36+
The filename is specified in the same way as for shared library
37+
names in <xref linkend="sql-createfunction">; in particular, one
38+
may rely on a search path and automatic addition of the system's standard
39+
shared library filename extension. See the
40+
<citetitle>Programmer's Guide</citetitle> for more detail.
41+
</para>
3342
</refsect1>
3443

3544
<refsect1 id="sql-load-compat">

0 commit comments

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