File: package.xml

package info (click to toggle)
php-mdb2-driver-pgsql 1.5.0b4-2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, buster, sid, stretch
  • size: 272 kB
  • ctags: 540
  • sloc: php: 2,428; xml: 1,518; makefile: 2
file content (774 lines) | stat: -rw-r--r-- 32,029 bytes parent folder | download | duplicates (2)
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
<?xml version="1.0" encoding="UTF-8"?>
<package packagerversion="1.9.4" version="2.0" xmlns="http://pear.php.net/dtd/package-2.0" xmlns:tasks="http://pear.php.net/dtd/tasks-1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://pear.php.net/dtd/tasks-1.0 http://pear.php.net/dtd/tasks-1.0.xsd http://pear.php.net/dtd/package-2.0 http://pear.php.net/dtd/package-2.0.xsd">
 <name>MDB2_Driver_pgsql</name>
 <channel>pear.php.net</channel>
 <summary>pgsql MDB2 driver</summary>
 <description>This is the PostgreSQL MDB2 driver.</description>
 <lead>
  <name>Lukas Kahwe Smith</name>
  <user>lsmith</user>
  <email>smith@pooteeweet.org</email>
  <active>no</active>
 </lead>
 <lead>
  <name>Lorenzo Alberton</name>
  <user>quipo</user>
  <email>l.alberton@quipo.it</email>
  <active>yes</active>
 </lead>
 <developer>
  <name>Nathan Fredrickson</name>
  <user>nrf</user>
  <email>nathan@silverorange.com</email>
  <active>yes</active>
 </developer>
 <helper>
  <name>Ali Fazelzadeh</name>
  <user>afz</user>
  <email>afz@dev-code.com</email>
  <active>yes</active>
 </helper>
 <date>2012-10-23</date>
 <time>18:12:26</time>
 <version>
  <release>1.5.0b4</release>
  <api>1.5.0b4</api>
 </version>
 <stability>
  <release>beta</release>
  <api>beta</api>
 </stability>
 <license>BSD License</license>
 <notes>
- Remove assignment by reference, Bug #19585.
- PEAR::isError() -&gt; MDB2::isError(), Bug #19491.
- PEAR::loadExtension() -&gt; extension_loaded(), Bug #19583.
- Fixed boolean type conversion for non-boolean types
- Fix Bug #19262. Updates conditional stagements to use logical operators to include MDB2_FETCHMODE_OBJECT where appropriate. Was broken in r321197.
- Request #12931 Add cascading to dropTable?
- Have truncateTable() return MDB2_OK on success, as documented (bug 19201)
- Have vacuum() return MDB2_OK on success, as documented (bug 19196)
- Have dropConstraint() return MDB2_OK on success, as documented (bug 19194)
- Have createSequence() return MDB2_OK on success, as documented (bug 19192)
- Have dropSequence() return MDB2_OK on success, as documented (bug 19191).
- Make setOption(&apos;result_wrap_class&apos;) actually useful by changing the default value of $result_wrap_class parameters from false to true.
- Have pgsql only read LOB from file if lob_allow_url_include (bringing it in line with other drivers).
- FETCHMODE constants are NOT bitwise.
- fixed bug #18203: Type introspection breaks with associative arrays if names are identical (patch by Peter Bex)
- fixed bug #17890: Improper use of array_search in prepare function [fletcherj]
- fixed bug #17890: Improper use of array_search in prepare function [fletcherj]

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
 </notes>
 <contents>
  <dir baseinstalldir="/" name="/">
   <file baseinstalldir="/" md5sum="caa0be82e910d34c0d0ebe41d734ff6e" name="MDB2/Driver/Datatype/pgsql.php" role="php">
    <tasks:replace from="@package_version@" to="version" type="package-info" />
   </file>
   <file baseinstalldir="/" md5sum="79724a4fa1b9a0f616373fbbed365f97" name="MDB2/Driver/Function/pgsql.php" role="php">
    <tasks:replace from="@package_version@" to="version" type="package-info" />
   </file>
   <file baseinstalldir="/" md5sum="af78b3a1e93488cf73372a4de5e6ff9b" name="MDB2/Driver/Manager/pgsql.php" role="php">
    <tasks:replace from="@package_version@" to="version" type="package-info" />
   </file>
   <file baseinstalldir="/" md5sum="366a0a3cae301364136b93737c912034" name="MDB2/Driver/Native/pgsql.php" role="php">
    <tasks:replace from="@package_version@" to="version" type="package-info" />
   </file>
   <file baseinstalldir="/" md5sum="50fa3158dbc172a01a4a5b898a0a175c" name="MDB2/Driver/Reverse/pgsql.php" role="php">
    <tasks:replace from="@package_version@" to="version" type="package-info" />
   </file>
   <file baseinstalldir="/" md5sum="13e6c4d55ab846777dcee6793fc36f01" name="MDB2/Driver/pgsql.php" role="php">
    <tasks:replace from="@package_version@" to="version" type="package-info" />
   </file>
   <file baseinstalldir="/" md5sum="ec1439ac8f1209e28f103e5ee338d064" name="tests/Nonstandard/PgsqlHelper.php" role="test" />
   <file baseinstalldir="/" md5sum="03af23b6b991de5a067727d4dc2aebd1" name="package_pgsql.xml" role="data" />
  </dir>
 </contents>
 <dependencies>
  <required>
   <php>
    <min>5.2.0</min>
   </php>
   <pearinstaller>
    <min>1.9.1</min>
   </pearinstaller>
   <package>
    <name>MDB2</name>
    <channel>pear.php.net</channel>
    <min>2.5.0b4</min>
   </package>
   <extension>
    <name>pgsql</name>
   </extension>
  </required>
 </dependencies>
 <phprelease />
 <changelog>
  <release>
   <version>
    <release>1.5.0b4</release>
    <api>1.5.0b4</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2012-10-23</date>
   <license>BSD License</license>
   <notes>
- Remove assignment by reference, Bug #19585.
- PEAR::isError() -&gt; MDB2::isError(), Bug #19491.
- PEAR::loadExtension() -&gt; extension_loaded(), Bug #19583.
- Fixed boolean type conversion for non-boolean types
- Fix Bug #19262. Updates conditional stagements to use logical operators to include MDB2_FETCHMODE_OBJECT where appropriate. Was broken in r321197.
- Request #12931 Add cascading to dropTable?
- Have truncateTable() return MDB2_OK on success, as documented (bug 19201)
- Have vacuum() return MDB2_OK on success, as documented (bug 19196)
- Have dropConstraint() return MDB2_OK on success, as documented (bug 19194)
- Have createSequence() return MDB2_OK on success, as documented (bug 19192)
- Have dropSequence() return MDB2_OK on success, as documented (bug 19191).
- Make setOption(&apos;result_wrap_class&apos;) actually useful by changing the default value of $result_wrap_class parameters from false to true.
- Have pgsql only read LOB from file if lob_allow_url_include (bringing it in line with other drivers).
- FETCHMODE constants are NOT bitwise.
- fixed bug #18203: Type introspection breaks with associative arrays if names are identical (patch by Peter Bex)
- fixed bug #17890: Improper use of array_search in prepare function [fletcherj]
- fixed bug #17890: Improper use of array_search in prepare function [fletcherj]

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.5.0b3</release>
    <api>1.5.0b3</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2010-08-29</date>
   <license>BSD License</license>
   <notes>
- fixed bug #16281: getTableFieldDefinition() does not recognize NULL defaults
  with datatype [Holger Schletz]
- fixed bug #16384: alterTable() does not remove NOT NULL constraints [Holger Schletz]
- fixed bug #16405: Compatibility issues with escaped strings [hschletz]

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.5.0b2</release>
    <api>1.5.0b2</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2009-01-14</date>
   <license>BSD License</license>
   <notes>
- fixed bug #12117: disconnect() does not work as documented
- fixed bug #13481: getTableConstraintDefinition() may return incomplete results
- fixed bug #13877: UNIQUE index not always recognized as constraint
- fixed bug #14292: alterTable() cannot change column type when no implicit cast is defined
- fixed bug #14510: getTableFieldDefinition() does not unquote defaults
- fixed bug #14828: unixtimestamp() generates invalid SQL for non-constant argument
- fixed bug #15056: tableInfo does not work with pgsql schemas (added support to
  table schemas to Manager module)

Thanks to Holger Schletz for all the above patches!

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html Extended Query)
   </notes>
  </release>
  <release>
   <version>
    <release>1.5.0b1</release>
    <api>1.5.0b1</api>
   </version>
   <stability>
    <release>alpha</release>
    <api>alpha</api>
   </stability>
   <date>2008-03-15</date>
   <license>BSD License</license>
   <notes>
- request #12731: added truncateTable() in the Manager module
- request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction
- request #12800: added alterDatabase() in the Manager module
- fixed bug #12846: missing escape in getSequenceName() on PostgreSQL 8.2.4
  [thanks to Stephane Berthelot]
- fixed bug #12920: added new error info and fixed escape method if connection doesn&apos;t exist [afz]
- fixed bug #12922: use standaloneQuery() in alterDatabase() [afz]
- fixed bug #12924: correctly handle internal expected errors even with custom error handling
- added standaloneQuery() and databaseExists()
- fixed bug #13112: the Reverse module does not know the timestamptz data type
- request #13106: added unixtimestamp() in the Function module
- fixed bug #13281: list FOREIGN KEY constraints in listTableConstraints() in the Manager module
- fixed bug #13356: added float4 to _mapNativeDatatype()
- fixed query in getTableConstraintDefinition() for FK constraints in the Reverse module
  (thanks to Andre&apos; Restivo)

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.5.0a2</release>
    <api>1.5.0a2</api>
   </version>
   <stability>
    <release>alpha</release>
    <api>alpha</api>
   </stability>
   <date>2007-12-06</date>
   <license>BSD License</license>
   <notes>
- fixed bug #12376: getTableConstraintDefinition() in the Reverse module
  uses incorrect column number in certain cases (thanks to Dennis Birne)
- request #12338: added &apos;disable_smart_seqname&apos; option to make improved
  getSequenceName() behaviour optional (thanks to Dennis Birne) (@see bug #9106)
- request #12012: added collation support in createDatabase()

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.5.0a1</release>
    <api>1.5.0a1</api>
   </version>
   <stability>
    <release>alpha</release>
    <api>alpha</api>
   </stability>
   <date>2007-10-28</date>
   <license>BSD License</license>
   <notes>
- initial support for FOREIGN KEY and CHECK constraints in the Reverse and Manager modules
- fixed bug #10986: Using more random statement names (request #11625)
- request #11297: added support for &quot;schema.table&quot; (or &quot;owner.table&quot;) notation
  in the Reverse module (related to bug #11207)
- fixed bug #11428: propagate quote() errors with invalid data types
- fixed bug in MDB2_Statement_pgsql::_execute(), called property of invalid object
- fixed bug #11624: getSequenceName() returning incorrect results with multiple
  schemas and &apos;SET search_path&apos;
- fixed bug #11652: failed prepared queries containing the &quot;::type&quot; style of casting
- fixed bug #11694: remove data type cast from DEFAULT value in getTableFieldDefinition()
  in the Reverse module
- fixed bug #11753: NOTICEs in alterTable() in the Manager module
- fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x
- fixed some E_STRICT errors with PHP5
- fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success,
  as documented
- fixed bug #12269: tableInfo() in the Reverse module detect &apos;clob&apos; data type
  as first option

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.4.1</release>
    <api>1.4.1</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2007-05-03</date>
   <license>BSD License</license>
   <notes>
- return length as &quot;precision,scale&quot; for NUMERIC and DECIMAL fields in mapNativeDatatype()
- more accurate field size information in getTableFieldDefinition() in the
  Reverse module
- in getTableIndexDefinition() and getTableConstraintDefinition() in the Reverse
  module, also return the field position in the index/constraint
- Request #9106: more accurate sequence name retrieval routine in getSequenceName()
- fixed bug #10895: setLimit() does not work properly when a subquery uses LIMIT

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.4.0</release>
    <api>1.4.0</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2007-03-13</date>
   <license>BSD License</license>
   <notes>
- propagate errors in getTableFieldDefinition() in the Reverse module
- implemented getTriggerDefinition() in the Reverse module [experimental]
- implemented listTableTriggers() in the Manager module
- don&apos;t show catalog views in listViews() in the Manager module
- implemented a fallback mechanism within getTableIndexDefinition() and
  getTableConstraintDefinition() in the Reverse module to ignore the &apos;idxname_format&apos;
  option and use the index name as provided in case of failure before returning
  an error
- added a &apos;nativetype_map_callback&apos; option to map native data declarations back to
  custom data types (thanks to Andrew Hill).
- lastInsertID() without parameters now returns the last used ID (request #9989)
- phpdoc fixes

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.3.0</release>
    <api>2.3.0</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-11-03</date>
   <license>BSD License</license>
   <notes>
- fixed _modifyQuery() for manipulation queries
- fixed inheritance structure of convertResult()
- added support for new &apos;disable_iso_date&apos; date DSN option (Request #8739)
- added support for getting the table name in tableInfo()
- added connection to pg_escape_*() calls
- fixed _modifyQuery() for manipulation queries
- enable detection of proper size of integers in mapNativeDatatype
- migrated to package.xml version 2

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
- add option to use unnamed prepared statements
  (see http://www.postgresql.org/docs/current/static/protocol-flow.html &quot;Extended Query&quot;)
   </notes>
  </release>
  <release>
   <version>
    <release>1.2.2</release>
    <api>1.2.2</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-09-03</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- flip positions property array in prepared statement objects to make it
  possible to optionally use the same named placeholder in multiple places
  inside a single prepared statement

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
   </notes>
  </release>
  <release>
   <version>
    <release>1.2.1</release>
    <api>1.2.1</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-08-21</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- return an error if a named placeholder name is used twice inside a single statement
- do not list empty contraints and indexes
- do not set a default if type is a LOB (Request #8074)
- fixed handling return values when disable_query is set in _doQuery() and _execute()
- increased MDB2 dependency too 2.2.1

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
   </notes>
  </release>
  <release>
   <version>
    <release>1.2.0</release>
    <api>1.2.0</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-07-23</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- performance tweaks for pg_prepare() enabled installations
- MDB2_PORTABILITY_RTRIM ignored by driver (Bug #8239)
- added ability to escape wildcard characters in escape() and quote()
- added setTransactionIsolation()
- added savepoint support to beginTransaction(), commit() and rollback()
- added debug() call at the end of a query/prepare/execute calling (Request #7933)
- added context array parameter to debug() and make use of it whereever sensible
- added optional method name parameter to raiseError() and use whereever possible
- added ability to escape wildcard characters in escape() and quote()
- added debug() call at the end of a query/prepare/execute calling (Request #7933)
- added &apos;nativetype&apos; output to tableInfo() and getTableFieldDefinition()
- added &apos;mdb2type&apos; output to getTableFieldDefinition()
- reworked tableInfo() to use a common implementation based on getTableFieldDefinition()
  when a table name is passed (Bug #8124)
- fixed incorrect regex in mapNativeDatatype() (Bug #8256) (thx ioz at ionosfera dot com)
- disconnect after changing database/DSN (otherwise transactions may be left open)
- use old dsn when rolling back open transactions in disconnect()

open todo items:
- enable pg_execute() once issues with bytea column are resolved
- use pg_result_error_field() to handle localized error messages (Request #7059)
   </notes>
  </release>
  <release>
   <version>
    <release>1.1.0</release>
    <api>1.1.0</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-06-15</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- added setCharset()
- use setCharset() in connect()/_doConnect()
- generalized quoteIdentifier() with a property
- switched most array_key_exists() calls to !empty() to improve readability and performance
- fixed a few edge cases and potential warnings
- return error when changing datatypes in alterTable() on pgsql version lower than 8.x (Bug #7731)
- added ability to rewrite queries for query(), exec() and prepare() using a debug handler callback
- fixed missing error handling in getTableFieldDefinition() (Bug #7791)
- pass limit and offset to the result object constructor in _execute() for read statements
- use pg_prepare() if available so that we do not need to define the types anymore (Request #7797)
- added code to use pg_execute() but disabled due to issues with bytea fields
- check if result/connection has not yet been freed/dicsonnected before
  attempting to free a result set(Bug #7790)
- revert change that would prefer &apos;clob&apos; over &apos;text&apos; for TEXT fields
  (this was breaking runtime instrospection)

open todo items:
- enable pg_execute() once issues with bytea column are resolved
   </notes>
  </release>
  <release>
   <version>
    <release>1.0.3</release>
    <api>1.0.3</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-05-24</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
SECURITY FIX (http://www.postgresql.org/docs/techdocs.50)
- use pg_escape_string()
- use &quot;&apos;&quot; as the escape character
- limit fetch to 1 row in listTableFields()
   </notes>
  </release>
  <release>
   <version>
    <release>1.0.2</release>
    <api>1.0.2</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-05-23</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- added &quot;emulate_prepared&quot; option to force prepared statement emulation
- tweaked handling of free() for prepared statements
- return error if a prepared statement is attempted to be freed twice
- fixed notice when using prepare() without placeholders
   </notes>
  </release>
  <release>
   <version>
    <release>1.0.1</release>
    <api>1.0.1</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-05-14</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- added listTableViews() (request #6773)
- explicitly set is_manip parameter to false for transaction debug calls
- pass parameter array as debug() all with scope &quot;parameters&quot; in every execute()
  call (bug #4119)
- typo fixes in phpdoc (thx Stoyan)
- added support for fixed and variable types for &apos;text&apos; in declarations,
  as well as in reverse engineering (Request #1523)
- made _doQuery() return a reference
- added userinfo&apos;s to all raiseError calls that previously had none
- calling PREPARE is always a manip query
- added &apos;prepared_statements&apos; supported meta data setting
- strip of file:// prefix in writeLOBToFile()
- typo fix ressource/resource in LOB array
- added missing supported parameter to prepare() signature
- properly handle explicit error codes in errorInfo()
- moved from OID to TEXT and BYTEA (OID handling was broken, its also deprecated)
   </notes>
  </release>
  <release>
   <version>
    <release>1.0.0</release>
    <api>1.0.0</api>
   </version>
   <stability>
    <release>stable</release>
    <api>stable</api>
   </stability>
   <date>2006-02-09</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- handle null as resource when disable_query option is enabled in result object

open todo items:
- considering migrating away from OID&apos;s to bytea, since this is encourage
  since version 8 and is also what PDO expects, however there is no streaming
  API for bytea columns .. this needs to be done using manually chunked reads/writes
   </notes>
  </release>
  <release>
   <version>
    <release>0.2.4</release>
    <api>0.2.4</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2006-02-05</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- added support for length in integer and decimal columns
- removed ugly hack for quote parameter in quote() since it was insufficient
  (escaping also needs to be prevented)
- added support for out of order parameter binding in prepared queries
- reset row_limit and row_offset after calling prepare() just like we do for query() and exec()
- cosmetic fix (removed &quot;row_&quot; prefix from &quot;row_limit&quot; and &quot;row_offset&quot;)
- improved parsing in getServerInfo() (bug #6550)

open todo items:
- considering migrating away from OID&apos;s to bytea, since this is encourage
  since version 8 and is also what PDO expects, however there is no streaming
  API for bytea columns .. this needs to be done using manually chunked reads/writes
   </notes>
  </release>
  <release>
   <version>
    <release>0.2.3</release>
    <api>0.2.3</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2006-01-13</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- explicitly pass if the module is phptype specific in all loadModule calls (bug #6226)
- fixed signature of executeStoredProc()
- typo fixes in error handling of nextResult() and numRows() calls
- _fixIndexName() now just attempts to remove possible formatting
- renamed _isSequenceName() to _fixSequenceName()
- _fixSequenceName() now just attempts to remove possible formatting, and only
  returns a boolean if no formatting was applied when the new &quot;check&quot; parameter is set to true
- fixed bug that caused unique indexes from not being seen (bug #6476)

open todo items:
- considering migrating away from OID&apos;s to bytea, since this is encourage
  since version 8 and is also what PDO expects, however there is no streaming
  API for bytea columns .. this needs to be done using manually chunked reads/writes
   </notes>
  </release>
  <release>
   <version>
    <release>0.2.2</release>
    <api>0.2.2</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2005-12-30</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- types can now always be keyed by name or by order

open todo items:
- considering migrating away from OID&apos;s to bytea, since this is encourage
  since version 8 and is also what PDO expects, however there is no streaming
  API for bytea columns .. this needs to be done using manually chunked reads/writes
   </notes>
  </release>
  <release>
   <version>
    <release>0.2.1</release>
    <api>0.2.1</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2005-12-28</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- fixed datatype conversion for &quot;time&quot; values
- fixed getTableFieldDefinition() default handling (though still a bit shaky)
- reverse module: ensure that parameters in queries are properly quoted
- fixed bug in alterTable() where &quot;rename&quot; would be skipped if no other alteration is done
- do not use multiple commands in ALTER TABLE (only supported since 8.0)
- implemented native prepared queries
- use proper error code in alterTable()
- renamed table as the last step in alterTable()
- proper quote new table name in alterTable()

open todo items:
- considering migrating away from OID&apos;s to bytea, since this is encourage
  since version 8 and is also what PDO expects, however there is no streaming
  API for bytea columns .. this needs to be done using manually chunked reads/writes
   </notes>
  </release>
  <release>
   <version>
    <release>0.2.0</release>
    <api>0.2.0</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2005-12-21</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
- do not fix case in listUsers()
- unified case fixing in the list*() methods
- tweaked text handling in mapNativeDatatype()
- use getConnection() to access connection property
- split index and constraint handling
- quote identifiers where possible inside the manager methods depending on
  the new &apos;quote_identifier&apos; option (defaults to off)
- refactored get*Declaration() methods to use getTypeDeclaration()
- added support for table and column renaming as well as default and nullability
  changing in alterTable()
- setting in_transaction to false on disconnect
- added new Function modules to handle difference in SQL functions
- force rollback() with open transactions on disconnect
- escape floats to make sure they do not contain evil characters (bug #5608)
- split off manipulation queries into exec() method from the query() method *BC BREAK*
- if result_types is set to false in prepare() method the query will be handled as a DML statement *BC BREAK*
- use a proper default value if a field is set to not null in _getDeclaration*() (bug #5930)
- added ability to determine unsigned in mapNativeDatatype()
  (only really implemented in the mysql(i) drivers) (bug #6054)
- use MDB2_ERROR_NOT_FOUND in getTableConstraintDefinition() and getTableIndexDefinition() (bug #6055)
- added getServerVersion()
- unified array structure in mapNativeDatatype() *BC BREAK*
- added &apos;mdbtype&apos; to tableInfo() output that is generated from mapNativeDatatype()
- changed &apos;len&apos; to &apos;length&apos; in tableInfo() output *BC BREAK*

open todo items:
- implement native prepared queries
- migrate away from OID&apos;s to bytea, since this is encourage since version 8
  and is also what PDO expects
- testgettablefielddefinition and testnow test cases fail
   </notes>
  </release>
  <release>
   <version>
    <release>0.1.1</release>
    <api>0.1.1</api>
   </version>
   <stability>
    <release>beta</release>
    <api>beta</api>
   </stability>
   <date>2005-10-10</date>
   <license uri="http://www.example.com">BSD License</license>
   <notes>
Warning: this release features numerous BC breaks!

There have been considerable improvements to the datatype, manager and reverse
modules. Furthermore preliminary support for auto increment and primary keys
has been added. Please note that making a field auto increment implies a single
column primary key on this field.

- increased php dependency to 4.3.0 due to the usage of the streams API since beta5
- fixed typo in _getTextDeclaration()
- alterTable now needs the full definition to work (use getTableFieldDefinition
 from Reverse module if you do not have a definition at hand) this eliminates the need
 of the declaration part in the alterTable array.
- fix PHP4.4 breakage
- improved error mapping (ported from DB)
- better detect if the query returned a result set or not in _doQuery()
- minor tweaks to LOB handling
- use !empty() instead of isset() in fetchRow to determine if result cols were bound or result types were set
- moved all private fetch mode fix methods into _fixResultArrayValues() for performance reasons
- renamed MDB2_PORTABILITY_LOWERCASE to MDB2_PORTABILITY_FIX_CASE and use &apos;field_case&apos; option to determine if to upper- or lowercase (CASE_LOWER/CASE_UPPER)
- use array_key_exists() instead of isset() where possible
- changed structure of field add/remove/change in alterTable() to match MDB2_Schema
- added createIndex()
- return 0 for manipulation queries when disable_query is enabled
- tweaked getTableFieldDefinition() in reverse module
- added getTypeDeclaration() in the datatype module
- tweaked field changing in alterTable()
- fixed alterTable() signature

open todo items:
- implement native prepared queries
   </notes>
  </release>
 </changelog>
</package>