path: root/install/5.005/DBD-Pg-1.22-fixvercmp/Changes

1.22  Wed Mar 26 22:33:44 EST 2003
	- Win32 compile fix for snprintf [Joe Spears]
	- Fix memory allocation problem in bytea escaping [Barrie Slaymaker]
	- Add utf8 support [Dominic Mitchell <dom@semantico.com>]
	- Transform Perl arrays into PostgreSQL arrays [Alexey Slynko]
	- Fix for foreign_key_info() [Keith Keller]
	- Fix PG_TEXT parameter binding
	- Doc cleanups [turnstep]
	- Fix warning from func($table, 'table_attributes') [turnstep]
	- Added suppport for schemas [turnstep]
	- Fix binary to a bytea field conversion [Chris Dunlop <chris@onthe.net.au>]
1.21  Sun Jan 12 21:00:44 EST 2003
	- System tables no longer returned by tables(). [Dave Rolsky]
	- Fix table_attributes to handle removal of pg_relcheck in 7.3,
	from Ian Barwick <barwick@gmx.net>
	- Properly reset transaction status after failed transaction when
        autocommit is off.  Properly report transaction failure message.
        Kai <kai@xs4all.nl>
	- New pg_bool_tf database handle that when set to true booleans are
        returned as 't'/'f' rather than 1/0.

1.20  Wed Nov 27 16:19:26 2002
	- Maintenance transferred to GBorg,
        http://gborg.postgresql.org/project/dbdpg/projdisplay.php. Incremented
        version number to reflect new management. [Bruce Momjian]
	- README cleaned up. [Bruce Momjian]
	- Added t/15funct.t, a series of tests that determine if the meta data
        is working. [Thomas Lowery]
	- Added implementations of column_info() and table_info(), and
        primary_key_info(). [Thomas Lowery]
	- The POD formatting was cleaned up. [David Wheeler]
	- The preparser was updated to better handle escaped characters. [Rudy
        Lippan]
	- Removed redundant use of strlen() in pg_error() (Jason E. Stewart).
	- Test suite cleaned up, converted to use Test::More, and updated to use
        standard DBI environment variables for connecting to a test database.
        [Jason E. Stewart]
	- Added eg/lotest.pl as a demonstration of using large objects in buffers
        rather than files. Contributed by Garth Webb.
	- Added LISTEN/NOTIFY functionality. Congributed by Alex Pilosov.
	- Added constants for common PostgreSQL data types, plus simple tests to
	make sure that they work. These are exportable via "use DBD::Pg
	qw(:pg_types);". [David Wheeler]
	- Deprecatated the undocumented (and invalid) use of SQL_BINARY in
	bind_param() and documented the correct approach: "bind_param($num,
	$val { pg_type => PG_BYTEA });". Use of SQL_BINARY in bind_param() will
        now issue a warning if $h->{Warn} is true. [David Wheeler]
	- Removed invalid (and broken) support for SQL_BINARY in quote(). [David
	Wheeler]
	- Added App::Info::RDBMS::PostgreSQL to the distribution (but it won't
        be installed) to help Makefile.PL find the PostgreSQL include and
        library files. [David Wheeler]
	- Fixed compile-time warnings. [David Wheeler and Jason E. Stewart]

2002-04-27 Jeffrey W. Baker <jwbaker@acm.org>

	- dbdimp.c: Add default at end of switch statement for pg_type attrib.
	- t/13pgtype.t: test for above.
    
2002-04-09 Jeffrey W. Baker <jwbaker@acm.org>

	- Pg.pm, dbdimp.c: Applied patch from 
	Thomas A. Lowery <tlowery@stlowery.net> concerning metadata
	in table_info and so forth.
    
2002-03-06 Jeffrey W. Baker <jwbaker@acm.org>
	- Pg.pm (quote): Applied patch from David Wheeler <david@wheeler.net>
	to simplfiy and speed up quoting.
	- t/11quoting.t: Tests for above patch.
	- t/12placeholders.t: Tests for placeholder parsing in quoted strings.
    
2002-03-06 Jeffrey W. Baker
	- Version 1.10 uploaded to CPAN.
 
1.01 Jun 27, 2001
	- fixed core dump when trying to use a BYTEA value with
	  a byte outside 0..127  Alex Pilosov <alex@pilosoft.com>

1.00 May 27, 2001
	- Fetching all records now resets Active flag as it should.

0.99 May 24, 2001
	- fix the segmentation fault in pg_error.

0.98 Apr 25, 2001
	- bug-fix for core-dump after any failed function call.
	- applied patch from Alex Pilosov <alex@pilosoft.com> 
	  which adds support for the datatype bytea

0.97 Apr 20, 2001
	- fix bug in connect method, which erroneously set the userid
	  and the password to the environment variables DBI_USER and
	  DBI_PASS.
	- applied patch from Jan-Pieter Cornet <john@pc.xs4all.nl>,
	  which removed the special handling of a backslash when
	  used for octal presentation. Now a backslash always will
	  be escaped.

0.96 Apr 09, 2001
	- remove memory-leak in ping function, bug-fix
	  from Doug Perham <dperham@wgate.com>
	- correct the recognition of primary keys in 
	  table_attributes(). Patch from Brian Powell 
	  <brian@nicklebys.com>.
	- applied patch from David D. Kilzer <ddkilzer@lubricants-oil.com>
	  which fixes a segmentation fault in DBD::pg::blob_read() when 
	  reading LOBs that required perl to reallocate space for the 
	  variable holding the scalar value
	- updated test.pl to create a test blob larger than 256 bytes 
	  (now 128 Kbytes)
	- apply patch from Tom Lane, which fixes a seg-fault when
	  inserting large amounts of text.
	- apply patch from Peter Haworth   pmh@edison.ioppublishing.com,
	  which removes the newlines from the error messages and which 
	  quotes date placeholders.

0.95 Jul 10, 2000
	- add Win32 port from Bob Kline <bkline@rksystems.com>.

0.94 Jul 07, 2000
	- applied patch from Rudy Lippan <almighty@randomc.com>
	  which fixes a memory-leak with failed connections.
	- applied patch from Hein Roehrig <hein@acm.org>
	  which fixes a bug with escaping a backslash except for 
	  octal presentation
        - applied patch from Francis J. Lacoste <francis.lacoste@iNsu.COM
          which fixes a segmentation fault when all binded parameters are NULL
        - adapt test.pl to avoid warnings with postgresql-7.0
        - added support for 'COPY FROM STDIN' and 'COPY TO STDOUT'
        - added patch from Mark Stosberg <mark@summersault.com>
          to enhance the table_attributes subroutine

0.93 Sep 29, 1999
	- it is required now to set the environment variables POSTGRES_INCLUDE
	  and POSTGRES_LIB for compiling the module.
	- add Win32 port from Bob Kline <bkline@rksystems.com>.
	- support for all large-object functions via the func
	  interface. 
	- fixed bug with placeholders and casts spotted by
	  mschout@gkg.net
	- replaced the method attributes by the method table_attributes,
	  from Scott Williams <scott@james.com>.
	- fix type definitions for type_info_all().
	  bug spotted by "carlos" <emarcet@intramed.net.ar>.
	- now the Pg-specific quote() method also evaluates the 
	  data-type paramater. 

0.92 Jun 16, 1999
	- proposal from Philip Warner <pjw@rhyme.com.au>:
	  increase BUFSIZE from 1024 to 32768 in order to improve
	  I/O performance.
	- bug-fix in Makefile.PL for $POSTGRES_HOME not defined
	  spotted by mdalphin@amgen.com (Mark Dalphin)
	- bug-fix for data-type datetime in type_info_all
	  spotted by Alan Grover <awgrover@iconnect-inc.com>
	- bug-fix for escaped 's spotted by Hankin <hankin@consultco.com>
	- removed 'large objects' related tests from test.pl

0.91 Feb 14, 1999
	- removed restriction for commercial use in copyright
	- corrected DATA_TYPE in type_info_all()

0.90 Jan 15, 1998
	- discard parameter authtype from connect string
	- remove work-around for bug in the large object 
	  interface of postgresql 

0.89 Nov 05, 1998
	- bug-fix from Jan Iven <j.iven@rz.uni-sb.de>:
	  fix problem with quoting Null in bind variables.

0.88 Oct 10, 1998
	- fixed blob_read
	- suppressed warning when testing DBI::errstr

0.87 Sep 05, 1998
	- Pg.xs adapted to Driver.xst from DBI-1.0
	- major rewrite of module documentation 
	- major rewrite of the test script
	- use built-in DBI method for $dbh->do 
	- add macro dHTR in order to avoid compile errors 
	  with threaded perl5.005
	- renamed attribute AutoEscape to pg_auto_escape
	- renamed attribute SIZE to pg_size
	- new attribute pg_type
	- added support for DBI->data_sources($driver)
	- added support for $dbh->table_info
	- blob_read documented and added to test.pl 
	- added support for attr parameter in bind_param()

0.86 Aug 21, 1998
	- added /usr/lib/ to search path for libpq.
	- added ChopBlanks, patch from 
          Victor Krasinsky <victor@rdovira.lviv.ua>
	- changed test.pl to test multiple database handles 

0.85 July 19, 1998
	- non-printable characters in parameters will not be 
	  converted to '.'. They are passed unchanged to the 
	  database. 

0.84 July 18, 1998
	- bug-fix from Max Cohan <mcohan@adnc.net>:
	  check for \xxx presentation before escaping backslash
	  in parameters. 
	- introduce new database handle attribute AutoEscape, which 
	  controls escaping of quotes and backslashes in parameters. 
	  When set to on, all quotes except at the beginning and 
	  at the end of a line will be escaped and all backslashes 
	  except when used to indicate an octal presentation (\xxx) 
	  will be escaped. Default of AutoEscape is on. 

0.83 July 10, 1998
	- bug-fix from Max Cohan <mcohan@adnc.net>:
	  using traces together with undef in place-holders dumped 
	  core. 

0.82 June 20, 1998
	- bug-fix from Matthew Lenz <matthew@nocturnal.org>:
	  corrected include path in Makefile.PL .
	- added 'use strict;' to test.pl

0.81 June 13, 1998
	- bug-fix from Rolf Grossmann <grossman@securitas.net>:
	  undefined parameters in an execute statement will be 
	  translated from 'undef' to 'NULL'. Also every parameter 
	  for bind_param() will be quoted by default (escape quote 
	  and backslash). Appropriate tests have been added to test.pl. 
	- change ping method to use libpq-interface.

0.80 June 07, 1998
	- adapted to postgresql-6.4:
	  the backend protocol has changed, which needs an adapted
	  ping method. A ping-test has been added to the test-script.
	  Also some type identifiers have changed. 

0.73 June 03, 1998
	- changed include directives in Makefile.PL from 
	  archlib to installarchlib and from sitearch to
	  installsitearch (Tony.Curtis@vcpc.univie.ac.at).
	- applied patch from Junio Hamano <junio@twinsun.com>
	  quote method also doubles backslash.

0.72 April 20, 1998
	- applied patch from Michael J Schout <mschout@gkg.net>
	  which fixed the bug with queries containing the cast
          operator.
	- applied patch from "Irving Reid" <irving@tor.securecomputing.com>
	  which fixed a memory leak.

0.71 April 04, 1998
	- applied patch from "Irving Reid" 
	  <irving@tor.securecomputing.com> which fixed the
	  the problem with the InactiveDestroy message.

0.70 March 28, 1998
        - linking again with the shared version of libpq 
          due to problems on several operating systems.

0.69 March  6, 1998
	- expanded the search path for include files
        - module is now linked with static libpq.a

0.68  March 3, 1998
        - return to UNIX domain sockets in test-scripts

0.67  February 21, 1998
	- remove part of Driver.xst due to compile
	  error on some systems.

0.66  February 19, 1998
	- remove defines in Pg.h so that
	  it compiles also with postgresql-6.2.1
	- changed ping method: set RaiseError=0

0.65  February 14, 1998
	- adapted to changes in DBI-0.91, so that the
	  default setting for AutoCommit and PrintError is 
	  again conformant to the DBI specs.

0.64  February 01, 1998
        - changed syntax of data_source (ODBC-conformant): 
          'dbi:Pg:dbname=dbname;host=host;port=port'
          !!! PLEASE ADAPT YOUR SCRIPTS !!!
        - implemented place-holders 
        - implemented ping-method
        - added support for $dbh->{RaiseError} and $dbh->{PrintError},
          note: DBI-default for PrintError is on !
        - allow commit and rollback only if AutoCommit = off
        - added documentation for $dbh->tables;
        - new method to get meta-information about a given table:
          $dbh->DBD::Pg::db::attributes($table);
        - host-parameter in test.pl is set explicitly to localhost

0.63  October 05, 1997
	- adapted to PostgreSQL-6.2:
          o $sth->rows as well as $sth->execute
            and $sth->do return the number of 
            affected rows even for non-Select
            statements.
          o support for password authorization added, 
            please check the man-page for pg_passwd. 
        - the data_source parameter of the connect 
          method accepts two additional parameters 
          which are  treated as host and port:
          DBI->connect("dbi:Pg:dbname:host:port", "uid", "pwd")
        - support for AutoCommit, please read the 
          module documentation for impacts on your 
          scripts !
        - more perl-ish handling of data type bool, 
          please read the module documentation for 
          impacts on your scripts !

0.62  August 26, 1997
	- added blobs/README

0.61  August 23, 1997
        - adapted to DBI-0.89/Driver.xst
	- added support for blob_read

0.52  August 15, 1997
        - added support for literal $sth->{'TYPE'},
          pg_type.pl / pg_type.pm.

0.51  August 12, 1997
        - changed attributes to be DBI conformant:
          o OID_STATUS to pg_oid_status
          o CMD_STATUS to pg_cmd_status

0.5   August 05, 1997
	- support for user authentication
	- support for bind_columns
	- added $dbh->tables

0.4   Jun 24, 1997
        - adapted to DBI-0.84:
          o new syntax for DBI->connect !
          o execute returns 0E0 -> n for     SELECT stmt
                                  -1 for non SELECT stmt
                                  -2 on error
        - new attribute $sth->{'OID_STATUS'}
        - new attribute $sth->{'CMD_STATUS'}

0.3   Apr 24, 1997
        - bug fix release, ( still alpha ! )

0.2   Mar 13, 1997
	- complete rewrite, ( still alpha ! )

0.1   Feb 15, 1997
	- creation, ( totally pre-alpha ! )