forked from bucardo/dbdpg
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChanges
1504 lines (1104 loc) · 56.4 KB
/
Changes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
Version 3.5.4
- Fix skipped test counts in Win32 builds
[Andy Grundman]
- Fix UTF8 double-encoding with pg_enable_utf8 = 0
[Serge Pushkin]
(CPAN bug #103137)
Version 3.5.3 Released October 1, 2015 (git commit 62ddf200106467ce9ad31d85715a4cdf63e8be14)
- Minor fix in the test file t/03dbmethod.t
- Silence warnings in t/02attribs.t and t/04misc.t
Version 3.5.2 Released September 29, 2015 (git commit be8026c9160c4a29580a97dab57cb595c5448949)
- Fix enum value ordering on Postgres servers 9.1 and greater
[Dagfinn Ilmari Mannsåker]
- Return bigint values as plain integer values when they fit
[Dagfinn Ilmari Mannsåker]
- Fix typo in sprintf for get_info() SQL_DATA_SOURCE_NAME
[Craig A. James]
(CPAN bug #106604)
- Set the repository in META.yml to github
Version 3.5.1 Released February 17, 2015 (git commit 6c3457ee20c19ae492d29c490af6800e7e6a0774)
- Prevent core dump if the second argument to the quote() method
is anything but a hashref
[Greg Sabino Mullane]
(CPAN bug #101980)
- Better "support" for SQL_ASCII servers in the tests.
Allow env var DBDPG_TEST_ALWAYS_ENV to force use of DBI_DSN and DBI_USER in tests.
[Greg Sabino Mullane]
- Fix client_encoding detection on pre-9.1 servers
[Dagfinn Ilmari Mannsåker]
- Fix operator existence check in tests on pre-8.3 servers
[Dagfinn Ilmari Mannsåker]
- Documentation fix
[Stuart A Johnston]
- Fix pg_switch_prepared database handle documentation
[Dagfinn Ilmari Mannsåker]
Version 3.5.0 Released January 6, 2015 (git commit bb13d3306fd1c73fac1c0c8a330c14e6b8443942)
- Allow "placeholder escaping" by the use of a backslash directly before it, e.g.
"SELECT 1 FROM jsontable WHERE foo \\? ?"
will contain a single placeholder, and the first question mark will be sent directly
to the backend to be parsed as an operator.
[Greg Sabino Mullane, Tim Bunce]
(CPAN bug #101030)
- Improve the workings of the ping() method, so it always tests for
a valid database backend and returns the correct true/false.
[Greg Sabino Mullane, with help from Andrew Gierth and Tim Bunce]
(CPAN bug #100648)
- Add get_info(9000) => 1 to indicate driver can escape placeholders.
[Tim Bunce]
- In tests, force the client_encoding to UTF8, skip tests that involve
characters not supported by the server_encoding
[Dagfinn Ilmari Mannsåker]
- Fix memory leak when selecting from arrays
[Dagfinn Ilmari Mannsåker, reported by Krystian Samp]
- Make get_info much more efficient and slightly simpler.
[Tim Bunce]
Version 3.4.2 Released September 25, 2014 (git commit 61440e1f4ccb6c293c5838676da1942e0df67271)
- Fix bug where single-quoted type arguments to the table_info()
method were causing a SQL error.
[Greg Sabino Mullane] (CPAN bug #99144)
Version 3.4.1 Released August 20, 2014 (git commit cfd146effde09c493ac7573408ac29d6d9cbed47)
- Allow '%' again for the type in table_info() and thus tables()
It's not documented or tested in DBI, but it used to work until
DBD::Pg 3.4.0, and the change broke DBIx::Class::Schema::Loader, which
uses type='%'.
[Dagfinn Ilmari Mannsåker]
Version 3.4.0 Released August 16, 2014 (git commit 7a5da12d84b4c2e9879f90fb6168f56c095071fa)
- Cleanup and improve table_info()
[Mike Pomraning <mjp@pilcrow.madison.wi.us>] (github issue #7)
table_info() type searching now supports TABLE, VIEW, SYSTEM TABLE,
SYSTEM VIEW, and LOCAL TEMPORARY
table_info() object searching fully supports the above types.
table_info() object searching no longer ignores invalid types - a filter
of 'NOSUCH' will return no rows, and 'NOSUCH,LOCAL TEMPORARY' will
return only temp objects.
tableinfo() type filters are strictly matched now ... previously a
search for SYSTEM TABLE would have fetched plain TABLE objects.
table_info() now treats temporary tables and temporary views as LOCAL TEMPORARY
- Make sure column_info() and table_info() can handle materialized views.
[Greg Sabino Mullane] (CPAN bug #97032)
Version 3.3.0 Released May 31, 2014 (git commit 055f788cf96b380b9fe0e80b6cedb88f8d1799b8)
- Major cleanup of UTF-8 support:
Fix quoting of UTF-8 values
Add support for UTF-8 statement strings
Fix UTF-8 support in placeholders and return values
[Dagfinn Ilmari Mannsåker] (CPAN bug #95214 and #91655)
Test that the Pg server agrees with us about the lengths of input strings.
Refactor Unicode test to use anon hashes to describe the tests to run.
Test pg_enable_utf8 of -1, in addition to 0 and 1.
Extend the Unicode round-trip tests to verify ASCII, BMP and non-BMP code points.
Test that characters created in the server reach the client correctly.
[Nicholas Clark]
- Rewrite foreign_key_info to be just one query
[Dagfinn Ilmari Mannsåker]
- Remove ODBC support from foreign_key_info
[Dagfinn Ilmari Mannsåker]
- Remove use of dTHX in functions in quote.c and types.c
[Nicholas Clark]
Version 3.2.1 Released May 20, 2014 (git commit a56ef5c4715440d4fc2054df5477996b0e287467)
- Stricter testing for array slices: disallow number-colon-number from being
parsed as a placeholder.
[Greg Sabino Mullane] (CPAN bug #95713)
- Fix for small leak with AutoInactiveDestroy
[David Dick] (CPAN bug #95505)
- Adjust test regex to fix failing t/01_connect.t on some platforms
[Greg Sabino Mullane]
- Further tweaks to get PGINITDB working for test suite.
[Nicholas Clark]
Version 3.2.0 Released May 15, 2014 (git commit 897974c2865259bb9786d8b0989f8e42db0a0d79)
- Add new attribute pg_placeholder_nocolons to turn off all parsing of
colons into placeholders.
[Graham Ollis] (CPAN bug #95173)
- Fix incorrect skip count for HandleSetErr
[Greg Sabino Mullane] (CPAN bug #94841)
- Don't attempt to use the POSIX signalling stuff if the OS is Win
[Greg Sabino Mullane] (CPAN bug ##94841)
- Fix missing check for PGINITDB in the test suite.
[Nicholas Clark]
Version 3.1.1 Released April 6, 2014 (git commit d337f93133e67267d54b65dc22a23f06e6883ad0)
- Minor adjustments so tests pass in varying locales.
Version 3.1.0 Released April 4, 2014 (git commit 26517a3531f93de79375a02da45a79789cd3caae)
- Make sure UTF-8 enabled notifications are handled correctly
[Greg Sabino Mullane]
- Allow "WITH" and "VALUES" as valid words starting a DML statement
[Greg Sabino Mullane] (CPAN bug #92724)
Version 3.0.0 Released February 3, 2014 (git commit 9725314f27a8d65fc05bdeda3da8ce9c251f79bd)
- Major change in UTF-8 handling. If client_encoding is set to UTF-8,
always mark returned Perl strings as utf8. See the pg_enable_utf8 docs
for more information.
[Greg Sabino Mullane, David E. Wheeler, David Christensen]
- Bump DBI requirement to 1.614
- Bump Perl requirement to 5.8.1
- Add new handle attribute, switch_prepared, to control when we stop
using PQexecParams and start using PQexecPrepared. The default is 2:
in previous versions, the effective behavior was 1 (i.e. PQexecParams
was never used).
[Greg Sabino Mullane]
- Better handling of items inside of arrays, particularly bytea arrays.
[Greg Sabino Mullane] (CPAN bug #91454)
- Map SQL_CHAR back to bpchar, not char
[Greg Sabino Mullane, reported by H.Merijn Brand]
- Do not force oids to Perl ints
[Greg Sabino Mullane] (CPAN bug #85836)
- Return better sqlstate codes on fatal errors
[Rainer Weikusat]
- Better prepared statement names to avoid bug
[Spencer Sun] (CPAN bug #88827)
- Add pg_expression field to statistics_info output to show
functional index information
[Greg Sabino Mullane] (CPAN bug #76608)
- Adjust lo_import_with_oid check for 8.3
(CPAN bug #83145)
- Better handling of libpq errors to return SQLSTATE 08000
[Stephen Keller]
- Make sure CREATE TABLE .. AS SELECT returns rows in non do() cases
- Add support for AutoInactiveDestroy
[David Dick] (CPAN bug #68893)
- Fix ORDINAL_POSITION in foreign_key_info
[Dagfinn Ilmari Mannsåker] (CPAN bug #88794)
- Fix foreign_key_info with unspecified schema
[Dagfinn Ilmari Mannsåker] (CPAN bug #88787)
- Allow foreign_key_info to work when pg_expand_array is off
[Greg Sabino Mullane and Tim Bunce] (CPAN bug #51780)
- Remove math.h linking, as we no longer need it
(CPAN bug #79256)
- Spelling fixes
(CPAN bug #78168)
- Better wording for the AutoCommit docs
(CPAN bug #82536)
- Change NOTICE to DEBUG1 in t/02attribs.t test for handle attribute "PrintWarn":
implicit index creation is now quieter in Postgres.
[Erik Rijkers]
- Use correct SQL_BIGINT constant for int8
[Dagfinn Ilmari Mannsåker]
- Fix assertion when binding array columns on debug perls >= 5.16
[Dagfinn Ilmari Mannsåker]
- Adjust test to use 3 digit exponential values
[Greg Sabino Mullane] (CPAN bug #59449)
- Avoid reinstalling driver methods in threads
[Dagfinn Ilmari Mannsåker] (CPAN bug #83638)
- Make sure App::Info does not prompt for pg_config location
if AUTOMATED_TESTING or PERL_MM_USE_DEFAULT is set
[David E. Wheeler] (CPAN bug #90799)
- Fix typo in docs for pg_placeholder_dollaronly
[Bryan Carpenter] (CPAN bug #91400)
- Cleanup dangling largeobjects in tests
[Fitz Elliott] (CPAN bug #92212)
- Fix skip test counting in t/09arrays.t
[Greg Sabino Mullane] (CPAN bug #79544)
- Explicitly specify en_US for spell checking
[Dagfinn Ilmari Mannsåker] (CPAN bug #91804)
'GSM' is Greg Sabino Mullane, greg@turnstep.com
Version 2.19.3 Released August 21, 2012 (git commit be018f10fdaf4163f98affcb7244046e8f47420d)
- Fix bug in pg_st_split_statement causing segfaults
(CPAN bug #79035)
- Make sure table_info() and other functions use pg_tablespace_location()
instead of spclocation for Postgres servers 9.2 and greater. [GSM + others]
(CPAN bug #77042)
Version 2.19.2 Released March 12, 2012 (git commit 52c80cc795855af8bf93eb0c81c76bd6f07a5f70)
- Fix errors when multiple same-named placeholders are used. [GSM]
(CPAN bug #75713)
Version 2.19.1 Released March 10, 2012 (git commit db6f6da00467c7ea28d32c4df97e93ccc4d38f2b)
- Fix crash when passing in an array with undefined elements. [GSM]
Version 2.19.0 Released March 9, 2012 (git commit 05ab092905ce6891ed83e173412ee70d6cdb8cb5)
- Use proper formatting for warn() and croak() (CPAN bug #75642)
[Niko Tyni]
- Fix localized regex in test (CPAN bug #70759)
- Fix for named placeholders (CPAN bug #70953) [Jan Pazdziora]
- Various fixes to the array-marshalling code [Noah Misch, Mark
Stosberg, and David Christensen] (CPAN bug #58552)
- Allow hi-bit chars in dollar-quoted identifiers
[David Christensen] (CPAN bug #73832)
- Have do() return count for things such as CREATE TABLE .. AS SELECT
Will only work on 9.0 or better. (CPAN bug #71073) [Pavel Stehule]
- Better error message when trying to do things post-disconnect [GSM]
- Always respect pg_server_prepare=0 by using PQexec not PQexecParams. [GSM]
- Fix error in async docs (CPAN bug #72812)
- Switch from subversion to git.
git clone git://bucardo.org/dbdpg.git [GSM]
Version 2.18.1 Released May 9, 2011 (git commit 5ea7d91bf1704fe0cae06c49806055cb35207950)
- Fix LANG testing issue [GSM] (CPAN bug #56705)
- Fix bug when async commands issued immediately after a COPY. [GSM] (CPAN bug #68041)
Version 2.18.0 Released March 28, 2011 (subversion r14081)
- Thanks to 123people.com for sponsoring work on this release [GSM]
- New cancel() method per DBI spec. [Eric Simon] (CPAN bug #63516)
- Fix memory leak when binding arrays [GSM] (CPAN bug #65734)
- Fix memory leak with ParamValues. [Martin J. Evans] (CPAN bug #60863)
- Fix memory leak in handle_old_async (missing PQclear)
[Rainer Weikusat] (CPAN bug #63408)
- Fix memory leak in pg_db_cancel (missing PQclear)
[Rainer Weikusat] (CPAN bug #63441)
- Mark pg_getcopydata strings as UTF8 as needed (CPAN bug #66006)
- Function dequote_bytea returning void should not try to return something
[Dagobert Michelsen] (CPAN bug #63497)
- Fix the number of tests to skip in t/01connect.t when the $DBI_DSN
environment variable lacks a database specification. [David E. Wheeler]
- Fix algorithm for skipping tests in t/06bytea.t when running on a version
of PostgreSQL lower than 9.0. [David E. Wheeler]
- Small tweaks to get tests working when compiled against Postgres 7.4
(CPAN bug #61713) [GSM]
- Fix failing test when run as non-superuser [GSM] (CPAN bug #61534)
Version 2.17.2 Released November 21, 2010 (subversion r14542)
- Support dequoting of hex bytea format for 9.0.
[Dagfinn Ilmari Mannsåker] (CPAN bug #60200).
- Don't PQclear on execute() if there is an active async query
[rweikusat at mssgmbh.com] (CPAN bug #58376)
- Allow data_sources() to accept any case-variant of 'dbi:Pg' (CPAN bug #61574)
- Fix failing test in t/04misc.t on Perl 5.12. [Eric Simon]
- Fix for some 7.4 failing tests [Dagfinn Ilmari Mannsåker]
- Return bare instead of undef in test connections (CPAN bug #61574)
Version 2.17.1 Released April 8, 2010 (subversion r13899)
- Only use lo_import_with_oid if Postgres libraries are 8.4 or better
[GSM] (CPAN bug #56363)
Version 2.17.0 Released April 6, 2010 (subversion r13890)
- Do not automatically ROLLBACK on a failed pg_cancel [GSM] (CPAN bug #55188)
- Added support for new lo_import_with_oid function.
[GSM] (CPAN bug #53835)
- Don't limit stored user name to \w in tests [GSM] (CPAN bug #54372)
- Allow tests to support versions back to Postgres 7.4 [GSM]
2.16.1 Released January 20, 2010 (subversion r13756)
- Output error messages in UTF-8 as needed. Reported by
Michael Hofmann. [GSM] (CPAN bug #53854)
2.16.0 Released December 17, 2009 (subversion r13672)
- Put in a test for high-bit characters in bytea handling.
[Bryce Nesbitt] (see also CPAN bug #39390)
- Better SQLSTATE code on connection failure (CPAN bug #52863)
[Chris Travers with help from Andrew Gierth]
- Fixed POD escapes (CPAN bug #51856) [FWIE@cpan.org]
2.15.1 Released August 7, 2009 (subversion r13173)
- Release to fix the SIGNATURE file. [GSM]
2.15.0 Released August 4, 2009 (subversion r13164)
- Use PQexecPrepared even when no placeholders (CPAN bug #48155) [GSM]
- Allow execute_array and bind_param_array to take oddly numbered items,
such that DBI will make missing entries undef/null (CPAN bug #39829) [GSM]
- Put single quotes around array literals when quoting arrays via
the quote() method. Per report from David Garamond (CPAN bug #48420) [GSM]
2.14.1 Released July 28, 2009 (subversion r13140)
- Remove invalid bigint assignment [Tim Bunce]
2.14.0 Released July 27, 2009 (subversion r13130)
- Make quoting of int, floats, and names much safer. (CPAN bug #41565) [GSM]
- Make quoting of geometric types respect all valid chars (CPAN bug #41565) [GSM]
- Fix quoting of booleans to respect more Perlish variants (CPAN bug #41565) [GSM]
- Return ints and bools-cast-to-number from the db as true Perlish numbers.
(CPAN bug #47619) [GSM]
- Fix backslash quoting of arrays (CPAN bug #46732) [GSM]
- Fix error when destringifying array starting with '[x:y]='. Per report from
Jeff Trout [GSM]
- Fix problem with foreign_key_info() and NAME_uc (CPAN bug #46109) [GSM]
- Make foreign_key_info() respect FetchHashKeyName (CPAN bug #46103) [GSM]
- Fix Makefile.PL to apply POSTGRES_INCLUDE in a saner way.
(CPAN bug #45769) [GAURAV@cpan.org]
- Improve Win32 README notes [Curtis Jewell]
- Fix spelling error in type_info (CPAN bug #47786) [justin.d.hunter@gmail.com]
- Add functions to support MS VC++ 7.0 (CPAN bug #47858) [Taro Nishino]
2.13.1 Released April 23, 2009 (subversion r12713)
- Fix leak in pg_warn (CPAN bug #45163) [rweikusat@mssgmbh.com]
2.13.0 Released April 13, 2009 (subversion r12695)
- Ensure we always set sqlstate inside of pg_st_prepare_statement
(CPAN bug #44732) [rweikusat@mssgmbh.com]
- When libpq has a connection error, return SQLSTATE 08000 ( "CONNECTION EXCEPTION" )
instead of the more generic 02000 ( "DATA EXCEPTION" ) (CPAN bug #44744)
[rweikusat@mssgmbh.com]
- Fix minor Perl::Critic nags (CPAN bug #44704) (Debian #bug 521969) [GSM]
- Clarify change of $dbh->{Name} behavior (CPAN bug 44985) [GSM]
2.12.0 Released March 28, 2009 (subversion r12627)
- Change large object interface from lo_* to pg_lo_* and make them accessible
via direct $dbh calls (e.g. $dbh->pg_lo_import instead of $dbh->func(..,'pg_lo_import').
The use of $dbh->func(... 'lo_*') is deprecated. [GSM] (CPAN bug #44467)
- Throw an exception for large_object functions called when AutoCommit is on,
but allow pg_lo_import and pg_lo_export to work. Reported by Kynn Jones.
[GSM] (CPAN bug #44461)
- Fix a memory leak when parsing returned arrays. Reported by Bálint Szilakszi.
[GSM] (CPAN bug #44225)
- Do proper dequoting of boolean arrays [Armando Santos, GSM] (CPAN bug #43768)
- Use pg_get_expr in column_info when available [Adam Sjøgren]
- Fix minor bugs in POD docs. [Frank Wiegand] (CPAN bug #44242)
- Fix minor bug in POD docs. [Tim Mattison]
2.11.8 Released December 28, 2008 (subversion r12161)
- Fix minor bug in t/12placeholders.t test (CPAN bug #41723)
2.11.7 Released December 13, 2008 (subversion r12158)
- Fix placeholder parsing logic (CPAN bug #41582)
2.11.6 Released November 30, 2008 (subversion r12126)
- Only set UTF8 flag on array items after UTF8 test. (CPAN bug #41253)
[Armando Santos]
2.11.5 Released November 24, 2008 (subversion r12102)
- Clear prepared_statement name on failure to prepare: prevents
the wrong error when using prepare_cached. [GSM]
2.11.4 Released November 12, 2008
- Don't set LC_MESSAGES unless superuser in tests. Remove all
language-specific string checking for tests. (CPAN bug #40604)
2.11.3 Released November 3, 2008 (subversion r12031)
- Force LC_MESSAGES to 'C' inside tests (CPAN bug #40604)
- Minor compiler tweaks.
- Fix small POD error (CPAN bug #40209)
- Tweak Perl::Critic policy list (CPAN bug #40130)
2.11.2 Released October 15, 2008 (subversion r11983)
- Fix core dump when invalid placeholders used. (CPAN bug #40075) [GSM]
2.11.1 Released October 14, 2008 (subversion r11980)
- $sth->{ParamTypes} returns 'TYPE' when possible.
2.11.0 Released October 13, 2008 (subversion r11976)
- $sth->{ParamTypes} now returns a hashref per the DBI docs. [GSM]
- Adjustment of Makefile.PL to fix problem with Strawberry Perl.
Thanks to Martin Evan (martin.evans@easysoft.com) and Brian
(elspicyjack@gmail.com) on the dbi-users list.
2.10.7 Released September 22, 2008 (subversion r11869)
- Fix test issue when dbname contains dashes.
[Rainer Tammer]
- Revert META.yml to 1.0, until such time as tools
can handle 1.1 (CPAN bug #39461) [Taro Nishino]
2.10.6 Released September 19, 2008 (subversion r11830)
- Correctly quote all bytea characters. (CPAN bug #39390) [Rod Taylor]
- Prevent core dump when checking $dbh->{standard_conforming_strings}
on older servers. [GSM]
- Skip unicode tests if server is set to 'LATIN1' [GSM]
2.10.5 Released September 16, 2008 (subversion r11800)
- Fix SIGNATURE file
2.10.4 Released September 16, 2008 (subversion r11797)
- Force use of math library when compiling. Per report
of AIX problems by Rainer Tammer.
2.10.3 Released August 31, 2008 (subversion r11706)
- Previous version had wrong SIGNATURE file
2.10.2 Released August 31, 2008 (subversion r11704)
- Fix minor problem in t/99_yaml.t
2.10.1 Released August 31, 2008 (subversion r11697)
- Minor testing fix.
2.10.0 Released August 26, 2008 (subversion r11678)
- Add the 'DBD' trace setting to output only non-DBI trace messages,
and allow 'dbd_verbose' as a connection attribute for the same
effect. [GSM]
- Fix a minor problem with testing against 7.4 databases [GSM]
- Allow multi-statement do() calls with parameters to work if pg_server_prepare
is set to 0 (CPAN bug #38623) [GSM]
2.9.2 Released August 18, 2008 (subversion r11664)
- Empty Postgres arrays should return empty Perl arrays, not undef.
(CPAN bug #38552) [David E. Wheeler]
2.9.1 Released August 17, 2008 (subversion r11660)
- Return undef when mapping Postgres array to Perl array and
the array is empty '{}'. (CPAN bug #38552) [GSM]
- Minor documentation improvements. [GSM]
2.9.0 Released August 3, 2008 (subversion r11624)
- Add support for database handle attribute "ReadOnly". This allows
use of $dbh->{ReadOnly} = 1 to enforce read only mode at
the server level. [GSM]
- Move PQexec structures to statement handle, to prevent
excessive malloc and free within execute function. [GSM]
- Add more attribute tests, improve testing system. [GSM]
- Many documentation improvements. [GSM]
- Win32 build improvements [T.J. Ferraro]
2.8.8 Released December 17, 2009
- Security release to fix high bit character problem in bytea
(CPAN bug #51153) (Debian bug #554489)
2.8.7 Released July 24, 2008 (subversion r11582)
- Modify test scripts to work better on FreeBSD boxes. [GSM]
- Much documentation improvement and POD tweaking. [GSM]
2.8.6 Released July 21, 2008 (subversion r11558)
- More testing improvements to increase odds of all tests being
run, especially when testing as root. [GSM]
2.8.5 Released July 13, 2008 (subversion r11529)
- Fix an obscure bug in which a coredump occurs if client_min_messages
is set to DEBUG3 or greater, and we then exit without disconnecting
while AutoCommit is off. The new behavior is to simply not attempt to
output the debugging information about the final 'rollback'. [GSM]
- More documentation improvements. [GSM]
2.8.4 Released July 10, 2008 (subversion r11520)
- Minor Perl::Critic test adjustments. [GSM]
- Documentation enhancements. [GSM]
- Yet more minor testing tweaks. [GSM]
2.8.3 Released July 6, 2008 (subversion r11495)
- Minor testing functionality tweaks, lots of test cleanups, minor doc enhancements. [GSM]
2.8.2 Released June 29, 2008 (subversion r11466)
- Minor testing tweaks, doc fixes. [GSM]
2.8.1 Released June 11, 2008 (subversion r11417)
- Force testing to use a custom socket dir, to avoid
permission problems. Thanks to Frank Wiegand for
help in uncovering this. [GSM]
2.8.0 Released June 1, 2008 (subversion r11366)
- Added in payload strings for LISTEN/NOTIFY in 8.4
via $dbh->pg_notifies() [GSM]
- Fixed problem preventing some pg_type bind_arrays
from working [GSM]
- Fix tests in t.04misc.t to handle Windows newlines.
(CPAN bug #36237) [Ian Macdonald]
- Clean up get_info() information. [GSM]
2.7.2 Released May 14, 2008 (subversion r11269)
- Handle embedded commas in quotes properly when destringifying
arrays. (CPAN bug #35862) [GSM]
- Fix typo in docs with trace_parser_flags() (Martin J. Evans)
- More testing tweaks [GSM]
2.7.1 Released May 11, 2008 (subversion r11250)
- Yet more minor testing tweaks. [GSM]
2.7.0 Released May 10, 2008 (subversion r11239)
- Have $dbh->quote() return E'' when server is >= 8.1 and string contains
backslashes. Fixes any problems with standard_conforming_strings.
(CPAN bug #27538) [GSM]
2.6.6 Released May 7, 2008 (subversion r11214)
- Fix minor problem in t/99_spellcheck.t [GSM]
2.6.5 Released May 7, 2008 (subversion r11209)
- Add spell checker to tests. [GSM]
- More tweaks to the testing suite. [GSM]
2.6.4 Released May 2, 2008 (subversion r11186)
- More tweaks to the test suite. [GSM]
2.6.3 Released May 1, 2008 (subversion r11169)
- Minor tweaks to the test suite. [GSM]
2.6.2 Released April 30, 2008 (subversion r11161)
- Fix coredump when pg_getcopydata copies 0 rows into a
freshly created var. (CPAN bug #35556) [David Harris]
- Allow 'make test' create a test database from scratch if
it cannot find an existing one to use. [GSM]
2.6.1 Released April 22, 2008 (subversion r11133)
- Don't free placeholder section, fixes problem when using
more than one named placeholder with the same name.
(CPAN bug #35303) [GSM]
2.6.0 Released April 16, 2008 (subversion r11095)
- Make pg_notifies a true function, so that you can now
use $dbh->pg_notifies instead of $dbh->func('pg_notifies') [GSM]
- Various performance improvements [GSM]
- Fix minor build and compilation issues with Strawberry Perl [GSM]
- Add Bundle::DBD::Pg [GSM]
2.5.1 Released April 7, 2008 (subversion r11056)
- Correctly handle negative PID numbers on Win32 systems when
generating prepared statement names (CPAN bug # 34738) [GSM]
2.5.0 Released March 23, 2008 (subversion r10990)
- Add pg_enum_values to $dbh->column_info()
[Dave Rolsky] (CPAN ticket #34351)
- Minor test fixes. [GSM]
2.4.0 Released March 21, 2008 (subversion r10974)
- Remove problematic and unneeded Test::Warn test from 00basic.t.
- Add $sth->{pg_current_row} [GSM]
2.3.0 Released March 19, 2008 (subversion r10951)
- Add $sth->{pg_bound} and $sth->{pg_numbound} [GSM]
- Fix broken call to $sth->{pg_segments} [GSM]
2.2.2 Released March 3, 2008 (subversion r10873)
- Remove non-working tracing from types.c and quote.c [GSM]
- Add parse_trace_flag as statement handle method. [GSM]
2.2.1 Released March 1, 2008 (subversion r10865)
- Fix memory leaks in dbdimp.c (CPAN bug #33743) [Alexey Tourbin]
- Fix strlen problems in dbdimp.c (CPAN bug #33737) [Alexey Tourbin]
- Fix char count in Renew() (CPAN bug #33738) [Alexey Tourbin]
- Change local trace_flags to lowercase. [GSM]
2.2.0 Released February 27, 2008 (subversion r10849)
- Introduce enhanced trace flags. See the documentation
on parse_trace_flags() for details. [GSM]
- Remove version.pm dependency from Makefile.PL (CPAN bug #33429)
2.1.3 Released February 20, 2008 (subversion r10813)
- Do not assume POSTGRES_LIB is a plain dirname, as it may have " -lssl".
2.1.2 Released February 19, 2008 (subversion r10806)
- Do not build if environment variables POSTGRES_HOME, POSTGRES_LIB,
or POSTGRES_INCLUDE are set but not valid.
- Fix dependency requirements, especially version.pm [GSM]
2.1.1 Released February 19, 2008 (subversion r10798)
- Better URLs to cpan.org resources. [GSM]
2.1.0 Released February 18, 2008 (subversion r10793)
- Use version.pm (CPAN bug #33206) [GSM]
- Add PERL_NO_GET_CONTEXT #define to improve performance on threaded Perls [GSM]
- Raise the minimum DBI version to 1.52. [GSM]
- Allow arrayrefs into bind_col (CPAN bug #33193) [GSM]
- Remove '//' style comments to make strict ANSI compilers happy.
[Trevor Inman] (CPAN bug #33089)
- Force client encoding of UTF8 for some tests. [GSM]
- Make 03dbmethod.t pass minor test for version 8.1.9 (CPAN bug #33282) [GSM]
- Add a local copy of dbivport.h [GSM]
2.0.0 Released February 10, 2008 (subversion r10715)
Major changes:
- Make minimum supported server 7.4. [GSM]
- Overhaul COPY functions: deprecate pg_getline, pg_putline,
and pg_endcopy. The new functions are pg_getcopydata,
pg_getcopydata_async, pg_putcopydata, and pg_putcopyend. [GSM]
- Add support for arrays: can pass in arrayrefs to execute, and
they are automatically returned as arrays when fetching. [GSM]
- Add support for asynchronous queries. [GSM]
- Allow raw transaction statements through - in other words,
do not croak if $dbh->prepare("COMMIT") is attempted. Not
only was this a little too controlling, there is a growing
host of other commands such as "COMMIT PREPARED" that we
need to allow. [GSM].
- Check transaction status after each command, to allow
things such as 'PREPARE TRANSACTION' to work properly.
(CPAN bug #32423) [GSM]
- Overhauled the data type system. [GSM]
- Switch from cvs to subversion. Switch from gborg to perl.org. [GSM]
- Change versioning system to three numbered system. [GSM]
Bug fixes:
- Add $dbh->{pg_placeholder_dollaronly} to allow '?' and other symbols
to be used in prepared statements without getting interpreted as
placeholders, i.e. the geometric operator '?#' (CPAN bug #24124) [GSM]
- Fix memory leak in bytea quoting. (CPAN bug #21392). Fix memory leak
in pg_notifies. [Stephen Marshall smarshall@wsi.com]
- Fix memory leak when using savepoints. (CPAN bug #29791) [airwave@cpan.org]
- Use adbin, not adsrc, when figuring out the sequence name for the
last_insert_id() method. This allows the function to work properly
if the sequence name is changed. Note that {pg_cache=>0} should be
passed to the function if you expect this might happen.
(CPAN bug #30924) [GSM]
- Use unsigned chars when parsing passed-in queries, preventing UTF-8
strings from ruining the prepare. UTF-16 may still cause problems.
(CPAN bug #31577) [GSM]
- Fix crash when executing query with two placeholders side by side.
Thanks to Daniel Browning for spotting this. [GSM]
- Skip item if no matching key in foreign_key_info.
(CPAN bug #32308) [GSM]
- Fix bug in last_insert_id. (CPAN bug #15918) [orentocy@gmail.com]
- Fix pg_description join in table_info(). [Max Cohan max@endpoint.com]
- Make sure arrays handle UTF-8 smoothly (CPAN bug #32479) [GSM]
- Force column names to respect utf8-ness. Per report from Ch Lamprect. [GSM]
- Make sure array items are marked as UTF as needed.
(CPAN bug #29656) [GSM]
- Force SQL_REAL and SQL_NUMERIC to be float8 not float4.
(CPAN bug #30010) [GSM]
- Allow objects with stringification overloading to work with quote().
(CPAN bug #32868) [David E. Wheeler and GSM]
- Use prepare_cached in last_insert_id function. (CPAN bug #24313)
- Switch from pow to powf to support AIX compiler issue.
(CPAN bug #24579) [GSM]
Enhancements and API changes:
- Complain loudly and fail to proceed if Makefile.PL finds no -lpq [GSM]
- Add three new columns to column_info, to return unquoted
version: pg_schema, pg_table, and pg_columns. Add all
three to primary_key_info, and the first two to table_info
(CPAN bug #20282) [GSM]
- Change $dbh->{User} to $dbh->{Username} [GSM]
- Change $dbh->{Name} to return the entire DSN string, minus the
'dbi:Pg:' part. Thanks to Mark Stosberg for the idea. [GSM]
- Allow data_sources to accept optional arguments. [GSM]
- Add private_attribute_info() method. [GSM]
- Add SQL_INTERVAL and others to types.c [GSM]
- Added statistics_info function [Brandon Black blblack@gmail.com]
- Be much more flexible in test connection options. [GSM]
- Overhaul test suite, allow tests to be run individually. [GSM]
New and experimental:
- Quick support for named trace level 'SQL' [GSM]
- Very experimental support for bind_param_inout, use with caution. [GSM]
Documentation fixes:
- Fix bad PG_INTEGER example in docs, thanks to Xavi Drudis Ferran.
(CPAN bug #31545) [GSM]
- Fix META.yml file. (CPAN bug #25759) [GSM]
1.49 May 7, 2006 (subversion r7814)
- Thanks to Backcountry.com for sponsoring work on this release. [GSM]
- Add the statement handle attribute ParamTypes, and fix an error
in ParamValues. ParamTypes requires DBI 1.49 or better. [GSM]
- Strip the final newline from error messages, so that die can add
in the line number. (CPAN bug #18900) [GSM]
- Make workaround for PQresultErrorField not returning proper
result when an error is set and we are connecting via TCP/IP.
This allows correct $dbh->state() values. [GSM]
- Fix incorrect quoting preventing compiling. (CPAN bug #18640)
- Add support for quoting and binding of geometric types: POINT,
LINE, LSEG, BOX, PATH, POLYGON, and CIRCLE. Also added the
TID type. [GSM]
1.48 April 5, 2006 (subversion r7781)
- Bump minimum DBI version to 1.45 (CPAN bug #18260) (plus problems
in versions 1.42 and 1.44) [GSM]
- Fix typo in Pg.pm code (CPAN bug #18537) [marc@sssonline.com]
- Ensure begin_work is properly set before err. (CPAN bug #18387) [GSM]
- Force PQexecParams to only run with DML. (CPAN bug #18258) [GSM]
- Fix bytea encoding problem (CPAN bug #18264) [GSM]
- Add documentation about connection service files (pg_service.conf).
[David Fetter]
1.47 March 20, 2006 (subversion r7748)
- Fix problem with selecting arrays. (CPAN bugs #18128 and
#18177) [GSM]
- Fix problem with dollar-sign placeholders. [GSM]
1.46 March 16, 2006 (subversion r7739)
- Fix problem with dollar-sign placeholders. (husseinp@gmail.com)
(CPAN bug #18209) [GSM]
1.45 February 27, 2006 (subversion r7733)
- Fix bug preventing bytea values over 20 characters from showing.
Spotted by Igor Shevchenko. [GSM]
1.44 February 21, 2006 (subversion r7727)
- Make sure pg_warn does not warn if the database attribute
PrintWarn is off. (Tyler MacDonald tyler@yi.org) [GSM]
- Add SIGNATURE file for Module::Signature verification. [GSM]
- Fix error in documentation for pg_errorlevel.
(CPAN bug #17434)
- Add experimental support for using DEFAULT values inside
of execute with $DBDPG_DEFAULT. [GSM]
- Return the proper SQLSTATE codes on connection failures.
(CPAN bug #17115) [GSM]
- Fix parser to handle leading parens. (CPAN bug #15481) [GSM]
- Make statement handles destruction abort early if
InactiveDestroy is set (CPAN bug #14978) [GSM]
- Make quote work properly for time/date types
(CPAN bug #15082) [GSM]
- Ensure all lo_ functions begin a transaction as needed
if they are the first action in a script
(CPAN bug # 13810) [GSM]
- Fix memory leak in dbdimp.c (k@sawada.cc) [Kenchi Sawada]
- Fix memory leak in dbdimp.c (dmitri@karasik.eu.org)
(CPAN bug #16054)
- Move package declaration lines to fix RPM parser problems
(CPAN bug #14509) [GSM]
- Add support for dollar quoting (CPAN bug #13608) [GSM]
- Added $dbh->{pg_default_port} method [GSM]
- Overhaul get_info data, add many more values [GSM]
- Overhaul type_info data (CPAN bug #13806) [GSM]
- Rewrite some of the quoting functions, reduce dependence
on libpq versions [GSM]
- Rewrite and optimize the do() method. Should be much faster
when called without placeholders. Thanks to Tom Lane
for suggesting this. [GSM]
- Double check PQserverVersion return and use alternate
method if it returns 0 (CPAN bug #14302)
- Add support for specifying type in $dbh->quote(),
such as $dbh->quote($var, {pg_type => DBD::Pg::PG_BYTEA})
Also support type => SQL_xx [GSM] (CPAN bug #13942)
- Fix pg_notifies() bug (CPAN bug #14232) [door@lcpi.ru]
- Add pg_ping() method [GSM]
- Make sure ping returns true, even if in failed transaction state
[thanks to Bill Moseley] [GSM]
- Fix COPY-related core dump [GSM]
- Fix strncpy bug in quote.c [Jun Kuriyama] (CPAN bug #14897)
- Fix error in is_high_bit_set() [Alexey Tourbin] (CPAN bug #13406)
1.43 June 23, 2005 (subversion r7586)
- Added README.dev file. [GSM]
- Fix statement-name related core dump. [GSM]
- Ensure state() returns an empty string, not 00000 on success.
(CPAN bug #13237) [michael.bell@web.de of OpenCA] [GSM]
- Fix rare core dump when $sth still in scope after disconnect [GSM]