|
7 | 7 | * And contributors: |
8 | 8 | * Darko Prenosil <Darko.Prenosil@finteh.hr> |
9 | 9 | * Shridhar Daithankar <shridhar_daithankar@persistent.co.in> |
| 10 | + * Kai Londenberg (K.Londenberg@librics.de) |
10 | 11 | * |
11 | 12 | * Copyright (c) 2001-2006, PostgreSQL Global Development Group |
12 | 13 | * ALL RIGHTS RESERVED; |
|
31 | 32 | */ |
32 | 33 |
|
33 | 34 | Release Notes: |
| 35 | + 27 August 2006 |
| 36 | + - Added async query capability. Original patch by |
| 37 | + Kai Londenberg (K.Londenberg@librics.de), modified by Joe Conway |
34 | 38 | Version 0.7 (as of 25 Feb, 2004) |
35 | 39 | - Added new version of dblink, dblink_exec, dblink_open, dblink_close, |
36 | 40 | and, dblink_fetch -- allows ERROR on remote side of connection to |
@@ -85,75 +89,7 @@ Installation: |
85 | 89 |
|
86 | 90 | psql template1 < dblink.sql |
87 | 91 |
|
88 | | - installs following functions into database template1: |
89 | | - |
90 | | - connection |
91 | | - ------------ |
92 | | - dblink_connect(text) RETURNS text |
93 | | - - opens an unnamed connection that will persist for duration of |
94 | | - current backend or until it is disconnected |
95 | | - dblink_connect(text,text) RETURNS text |
96 | | - - opens a named connection that will persist for duration of current |
97 | | - backend or until it is disconnected |
98 | | - dblink_disconnect() RETURNS text |
99 | | - - disconnects the unnamed persistent connection |
100 | | - dblink_disconnect(text) RETURNS text |
101 | | - - disconnects a named persistent connection |
102 | | - |
103 | | - cursor |
104 | | - ------------ |
105 | | - dblink_open(text,text [, bool fail_on_error]) RETURNS text |
106 | | - - opens a cursor using unnamed connection already opened with |
107 | | - dblink_connect() that will persist for duration of current backend |
108 | | - or until it is closed |
109 | | - dblink_open(text,text,text [, bool fail_on_error]) RETURNS text |
110 | | - - opens a cursor using a named connection already opened with |
111 | | - dblink_connect() that will persist for duration of current backend |
112 | | - or until it is closed |
113 | | - dblink_fetch(text, int [, bool fail_on_error]) RETURNS setof record |
114 | | - - fetches data from an already opened cursor on the unnamed connection |
115 | | - dblink_fetch(text, text, int [, bool fail_on_error]) RETURNS setof record |
116 | | - - fetches data from an already opened cursor on a named connection |
117 | | - dblink_close(text [, bool fail_on_error]) RETURNS text |
118 | | - - closes a cursor on the unnamed connection |
119 | | - dblink_close(text,text [, bool fail_on_error]) RETURNS text |
120 | | - - closes a cursor on a named connection |
121 | | - |
122 | | - query |
123 | | - ------------ |
124 | | - dblink(text,text [, bool fail_on_error]) RETURNS setof record |
125 | | - - returns a set of results from remote SELECT query; the first argument |
126 | | - is either a connection string, or the name of an already opened |
127 | | - persistant connection |
128 | | - dblink(text [, bool fail_on_error]) RETURNS setof record |
129 | | - - returns a set of results from remote SELECT query, using the unnamed |
130 | | - connection already opened with dblink_connect() |
131 | | - |
132 | | - execute |
133 | | - ------------ |
134 | | - dblink_exec(text, text [, bool fail_on_error]) RETURNS text |
135 | | - - executes an INSERT/UPDATE/DELETE query remotely; the first argument |
136 | | - is either a connection string, or the name of an already opened |
137 | | - persistant connection |
138 | | - dblink_exec(text [, bool fail_on_error]) RETURNS text |
139 | | - - executes an INSERT/UPDATE/DELETE query remotely, using connection |
140 | | - already opened with dblink_connect() |
141 | | - |
142 | | - misc |
143 | | - ------------ |
144 | | - dblink_current_query() RETURNS text |
145 | | - - returns the current query string |
146 | | - dblink_get_pkey(text) RETURNS setof text |
147 | | - - returns the field names of a relation's primary key fields |
148 | | - dblink_build_sql_insert(text,int2vector,int2,_text,_text) RETURNS text |
149 | | - - builds an insert statement using a local tuple, replacing the |
150 | | - selection key field values with alternate supplied values |
151 | | - dblink_build_sql_delete(text,int2vector,int2,_text) RETURNS text |
152 | | - - builds a delete statement using supplied values for selection |
153 | | - key field values |
154 | | - dblink_build_sql_update(text,int2vector,int2,_text,_text) RETURNS text |
155 | | - - builds an update statement using a local tuple, replacing the |
156 | | - selection key field values with alternate supplied values |
| 92 | + installs dblink functions into database template1 |
157 | 93 |
|
158 | 94 | Documentation: |
159 | 95 |
|
|