1 1.22 Wed Mar 26 22:33:44 EST 2003
2 - Win32 compile fix for snprintf [Joe Spears]
3 - Fix memory allocation problem in bytea escaping [Barrie Slaymaker]
4 - Add utf8 support [Dominic Mitchell <dom@semantico.com>]
5 - Transform Perl arrays into PostgreSQL arrays [Alexey Slynko]
6 - Fix for foreign_key_info() [Keith Keller]
7 - Fix PG_TEXT parameter binding
8 - Doc cleanups [turnstep]
9 - Fix warning from func($table, 'table_attributes') [turnstep]
10 - Added suppport for schemas [turnstep]
11 - Fix binary to a bytea field conversion [Chris Dunlop <chris@onthe.net.au>]
12 1.21 Sun Jan 12 21:00:44 EST 2003
13 - System tables no longer returned by tables(). [Dave Rolsky]
14 - Fix table_attributes to handle removal of pg_relcheck in 7.3,
15 from Ian Barwick <barwick@gmx.net>
16 - Properly reset transaction status after failed transaction when
17 autocommit is off. Properly report transaction failure message.
19 - New pg_bool_tf database handle that when set to true booleans are
20 returned as 't'/'f' rather than 1/0.
22 1.20 Wed Nov 27 16:19:26 2002
23 - Maintenance transferred to GBorg,
24 http://gborg.postgresql.org/project/dbdpg/projdisplay.php. Incremented
25 version number to reflect new management. [Bruce Momjian]
26 - README cleaned up. [Bruce Momjian]
27 - Added t/15funct.t, a series of tests that determine if the meta data
28 is working. [Thomas Lowery]
29 - Added implementations of column_info() and table_info(), and
30 primary_key_info(). [Thomas Lowery]
31 - The POD formatting was cleaned up. [David Wheeler]
32 - The preparser was updated to better handle escaped characters. [Rudy
34 - Removed redundant use of strlen() in pg_error() (Jason E. Stewart).
35 - Test suite cleaned up, converted to use Test::More, and updated to use
36 standard DBI environment variables for connecting to a test database.
38 - Added eg/lotest.pl as a demonstration of using large objects in buffers
39 rather than files. Contributed by Garth Webb.
40 - Added LISTEN/NOTIFY functionality. Congributed by Alex Pilosov.
41 - Added constants for common PostgreSQL data types, plus simple tests to
42 make sure that they work. These are exportable via "use DBD::Pg
43 qw(:pg_types);". [David Wheeler]
44 - Deprecatated the undocumented (and invalid) use of SQL_BINARY in
45 bind_param() and documented the correct approach: "bind_param($num,
46 $val { pg_type => PG_BYTEA });". Use of SQL_BINARY in bind_param() will
47 now issue a warning if $h->{Warn} is true. [David Wheeler]
48 - Removed invalid (and broken) support for SQL_BINARY in quote(). [David
50 - Added App::Info::RDBMS::PostgreSQL to the distribution (but it won't
51 be installed) to help Makefile.PL find the PostgreSQL include and
52 library files. [David Wheeler]
53 - Fixed compile-time warnings. [David Wheeler and Jason E. Stewart]
55 2002-04-27 Jeffrey W. Baker <jwbaker@acm.org>
57 - dbdimp.c: Add default at end of switch statement for pg_type attrib.
58 - t/13pgtype.t: test for above.
60 2002-04-09 Jeffrey W. Baker <jwbaker@acm.org>
62 - Pg.pm, dbdimp.c: Applied patch from
63 Thomas A. Lowery <tlowery@stlowery.net> concerning metadata
64 in table_info and so forth.
66 2002-03-06 Jeffrey W. Baker <jwbaker@acm.org>
67 - Pg.pm (quote): Applied patch from David Wheeler <david@wheeler.net>
68 to simplfiy and speed up quoting.
69 - t/11quoting.t: Tests for above patch.
70 - t/12placeholders.t: Tests for placeholder parsing in quoted strings.
72 2002-03-06 Jeffrey W. Baker
73 - Version 1.10 uploaded to CPAN.
76 - fixed core dump when trying to use a BYTEA value with
77 a byte outside 0..127 Alex Pilosov <alex@pilosoft.com>
80 - Fetching all records now resets Active flag as it should.
83 - fix the segmentation fault in pg_error.
86 - bug-fix for core-dump after any failed function call.
87 - applied patch from Alex Pilosov <alex@pilosoft.com>
88 which adds support for the datatype bytea
91 - fix bug in connect method, which erroneously set the userid
92 and the password to the environment variables DBI_USER and
94 - applied patch from Jan-Pieter Cornet <john@pc.xs4all.nl>,
95 which removed the special handling of a backslash when
96 used for octal presentation. Now a backslash always will
100 - remove memory-leak in ping function, bug-fix
101 from Doug Perham <dperham@wgate.com>
102 - correct the recognition of primary keys in
103 table_attributes(). Patch from Brian Powell
104 <brian@nicklebys.com>.
105 - applied patch from David D. Kilzer <ddkilzer@lubricants-oil.com>
106 which fixes a segmentation fault in DBD::pg::blob_read() when
107 reading LOBs that required perl to reallocate space for the
108 variable holding the scalar value
109 - updated test.pl to create a test blob larger than 256 bytes
111 - apply patch from Tom Lane, which fixes a seg-fault when
112 inserting large amounts of text.
113 - apply patch from Peter Haworth pmh@edison.ioppublishing.com,
114 which removes the newlines from the error messages and which
115 quotes date placeholders.
118 - add Win32 port from Bob Kline <bkline@rksystems.com>.
121 - applied patch from Rudy Lippan <almighty@randomc.com>
122 which fixes a memory-leak with failed connections.
123 - applied patch from Hein Roehrig <hein@acm.org>
124 which fixes a bug with escaping a backslash except for
126 - applied patch from Francis J. Lacoste <francis.lacoste@iNsu.COM
127 which fixes a segmentation fault when all binded parameters are NULL
128 - adapt test.pl to avoid warnings with postgresql-7.0
129 - added support for 'COPY FROM STDIN' and 'COPY TO STDOUT'
130 - added patch from Mark Stosberg <mark@summersault.com>
131 to enhance the table_attributes subroutine
134 - it is required now to set the environment variables POSTGRES_INCLUDE
135 and POSTGRES_LIB for compiling the module.
136 - add Win32 port from Bob Kline <bkline@rksystems.com>.
137 - support for all large-object functions via the func
139 - fixed bug with placeholders and casts spotted by
141 - replaced the method attributes by the method table_attributes,
142 from Scott Williams <scott@james.com>.
143 - fix type definitions for type_info_all().
144 bug spotted by "carlos" <emarcet@intramed.net.ar>.
145 - now the Pg-specific quote() method also evaluates the
149 - proposal from Philip Warner <pjw@rhyme.com.au>:
150 increase BUFSIZE from 1024 to 32768 in order to improve
152 - bug-fix in Makefile.PL for $POSTGRES_HOME not defined
153 spotted by mdalphin@amgen.com (Mark Dalphin)
154 - bug-fix for data-type datetime in type_info_all
155 spotted by Alan Grover <awgrover@iconnect-inc.com>
156 - bug-fix for escaped 's spotted by Hankin <hankin@consultco.com>
157 - removed 'large objects' related tests from test.pl
160 - removed restriction for commercial use in copyright
161 - corrected DATA_TYPE in type_info_all()
164 - discard parameter authtype from connect string
165 - remove work-around for bug in the large object
166 interface of postgresql
169 - bug-fix from Jan Iven <j.iven@rz.uni-sb.de>:
170 fix problem with quoting Null in bind variables.
174 - suppressed warning when testing DBI::errstr
177 - Pg.xs adapted to Driver.xst from DBI-1.0
178 - major rewrite of module documentation
179 - major rewrite of the test script
180 - use built-in DBI method for $dbh->do
181 - add macro dHTR in order to avoid compile errors
182 with threaded perl5.005
183 - renamed attribute AutoEscape to pg_auto_escape
184 - renamed attribute SIZE to pg_size
185 - new attribute pg_type
186 - added support for DBI->data_sources($driver)
187 - added support for $dbh->table_info
188 - blob_read documented and added to test.pl
189 - added support for attr parameter in bind_param()
192 - added /usr/lib/ to search path for libpq.
193 - added ChopBlanks, patch from
194 Victor Krasinsky <victor@rdovira.lviv.ua>
195 - changed test.pl to test multiple database handles
198 - non-printable characters in parameters will not be
199 converted to '.'. They are passed unchanged to the
203 - bug-fix from Max Cohan <mcohan@adnc.net>:
204 check for \xxx presentation before escaping backslash
206 - introduce new database handle attribute AutoEscape, which
207 controls escaping of quotes and backslashes in parameters.
208 When set to on, all quotes except at the beginning and
209 at the end of a line will be escaped and all backslashes
210 except when used to indicate an octal presentation (\xxx)
211 will be escaped. Default of AutoEscape is on.
214 - bug-fix from Max Cohan <mcohan@adnc.net>:
215 using traces together with undef in place-holders dumped
219 - bug-fix from Matthew Lenz <matthew@nocturnal.org>:
220 corrected include path in Makefile.PL .
221 - added 'use strict;' to test.pl
224 - bug-fix from Rolf Grossmann <grossman@securitas.net>:
225 undefined parameters in an execute statement will be
226 translated from 'undef' to 'NULL'. Also every parameter
227 for bind_param() will be quoted by default (escape quote
228 and backslash). Appropriate tests have been added to test.pl.
229 - change ping method to use libpq-interface.
232 - adapted to postgresql-6.4:
233 the backend protocol has changed, which needs an adapted
234 ping method. A ping-test has been added to the test-script.
235 Also some type identifiers have changed.
238 - changed include directives in Makefile.PL from
239 archlib to installarchlib and from sitearch to
240 installsitearch (Tony.Curtis@vcpc.univie.ac.at).
241 - applied patch from Junio Hamano <junio@twinsun.com>
242 quote method also doubles backslash.
245 - applied patch from Michael J Schout <mschout@gkg.net>
246 which fixed the bug with queries containing the cast
248 - applied patch from "Irving Reid" <irving@tor.securecomputing.com>
249 which fixed a memory leak.
252 - applied patch from "Irving Reid"
253 <irving@tor.securecomputing.com> which fixed the
254 the problem with the InactiveDestroy message.
257 - linking again with the shared version of libpq
258 due to problems on several operating systems.
261 - expanded the search path for include files
262 - module is now linked with static libpq.a
265 - return to UNIX domain sockets in test-scripts
267 0.67 February 21, 1998
268 - remove part of Driver.xst due to compile
269 error on some systems.
271 0.66 February 19, 1998
272 - remove defines in Pg.h so that
273 it compiles also with postgresql-6.2.1
274 - changed ping method: set RaiseError=0
276 0.65 February 14, 1998
277 - adapted to changes in DBI-0.91, so that the
278 default setting for AutoCommit and PrintError is
279 again conformant to the DBI specs.
281 0.64 February 01, 1998
282 - changed syntax of data_source (ODBC-conformant):
283 'dbi:Pg:dbname=dbname;host=host;port=port'
284 !!! PLEASE ADAPT YOUR SCRIPTS !!!
285 - implemented place-holders
286 - implemented ping-method
287 - added support for $dbh->{RaiseError} and $dbh->{PrintError},
288 note: DBI-default for PrintError is on !
289 - allow commit and rollback only if AutoCommit = off
290 - added documentation for $dbh->tables;
291 - new method to get meta-information about a given table:
292 $dbh->DBD::Pg::db::attributes($table);
293 - host-parameter in test.pl is set explicitly to localhost
295 0.63 October 05, 1997
296 - adapted to PostgreSQL-6.2:
297 o $sth->rows as well as $sth->execute
298 and $sth->do return the number of
299 affected rows even for non-Select
301 o support for password authorization added,
302 please check the man-page for pg_passwd.
303 - the data_source parameter of the connect
304 method accepts two additional parameters
305 which are treated as host and port:
306 DBI->connect("dbi:Pg:dbname:host:port", "uid", "pwd")
307 - support for AutoCommit, please read the
308 module documentation for impacts on your
310 - more perl-ish handling of data type bool,
311 please read the module documentation for
312 impacts on your scripts !
318 - adapted to DBI-0.89/Driver.xst
319 - added support for blob_read
322 - added support for literal $sth->{'TYPE'},
323 pg_type.pl / pg_type.pm.
326 - changed attributes to be DBI conformant:
327 o OID_STATUS to pg_oid_status
328 o CMD_STATUS to pg_cmd_status
331 - support for user authentication
332 - support for bind_columns
336 - adapted to DBI-0.84:
337 o new syntax for DBI->connect !
338 o execute returns 0E0 -> n for SELECT stmt
339 -1 for non SELECT stmt
341 - new attribute $sth->{'OID_STATUS'}
342 - new attribute $sth->{'CMD_STATUS'}
345 - bug fix release, ( still alpha ! )
348 - complete rewrite, ( still alpha ! )
351 - creation, ( totally pre-alpha ! )