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 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141 2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752 2753 2754 2755 2756 2757 2758 2759 2760 2761 2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824 2825
|
Changes for the DBD::Pg module
RT refers to rt.cpan.org
Version 3.18.0 (released December 6, 2023)
- Support new PQclosePrepared function, added in Postgres 17
[Greg Sabino Mullane]
- Better docs about ping always returning a value
(Github issue #121)
Version 3.17.0 (released August 23, 2023)
- New database handle attribute pg_skip_deallocate
Prevents any deallocation of automatically prepared
statements to support new pgBouncer feature
[Greg Sabino Mullane]
- Fix to handle escaped quotes in connection string
[Dagfinn Ilmari Mannsåker]
- Return number of affected rows from a MERGE command
[Greg Sabino Mullane]
(Github issue #118)
- Add support for Github CI actions
[Gábor Szabó]
(Github pull request #115)
- Remove undocumented internal-only pg_pid_number attribute
[Greg Sabino Mullane]
(Github issue #102)
- Small warning in docs about PG_CHAR
[Greg Sabino Mullane]
(Github issue #103)
Version 3.16.3 (released April 4, 2023)
- Fix to remove MYMETA files added by mistake to tarball
Version 3.16.2 (released April 4, 2023)
- Force test suite to use a specific shell for the initdb command
[Ed Sabol]
(Github issue #104)
- Revert to using META.yml, and generate MYMETA.* files
(Github issue #111)
(Github issue #113)
Version 3.16.1 (released March 5, 2023)
- Add new attribute "pg_int8_as_string", for backwards compatibility.
[Alexander Gorlov]
(Github pull request #100)
- Add a META.json file; rename META.yml to META.yaml
- Fix 03smethod.t $sth->last_insert_id skip count for DBI < 1.642
[Dagfinn Ilmari Mannsåker]
(Github issue #99)
- Documentation improvements for service files
[Erik Rijkers]
Version 3.16.0 (released August 8, 2022)
- Automatically use 64-bit versions of large object functions when available
[Dagfinn Ilmari Mannsåker, David Christensen]
- Set UTF8 flag as needed for error messages
[Github user olafgw]
(Github issue #97)
- In tests, do not assume what the default transaction isolation level will be
[Rene Schickbauer]
(Github issue #94)
- Make tests smarter about detecting pg_ctl results in different locales
[Greg Sabino Mullane]
(Github issue #95)
Version 3.15.1 (released February 13, 2022)
- Fix missing "use File::Temp"
[Greg Sabino Mullane]
(Github issue #79)
- Switch from DynaLoader to XSLoader
[Todd Rinaldo <toddr@cpan.org>]
(Github pull request #76)
- Replace use of "vars" with "our"
[James Raspass <jraspass@gmail.com>]
(Github pull request #75)
- Documentation improvements
[Ed Sabol]
[Nicholas Clark <nick@ccl4.org>]
- Use non-root user when calling pg_resetwal
[Greg Sabino Mullane]
- Allow use of $ENV{DBDPG_TEMPDIR} to shorten test directory paths.
(Github issue #78)
Version 3.15.0 (released May 21, 2021)
- Correctly pull back pg_async status from statement handle.
Previously, $dbh->{pg_async} would return undef.
[Greg Sabino Mullane]
(RT ticket #136553)
- Adjust tests for the fact that reltuples can be -1 in Postgres
version 14 and later. This is mostly reflected in the CARDINALITY
column for $dbh->statistics_info.
[Greg Sabino Mullane]
- Remove the experimental 'fulltest' Makefile target.
[Greg Sabino Mullane]
(RT ticket #136567)
Version 3.14.2 (released August 13, 2020)
- Fix ENV typo in the test suite
[Gregor Herrmann]
- Renamed and enhanced test helper script: dbdpg_test_postgres_versions.pl
[Greg Sabino Mullane]
Version 3.14.1 (released August 12, 2020)
- Force the version string so undefined errors in the "driver" sub go away.
[Greg Sabino Mullane]
(RT ticket #83057)
Version 3.14.0 (released July 19, 2020)
- The $dbh->primary_key_info and $dbh->foreign_key_info methods will now always return
a statement handle, even with no matches. Previously, they returned undef directly.
Callers can check if the returned handle contains any rows.
[Greg Sabino Mullane]
- The $dbh->tables method will always return a list, even if it is empty.
[Greg Sabino Mullane]
- Add pg_lo_tell64, pg_lo_seek64, and pg_lo_truncate64, for anyone dealing
with really, really, really large 'large objects'. Requires Postgres 9.3 or better.
[Greg Sabino Mullane]
(RT ticket #123561)
- Allow test to run again when using a non-superuser to connect
[Greg Sabino Mullane]
(RT ticket #132865)
- Adjust tests to force loading proper version of DBD::Pg every time.
[Greg Sabino Mullane]
- Removed the long-deprecated _pg_use_catalog method.
[Greg Sabino Mullane]
- Many improvements and changes to the test suite.
[Greg Sabino Mullane]
Version 3.13.0 (released June 17, 2020)
- Redo the "last_result" internals in dbdimp.c, which
fixes a memory leak.
[Greg Sabino Mullane]
(RT ticket #132812)
- Fix regression in Perl length() for returned query results
[Jon Jensen]
(Github issue #72)
- Make $sth->finish() do a little less. Notably, even
after calling finish(), pg_error_field will still work
on the last action performed.
[Greg Sabino Mullane]
- Tweak tests so Windows boxes pass
[Greg Sabino Mullane]
Version 3.12.3 (released June 5, 2020)
- Prevent DBI from flipping AutoCommit to 'on' after a failed commit
[Greg Sabino Mullane]
(Github issue #71)
Version 3.12.2 (released June 4, 2020)
- Revert overly aggressive testing shortcut as it can cause installs to fail
[Greg Sabino Mullane, with apologies]
Version 3.12.1 (released June 3, 2020)
- Remove test that assumed '(12,34)' is an invalid entry for type "circle",
as the Postgres source code changed this behavior on April 7, 2020
[Greg Sabino Mullane]
(RT ticket #132740)
Version 3.12.0 (released May 7, 2020)
- Add CONTRIBUTING.md file
- Return the table info row last in statistics_info.
This fixes statistics_info on pre-8.3 servers.
[Dagfinn Ilmari Mannsåker]
- Fix ASC_OR_DESC field in statistics_info
[Dagfinn Ilmari Mannsåker]
- Indicate NULL ordering in statistics_info
[Dagfinn Ilmari Mannsåker]
Version 3.11.1 (released April 28, 2020)
- Adjust Makefile to fix failing 'fulltest' target on BSD systems
[Slaven Rezić]
(RT ticket #132412)
Version 3.11.0 (released April 23, 2020)
- Indicate non-key index columns (INCLUDE) in statistics_info
[Dagfinn Ilmari Mannsåker]
- Return an empty result set instead of undef from statistics_info
when the requested table doesn't exist and $unique_only is false.
[Dagfinn Ilmari Mannsåker]
- Fix segfault during st destroy
[Gregory Oschwald]
(Github pull request #66)
(Github issue #57)
- Improve testing for table_info()
[Greg Sabino Mullane]
(Github issue #67)
- Improve UTF-8 wording in docs
[Felipe Gasper]
(Github pull request #65)
Version 3.10.5 (released March 23, 2020)
- Minor adjustment for Windows build
(RT ticket #131752)
- Allow test suite to work on an EnterpriseDB server
[H.Merijn Brand]
(RT ticket #132203)
- Add small warning regarding ShowErrorStatement
(RT ticket #120268)
Version 3.10.4 (released February 3, 2020)
- Allow localtime from Time::Piece to be used directly as a bind value again.
This applies to all "magical" arrays.
[Greg Sabino Mullane]
(Github issue #63)
- Force tests to NOT run in parallel.
[Greg Sabino Mullane]
(RT ticket #130834)
Version 3.10.3 (released January 20, 2020)
- Set things cleared via PQclear to NULL as soon as possible, to remove race conditions
[Greg Sabino Mullane]
(RT ticket #131522)
Version 3.10.2 (released January 17, 2020)
- Adjust tests to pass on 32-bit machines
[Greg Sabino Mullane]
(RT ticket #131482)
Version 3.10.1 (released January 13, 2020)
- Prevent double-free memory errors
[Greg Sabino Mullane]
(RT ticket #130681)
- Fix crash when pg_error_field is called
[Greg Sabino Mullane]
(RT ticket #130721)
- Update the list of Postgres reserved words in quote.c
Version 3.10.0 (released September 3, 2019)
- Prevent memory leak related to pg_error_field
[Greg Sabino Mullane]
(RT ticket #130430)
- Fix for bug by making sure pg_error_field works properly when switching between
do-with-params and do-without-params.
[Greg Sabino Mullane]
(Github issue #57)
- If a commit or rollback fails, do not set BegunWork
[Greg Sabino Mullane]
(Github issue #40)
- Treat partitioned tables same as regular tables for column_info, table_info,
and foreign_key_info (i.e. support pg_class.relkind = 'p')
[Octavian R. Corlade]
(Github pull request #55)
- Allow last_insert_id() to work against inherited tables
[Greg Sabino Mullane]
(RT ticket #52441)
- Add DBI SQL_BLOB, SQL_BINARY and SQL_LONGVARBINARY types as alias for PG_BYTEA
[Pali]
(Github pull request #58)
Version 3.9.1 (released August 15, 2019)
- Bug fix for pg_error_field: make sure we do not feed null to newSVpv,
handle older versions of Postgres better.
[Greg Sabino Mullane]
Version 3.9.0 (released August 13, 2019)
- ShowErrorStatement works for "quickexec" do() calls
[Dmitry Karasik]
(RT ticket #120268)
(Github issue #44)
- Add :pg_limits to add constants such as PG_MAX_SMALLINT
[Greg Sabino Mullane]
(Github issue #51)
- Add $dbh->pg_error_field() function
[Greg Sabino Mullane]
- Fix failing tests due to incorrect 'initdb' check
[Greg Sabino Mullane]
(Github issue #54)
(RT ticket #130279)
Version 3.8.1 (released July 6, 2019)
- Fix encoding of SQL_VARBINARY type in $dbh->quote() function
[Pali]
- Fix encoding in $dbh->do() function
[Pali]
(RT ticket #122991)
- Fix E'' string escape handling on architectures with unsigned chars
(Github issue #46)
- Minor fix to allow DBD::Pg to connect to internal 'pgbouncer' database
that is created by PgBouncer
[Greg Sabino Mullane]
(Github issue #47)
- Fix so table_info test works on non-empty databases
[Matt Buchanan]
(RT ticket #127906)
Version 3.8.0 (released April 25, 2019)
- Increase minimum supported PostgreSQL version to 8.0
[Dagfinn Ilmari Mannsåker]
- Add support for foreign tables in table_info() and column_info()
[Dagfinn Ilmari Mannsåker]
- Return the current database name as TABLE_CAT in info methods
[Dagfinn Ilmari Mannsåker]
- Handle backslash-escaped quotes in E'' strings
[Dagfinn Ilmari Mannsåker]
- Fix typo in Makefile.PL
(RT ticket #127097)
- Fix parsing of PostgreSQL versions >= 10 on Debian/Ubuntu
[Dagfinn Ilmari Mannsåker]
- Fix client_min_messages=FATAL test when PostgreSQL caps it to ERROR
[Dagfinn Ilmari Mannsåker]
(RT ticket #128529)
- Fix ->ping error detection on PostgreSQL 12
[Dagfinn Ilmari Mannsåker]
- Adjust tests for new pg_ctl output
[Erik Rijkers er at xs4all.nl]
(RT ticket #128966)
- Adjust tests for removal of WITH OIDS in PostgreSQL 12
[Dagfinn Ilmari Mannsåker]
- Fix support for PostgreSQL versions back to 8.0
[Dagfinn Ilmari Mannsåker]
- Remove usage of deprecated pg_attrdef.adsrc and pg_constraint.consrc columns
[Dagfinn Ilmari Mannsåker]
- Fix typo in pg_placeholder_colons example
(Github issue #41)
- Support GENERATED ... AS IDENTITY columns in last_insert_id()
[Dagfinn Ilmari Mannsåker]
Version 3.7.4 (released February 12, 2018)
- Fix typo in META.yml
(RT ticket #124405)
Version 3.7.3 (released February 12, 2018)
- Test tweak so we don't try to use jsonb on older versions.
(RT ticket #124934)
Version 3.7.2 (released February 11, 2018)
- Remove Data::Peek dependency accidentally left in t/12placeholders.t
(RT ticket #124393)
Version 3.7.1 (released February 11, 2018)
- Fixed problem when using placeholders and escaped question marks, the recopied string
was not terminated correctly.
[Greg Sabino Mullane]
(Github issue #33)
(RT tickets #121630, #123187, #123999)
- Make sure nulls in our self-generated arrays are not set as read-only in some Perls.
[Greg Sabino Mullane]
(RT ticket #107556)
- If the server returns no error message, and an "unknown" code from libpq, supply a custom
message mentioning client_min_messages may be to blame.
[Greg Sabino Mullane]
(RT ticket #109591)
- Declare VERSION with 'our' in seldom-used Bundle module
(RT ticket #123218)
Version 3.7.0 (released September 24, 2017)
- If no placeholders, use PQexec instead of PQexecParams
[Greg Sabino Mullane]
- Fix running tests with non-UTF8 server_encoding
[Dagfinn Ilmari Mannsåker]
(Github issue #26)
- Fix crash with missing client_encoding
[David Christensen, reported by Marko Tiikkaja]
(Github issue #29)
- Fix crash with missing server_version
[David Christensen]
- Fix leak in ->state methods
[Dagfinn Ilmari Mannsåker]
(Github issue #30)
- Add $sth->{pg_async_status} to determine async status of a statement handle.
Values can be 0 (no async), 1 (async), or -1 (cancelled)
[Greg Sabino Mullane, as requested by Dmytro Zagashev (ZDM)]
(RT ticket #116172)
Version 3.6.2 (released May 23, 2017)
- Remove errant debugging aid from test suite
Version 3.6.1 (released May 22, 2017)
- Various fixes to support testing against Postgres 10beta
[David Christensen]
Version 3.6.0 (released April 17, 2017)
- Make sure we do not inadvertently modify the string passed to prepare() when
doing the new backslash escape manipulation.
[Greg Sabino Mullane]
(RT ticket #114000)
- Fix bug where $DBD::Pg::DBDPG_DEFAULT not picked up as a magic
string first time it is used in a script.
[Greg Sabino Mullane]
(RT ticket #112309)
- Fix UTF8 flag handling in pg_(get|put)copydata
[Dagfinn Ilmari Mannsåker]
- Fix UTF8 double-encoding with pg_enable_utf8 = 0
[Serge Pushkin]
(RT ticket #103137)
- Fix bug in quote_name which would fail to quote in some circumstances
(Github issue #22)
- Allow clean parsing of new Postgres X.Y version format
[Erik Rijkers er at xs4all.nl]
- Add pg_canonical_ids() and pg_canonical_names(), which returns information
about each column in the result set.
[Warstone warstone at list.ru]
(RT ticket #106858)
- Map SQL_NUMERIC to PG_NUMERIC (instead of PG_FLOAT8)
[Alice Maz alice at alizemaz.com]
(RT ticket #120358)
- Force real, float, and double precision into SvNVs
[Greg Sabino Mullane]
(RT ticket #113683 and other places)
- Support for number of rows greater than an "int". Requires support for same
from a future version of libpq before it will work completely.
[Greg Sabino Mullane]
(RT ticket #102444)
- Fix skipped test counts in Win32 builds
[Andy Grundman]
- Allow tests to work against Postgres 8.4 by tweaking client_encoding calls.
[Pavel Raiskup praiskup at redhat.com]
(RT ticket #116179)
- Silence warnings in t/02attribs.t and t/04misc.t
[Dagfinn Ilmari Mannsåker]
- Support binary COPY format
[Dagfinn Ilmari Mannsåker]
- Ensure tests do not use $ENV{PGSERVICE} or $ENV{PGDATABASE}
[Erik Rijkers]
- Switched canonical repo to git://github.com/bucardo/dbdpg.git
Version 3.5.3 (released October 1, 2015)
- Minor fix in the test file t/03dbmethod.t
Version 3.5.2 (released September 29, 2015)
- 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]
(RT ticket #106604)
- Set the repository in META.yml to github
Version 3.5.1 (released February 17, 2015)
- Prevent core dump if the second argument to the quote() method is
anything but a hashref
[Greg Sabino Mullane]
(RT ticket #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)
- 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]
(RT ticket #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]
(RT ticket #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)
- Fix bug where single-quoted type arguments to the table_info()
method were causing a SQL error.
[Greg Sabino Mullane]
(RT ticket #99144)
Version 3.4.1 (released August 20, 2014)
- 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)
- Cleanup and improve table_info()
[Mike Pomraning <mjp@pilcrow.madison.wi.us>]
(Github issue #7)
Method table_info() type searching now supports TABLE, VIEW, SYSTEM TABLE,
SYSTEM VIEW, and LOCAL TEMPORARY
Method table_info() object searching fully supports the above types.
Method 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.
Method tableinfo() type filters are strictly matched now ... previously a
search for SYSTEM TABLE would have fetched plain TABLE objects.
Method 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]
(RT ticket #97032)
Version 3.3.0 (released May 31, 2014)
- 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]
(RT tickets #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)
- Stricter testing for array slices: disallow number-colon-number from being
parsed as a placeholder.
[Greg Sabino Mullane]
(RT ticket #95713)
- Fix for small leak with AutoInactiveDestroy
[David Dick]
(RT ticket #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)
- Add new attribute pg_placeholder_nocolons to turn off all parsing of
colons into placeholders.
[Graham Ollis]
(RT ticket #95173)
- Fix incorrect skip count for HandleSetErr
[Greg Sabino Mullane]
(RT ticket #94841)
- Don't attempt to use the POSIX signaling stuff if the OS is Win
[Greg Sabino Mullane]
(RT ticket #94841)
- Fix missing check for PGINITDB in the test suite.
[Nicholas Clark]
Version 3.1.1 (released April 6, 2014)
- Minor adjustments so tests pass in varying locales.
Version 3.1.0 (released April 4, 2014)
- 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]
(RT ticket #92724)
Version 3.0.0 (released February 3, 2014)
- 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]
(RT ticket #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]
(RT ticket #85836)
- Return better sqlstate codes on fatal errors
[Rainer Weikusat]
- Better prepared statement names to avoid bug
[Spencer Sun]
(RT ticket #88827)
- Add pg_expression field to statistics_info output to show
functional index information
[Greg Sabino Mullane]
(RT ticket #76608)
- Adjust lo_import_with_oid check for 8.3
(RT ticket #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]
(RT ticket #68893)
- Fix ORDINAL_POSITION in foreign_key_info
[Dagfinn Ilmari Mannsåker]
(RT ticket #88794)
- Fix foreign_key_info with unspecified schema
[Dagfinn Ilmari Mannsåker]
(RT ticket #88787)
- Allow foreign_key_info to work when pg_expand_array is off
[Greg Sabino Mullane and Tim Bunce]
(RT ticket #51780)
- Remove math.h linking, as we no longer need it
(RT ticket #79256)
- Spelling fixes
(RT ticket #78168)
- Better wording for the AutoCommit docs
(RT ticket #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]
(RT ticket #59449)
- Avoid reinstalling driver methods in threads
[Dagfinn Ilmari Mannsåker]
(RT ticket #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]
(RT ticket #90799)
- Fix typo in docs for pg_placeholder_dollaronly
[Bryan Carpenter]
(RT ticket #91400)
- Cleanup dangling largeobjects in tests
[Fitz Elliott]
(RT ticket #92212)
- Fix skip test counting in t/09arrays.t
[Greg Sabino Mullane]
(RT ticket #79544)
- Explicitly specify en_US for spell checking
[Dagfinn Ilmari Mannsåker]
(RT ticket #91804)
Version 2.19.3 (released August 21, 2012)
- Fix bug in pg_st_split_statement causing segfaults
(RT ticket #79035)
- Make sure table_info() and other functions use pg_tablespace_location()
instead of spclocation for Postgres servers 9.2 and greater.
[Greg Sabino Mullane + others]
(RT ticket #77042)
Version 2.19.2 (released March 12, 2012)
- Fix errors when multiple same-named placeholders are used.
[Greg Sabino Mullane]
(RT ticket #75713)
Version 2.19.1 (released March 10, 2012)
- Fix crash when passing in an array with undefined elements.
[Greg Sabino Mullane]
Version 2.19.0 (released March 9, 2012)
- Use proper formatting for warn() and croak()
[Niko Tyni]
(RT ticket #75642)
- Fix localized regex in test
(RT ticket #70759)
- Fix for named placeholders
[Jan Pazdziora]
(RT ticket #70953)
- Various fixes to the array-marshaling code
[Noah Misch, Mark Stosberg, and David Christensen]
(RT ticket #58552)
- Allow hi-bit chars in dollar-quoted identifiers
[David Christensen]
(RT ticket #73832)
- Have do() return count for things such as CREATE TABLE .. AS SELECT
Will only work on 9.0 or better.
[Pavel Stehule]
(RT ticket #71073)
- Better error message when trying to do things post-disconnect
[Greg Sabino Mullane]
- Always respect pg_server_prepare=0 by using PQexec not PQexecParams.
[Greg Sabino Mullane]
- Fix error in async docs
(RT ticket #72812)
- Switch from subversion to git
Install with: git clone git://bucardo.org/dbdpg.git
[Greg Sabino Mullane]
Version 2.18.1 (released May 9, 2011)
- Fix LANG testing issue
[Greg Sabino Mullane]
(RT ticket #56705)
- Fix bug when async commands issued immediately after a COPY.
[Greg Sabino Mullane]
(RT ticket #68041)
Version 2.18.0 (released March 28, 2011)
- Thanks to 123people.com for sponsoring work on this release
[Greg Sabino Mullane]
- New cancel() method per DBI spec.
[Eric Simon]
(RT ticket #63516)
- Fix memory leak when binding arrays
[Greg Sabino Mullane]
(RT ticket #65734)
- Fix memory leak with ParamValues.
[Martin J. Evans]
(RT ticket #60863)
- Fix memory leak in handle_old_async (missing PQclear)
[Rainer Weikusat]
(RT ticket #63408)
- Fix memory leak in pg_db_cancel (missing PQclear)
[Rainer Weikusat]
(RT ticket #63441)
- Mark pg_getcopydata strings as UTF8 as needed
(RT ticket #66006)
- Function dequote_bytea returning void should not try to return something
[Dagobert Michelsen]
(RT ticket #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
[Greg Sabino Mullane]
(RT ticket #61713)
- Fix failing test when run as non-superuser
[Greg Sabino Mullane]
(RT ticket #61534)
Version 2.17.2 (released November 21, 2010)
- Support dequoting of hex bytea format for 9.0.
[Dagfinn Ilmari Mannsåker]
(RT ticket #60200)
- Don't PQclear on execute() if there is an active async query
[rweikusat at mssgmbh.com]
(RT ticket #58376)
- Allow data_sources() to accept any case-variant of 'dbi:Pg'
(RT ticket #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
(RT ticket #61574)
Version 2.17.1 (released April 8, 2010)
- Only use lo_import_with_oid if Postgres libraries are 8.4 or better
[Greg Sabino Mullane]
(RT ticket #56363)
Version 2.17.0 (released April 6, 2010)
- Do not automatically ROLLBACK on a failed pg_cancel
[Greg Sabino Mullane]
(RT ticket #55188)
- Added support for new lo_import_with_oid function.
[Greg Sabino Mullane]
(RT ticket #53835)
- Don't limit stored user name to \w in tests
[Greg Sabino Mullane]
(RT ticket #54372)
- Allow tests to support versions back to Postgres 7.4
[Greg Sabino Mullane]
Version 2.16.1 (released January 20, 2010)
- Output error messages in UTF-8 as needed. Reported by Michael Hofmann.
[Greg Sabino Mullane]
(RT ticket #53854)
Version 2.16.0 (released December 17, 2009)
- Put in a test for high-bit characters in bytea handling.
[Bryce Nesbitt]
(RT ticket #39390)
- Better SQLSTATE code on connection failure
[Chris Travers with help from Andrew Gierth]
(RT ticket #52863)
- Fixed POD escapes
[FWIE at cpan.org]
(RT ticket #51856)
Version 2.15.1 (released August 7, 2009)
- Release to fix the SIGNATURE file.
[Greg Sabino Mullane]
Version 2.15.0 (released August 4, 2009)
- Use PQexecPrepared even when no placeholders
[Greg Sabino Mullane]
(RT ticket #48155)
- Allow execute_array and bind_param_array to take oddly numbered items,
such that DBI will make missing entries undef/null
[Greg Sabino Mullane]
(RT ticket #39829)
- Put single quotes around array literals when quoting arrays via
the quote() method. Per report from David Garamond
[Greg Sabino Mullane]
(RT ticket #48420)
Version 2.14.1 (released July 28, 2009)
- Remove invalid bigint assignment
[Tim Bunce]
Version 2.14.0 (released July 27, 2009)
- Make quoting of int, floats, and names much safer.
[Greg Sabino Mullane]
(RT ticket #41565)
- Make quoting of geometric types respect all valid chars
[Greg Sabino Mullane]
(RT ticket #41565)
- Fix quoting of booleans to respect more Perlish variants
[Greg Sabino Mullane]
(RT ticket #41565)
- Return ints and bools-cast-to-number from the db as true Perlish numbers.
[Greg Sabino Mullane]
(RT ticket #47619)
- Fix backslash quoting of arrays
[Greg Sabino Mullane]
(RT ticket #46732)
- Fix error when destringifying array starting with '[x:y]='. Per report from Jeff Trout
[Greg Sabino Mullane]
- Fix problem with foreign_key_info() and NAME_uc
[Greg Sabino Mullane]
(RT ticket #46109)
- Make foreign_key_info() respect FetchHashKeyName
[Greg Sabino Mullane]
(RT ticket #46103)
- Fix Makefile.PL to apply POSTGRES_INCLUDE in a saner way.
[GAURAV at cpan.org]
(RT ticket #45769)
- Improve Win32 README notes
[Curtis Jewell]
- Fix spelling error in type_info
[justin.d.hunter at gmail.com]
(RT ticket #47786)
- Add functions to support MS VC++ 7.0
[Taro Nishino]
(RT ticket #47858)
Version 2.13.1 (released April 23, 2009)
- Fix leak in pg_warn
[rweikusat at mssgmbh.com]
(RT ticket #45163)
Version 2.13.0 (released April 13, 2009)
- Ensure we always set sqlstate inside of pg_st_prepare_statement
[rweikusat at mssgmbh.com]
(RT ticket #44732)
- When libpq has a connection error, return SQLSTATE 08000 ( "CONNECTION EXCEPTION" )
instead of the more generic 02000 ( "DATA EXCEPTION" )
[rweikusat at mssgmbh.com]
(RT ticket #44744)
- Fix minor Perl::Critic nags
(RT ticket #44704)
(Debian bug #521969)
[Greg Sabino Mullane]
- Clarify change of $dbh->{Name} behavior
[Greg Sabino Mullane]
(RT ticket #44985)
Version 2.12.0 (released March 28, 2009)
- 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.
[Greg Sabino Mullane]
(RT ticket #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.
[Greg Sabino Mullane]
(RT ticket #44461)
- Fix a memory leak when parsing returned arrays. Reported by Bálint Szilakszi.
[Greg Sabino Mullane]
(RT ticket #44225)
- Do proper dequoting of boolean arrays
[Armando Santos, Greg Sabino Mullane]
(RT ticket #43768)
- Use pg_get_expr in column_info when available
[Adam Sjøgren]
- Fix minor bugs in POD docs.
[Frank Wiegand]
(RT ticket #44242)
- Fix minor bug in POD docs.
[Tim Mattison]
Version 2.11.8 (released December 28, 2008)
- Fix minor bug in t/12placeholders.t test
(RT ticket #41723)
Version 2.11.7 (released December 13, 2008)
- Fix placeholder parsing logic
(RT ticket #41582)
Version 2.11.6 (released November 30, 2008)
- Only set UTF8 flag on array items after UTF8 test.
[Armando Santos]
(RT ticket #41253)
Version 2.11.5 (released November 24, 2008)
- Clear prepared_statement name on failure to prepare: prevents
the wrong error when using prepare_cached.
[Greg Sabino Mullane]
Version 2.11.4 (released November 12, 2008)
- Don't set LC_MESSAGES unless superuser in tests. Remove all
language-specific string checking for tests.
(RT ticket #40604)
Version 2.11.3 (released November 3, 2008)
- Force LC_MESSAGES to 'C' inside tests
(RT ticket #40604)
- Minor compiler tweaks.
- Fix small POD error
(RT ticket #40209)
- Tweak Perl::Critic policy list
(RT ticket #40130)
Version 2.11.2 (released October 15, 2008)
- Fix core dump when invalid placeholders used.
[Greg Sabino Mullane]
(RT ticket #40075)
Version 2.11.1 (released October 14, 2008)
- Attribute $sth->{ParamTypes} returns 'TYPE' when possible.
Version 2.11.0 (released October 13, 2008)
- Attribute $sth->{ParamTypes} now returns a hashref per the DBI docs.
[Greg Sabino Mullane]
- Adjustment of Makefile.PL to fix problem with Strawberry Perl. Thanks
to Martin Evan <martin.evans at easysoft.com>
and Brian <elspicyjack at gmail.com> on the dbi-users list.
Version 2.10.7 (released September 22, 2008)
- Fix test issue when dbname contains dashes.
[Rainer Tammer]
- Revert META.yml to 1.0, until such time as tools can handle 1.1
[Taro Nishino]
(RT ticket #39461)
Version 2.10.6 (released September 19, 2008)
- Correctly quote all bytea characters.
[Rod Taylor]
(RT ticket #39390)
- Prevent core dump when checking $dbh->{standard_conforming_strings}
on older servers.
[Greg Sabino Mullane]
- Skip unicode tests if server is set to 'LATIN1'
[Greg Sabino Mullane]
Version 2.10.5 (released September 16, 2008)
- Fix SIGNATURE file
Version 2.10.4 (released September 16, 2008)
- Force use of math library when compiling. Per report
of AIX problems by Rainer Tammer.
Version 2.10.3 (released August 31, 2008)
- Previous version had wrong SIGNATURE file
Version 2.10.2 (released August 31, 2008)
- Fix minor problem in t/99_yaml.t
Version 2.10.1 (released August 31, 2008)
- Minor testing fix.
Version 2.10.0 (released August 26, 2008)
- Add the 'DBD' trace setting to output only non-DBI trace messages,
and allow 'dbd_verbose' as a connection attribute for the same effect.
[Greg Sabino Mullane]
- Fix a minor problem with testing against 7.4 databases
[Greg Sabino Mullane]
- Allow multi-statement do() calls with parameters to work if pg_server_prepare
is set to 0
[Greg Sabino Mullane]
(RT ticket #38623)
Version 2.9.2 (released August 18, 2008)
- Empty Postgres arrays should return empty Perl arrays, not undef.
[David E. Wheeler]
(RT ticket #38552)
Version 2.9.1 (released August 17, 2008)
- Return undef when mapping Postgres array to Perl array and
the array is empty '{}'
[Greg Sabino Mullane]
(RT ticket #38552)
- Minor documentation improvements.
[Greg Sabino Mullane]
Version 2.9.0 (released August 3, 2008)
- Add support for database handle attribute "ReadOnly". This allows use
of $dbh->{ReadOnly} = 1 to enforce read only mode at the server level.
[Greg Sabino Mullane]
- Move PQexec structures to statement handle, to prevent
excessive malloc and free within execute function.
[Greg Sabino Mullane]
- Add more attribute tests, improve testing system.
[Greg Sabino Mullane]
- Many documentation improvements.
[Greg Sabino Mullane]
- Win32 build improvements
[T.J. Ferraro]
Version 2.8.8 (released December 17, 2009)
- Security release to fix high bit character problem in bytea
(RT ticket #51153)
(Debian bug #554489)
Version 2.8.7 (released July 24, 2008)
- Modify test scripts to work better on FreeBSD boxes.
[Greg Sabino Mullane]
- Much documentation improvement and POD tweaking.
[Greg Sabino Mullane]
Version 2.8.6 (released July 21, 2008)
- More testing improvements to increase odds of all tests being
run, especially when testing as root.
[Greg Sabino Mullane]
Version 2.8.5 (released July 13, 2008)
- 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'.
[Greg Sabino Mullane]
- More documentation improvements.
[Greg Sabino Mullane]
Version 2.8.4 (released July 10, 2008)
- Minor Perl::Critic test adjustments.
[Greg Sabino Mullane]
- Documentation enhancements.
[Greg Sabino Mullane]
- Yet more minor testing tweaks.
[Greg Sabino Mullane]
Version 2.8.3 (released July 6, 2008)
- Minor testing functionality tweaks, lots of test cleanups, minor doc enhancements.
[Greg Sabino Mullane]
Version 2.8.2 (released June 29, 2008)
- Minor testing tweaks, doc fixes.
[Greg Sabino Mullane]
Version 2.8.1 (released June 11, 2008)
- Force testing to use a custom socket dir, to avoid permission problems.
Thanks to Frank Wiegand for help in uncovering this.
[Greg Sabino Mullane]
Version 2.8.0 (released June 1, 2008)
- Added in payload strings for LISTEN/NOTIFY in 9.0 via $dbh->pg_notifies()
[Greg Sabino Mullane]
- Fixed problem preventing some pg_type bind_arrays from working
[Greg Sabino Mullane]
- Fix tests in t.04misc.t to handle Windows newlines.
[Ian Macdonald]
(RT ticket #36237)
- Clean up get_info() information.
[Greg Sabino Mullane]
Version 2.7.2 (released May 14, 2008)
- Handle embedded commas in quotes properly when destringifying arrays.
[Greg Sabino Mullane]
(RT ticket #35862)
- Fix typo in docs with trace_parser_flags()
[Martin J. Evans]
- More testing tweaks
[Greg Sabino Mullane]
Version 2.7.1 (released May 11, 2008)
- Yet more minor testing tweaks.
[Greg Sabino Mullane]
Version 2.7.0 (released May 10, 2008)
- Have $dbh->quote() return E'' when server is >= 8.1 and string contains
backslashes. Fixes any problems with standard_conforming_strings.
[Greg Sabino Mullane]
(RT ticket #27538)
Version 2.6.6 (released May 7, 2008)
- Fix minor problem in t/99_spellcheck.t
[Greg Sabino Mullane]
Version 2.6.5 (released May 7, 2008)
- Add spell checker to tests.
[Greg Sabino Mullane]
- More tweaks to the testing suite.
[Greg Sabino Mullane]
Version 2.6.4 (released May 2, 2008)
- More tweaks to the test suite.
[Greg Sabino Mullane]
Version 2.6.3 (released May 1, 2008)
- Minor tweaks to the test suite.
[Greg Sabino Mullane]
Version 2.6.2 (released April 30, 2008)
- Fix coredump when pg_getcopydata copies 0 rows into a freshly created var.
[David Harris]
(RT ticket #35556)
- Allow 'make test' create a test database from scratch if
it cannot find an existing one to use.
[Greg Sabino Mullane]
Version 2.6.1 (released April 22, 2008)
- Don't free placeholder section, fixes problem when using
more than one named placeholder with the same name.
[Greg Sabino Mullane]
(RT ticket #35303)
Version 2.6.0 (released April 16, 2008)
- Make pg_notifies a true function, so that you can now
use $dbh->pg_notifies instead of $dbh->func('pg_notifies')
[Greg Sabino Mullane]
- Various performance improvements
[Greg Sabino Mullane]
- Fix minor build and compilation issues with Strawberry Perl
[Greg Sabino Mullane]
- Add Bundle::DBD::Pg
[Greg Sabino Mullane]
Version 2.5.1 (released April 7, 2008)
- Correctly handle negative PID numbers on Win32 systems when
generating prepared statement names
[Greg Sabino Mullane]
(RT ticket #34738)
Version 2.5.0 (released March 23, 2008)
- Add pg_enum_values to $dbh->column_info()
[Dave Rolsky]
(RT ticket #34351)
- Minor test fixes.
[Greg Sabino Mullane]
Version 2.4.0 (released March 21, 2008)
- Remove problematic and unneeded Test::Warn test from 00basic.t.
- Add $sth->{pg_current_row}
[Greg Sabino Mullane]
Version 2.3.0 (released March 19, 2008)
- Add $sth->{pg_bound} and $sth->{pg_numbound}
[Greg Sabino Mullane]
- Fix broken call to $sth->{pg_segments}
[Greg Sabino Mullane]
Version 2.2.2 (released March 3, 2008)
- Remove non-working tracing from types.c and quote.c
[Greg Sabino Mullane]
- Add parse_trace_flag as statement handle method.
[Greg Sabino Mullane]
Version 2.2.1 (released March 1, 2008)
- Fix memory leaks in dbdimp.c
[Alexey Tourbin]
(RT ticket #33743)
- Fix strlen problems in dbdimp.c
[Alexey Tourbin]
(RT ticket #33737)
- Fix char count in Renew()
[Alexey Tourbin]
(RT ticket #33738)
- Change local trace_flags to lowercase.
[Greg Sabino Mullane]
Version 2.2.0 (released February 27, 2008)
- Introduce enhanced trace flags. See the documentation
on parse_trace_flags() for details.
[Greg Sabino Mullane]
- Remove version.pm dependency from Makefile.PL
(RT ticket #33429)
Version 2.1.3 (released February 20, 2008)
- Do not assume POSTGRES_LIB is a plain dirname, as it may have " -lssl".
Version 2.1.2 (released February 19, 2008)
- Do not build if environment variables POSTGRES_HOME, POSTGRES_LIB,
or POSTGRES_INCLUDE are set but not valid.
- Fix dependency requirements, especially version.pm
[Greg Sabino Mullane]
Version 2.1.1 (released February 19, 2008)
- Better URLs to cpan.org resources.
[Greg Sabino Mullane]
Version 2.1.0 (released February 18, 2008)
- Use version.pm
[Greg Sabino Mullane]
(RT ticket #33206)
- Add PERL_NO_GET_CONTEXT #define to improve performance on threaded Perls
[Greg Sabino Mullane]
- Raise the minimum DBI version to 1.52.
[Greg Sabino Mullane]
- Allow arrayrefs into bind_col
[Greg Sabino Mullane]
(RT ticket #33193)
- Remove '//' style comments to make strict ANSI compilers happy.
[Trevor Inman]
(RT ticket #33089)
- Force client encoding of UTF8 for some tests.
[Greg Sabino Mullane]
- Make 03dbmethod.t pass minor test for version 8.1.9
(RT ticket #33282)
[Greg Sabino Mullane]
- Add a local copy of dbivport.h
[Greg Sabino Mullane]
Version 2.0.0 (released February 10, 2008)
- Make minimum supported server 7.4.
[Greg Sabino Mullane]
- 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.
[Greg Sabino Mullane]
- Add support for arrays: can pass in arrayrefs to execute, and
they are automatically returned as arrays when fetching.
[Greg Sabino Mullane]
- Add support for asynchronous queries.
[Greg Sabino Mullane]
- 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.
[Greg Sabino Mullane]
- Check transaction status after each command, to allow
things such as 'PREPARE TRANSACTION' to work properly.
[Greg Sabino Mullane]
(RT ticket #32423)
- Overhauled the data type system.
[Greg Sabino Mullane]
- Switch from cvs to subversion. Switch from gborg to perl.org.
[Greg Sabino Mullane]
- Change versioning system to three numbered system.
[Greg Sabino Mullane]
- 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 '?#'
[Greg Sabino Mullane]
(RT ticket #24124)
- Fix memory leaks in bytea quoting and in pg_notifies.
[Stephen Marshall smarshall at wsi.com]
(RT ticket #21392)
- Fix memory leak when using savepoints.
[airwave at cpan.org]
(RT ticket #29791)
- 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.
[Greg Sabino Mullane]
(RT ticket #30924)
- Use unsigned chars when parsing passed-in queries, preventing UTF-8
strings from ruining the prepare. UTF-16 may still cause problems.
[Greg Sabino Mullane]
(RT ticket #31577)
- Fix crash when executing query with two placeholders side by side.
Thanks to Daniel Browning for spotting this.
[Greg Sabino Mullane]
- Skip item if no matching key in foreign_key_info.
[Greg Sabino Mullane]
(RT ticket #32308)
- Fix bug in last_insert_id.
[orentocy at gmail.com]
(RT ticket #15918)
- Fix pg_description join in table_info().
[Max Cohan max at cohan.biz]
- Make sure arrays handle UTF-8 smoothly
[Greg Sabino Mullane]
(RT ticket #32479)
- Force column names to respect utf8-ness. Per report from Ch Lamprect.
[Greg Sabino Mullane]
- Make sure array items are marked as UTF as needed.
[Greg Sabino Mullane]
(RT ticket #29656)
- Force SQL_REAL and SQL_NUMERIC to be float8 not float4.
[Greg Sabino Mullane]
(RT ticket #30010)
- Allow objects with stringification overloading to work with quote().
[David E. Wheeler and Greg Sabino Mullane]
(RT ticket #32868)
- Use prepare_cached in last_insert_id function.
(RT ticket #24313)
- Switch from pow to powf to support AIX compiler issue.
[Greg Sabino Mullane]
(RT ticket #24579)
- Complain loudly and fail to proceed if Makefile.PL finds no -lpq
[Greg Sabino Mullane]
- 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
[Greg Sabino Mullane]
(RT ticket #20282)
- Change $dbh->{User} to $dbh->{Username}
[Greg Sabino Mullane]
- Change $dbh->{Name} to return the entire DSN string, minus
the 'dbi:Pg:' part. Thanks to Mark Stosberg for the idea.
[Greg Sabino Mullane]
- Allow data_sources to accept optional arguments.
[Greg Sabino Mullane]
- Add private_attribute_info() method.
[Greg Sabino Mullane]
- Add SQL_INTERVAL and others to types.c
[Greg Sabino Mullane]
- Added statistics_info function
[Brandon Black blblack at gmail.com]
- Be much more flexible in test connection options.
[Greg Sabino Mullane]
- Overhaul test suite, allow tests to be run individually.
[Greg Sabino Mullane]
- Support for named trace level 'SQL'
[Greg Sabino Mullane]
- Experimental support for bind_param_inout.
[Greg Sabino Mullane]
- Fix bad PG_INTEGER example in docs, thanks to Xavi Drudis Ferran.
[Greg Sabino Mullane]
(RT ticket #31545)
- Fix META.yml file.
[Greg Sabino Mullane]
(RT ticket #25759)
Version 1.49 (released May 7, 2006)
- Thanks to Backcountry.com for sponsoring work on this release.
[Greg Sabino Mullane]
- Add the statement handle attribute ParamTypes, and fix an error
in ParamValues. ParamTypes requires DBI 1.49 or better.
[Greg Sabino Mullane]
- Strip the final newline from error messages, so that die can add in the line number.
[Greg Sabino Mullane]
(RT ticket #18900)
- 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.
[Greg Sabino Mullane]
- Fix incorrect quoting preventing compiling.
(RT ticket #18640)
- Add support for quoting and binding of geometric
types: POINT, LINE, LSEG, BOX, PATH, POLYGON, and CIRCLE.
Also added the TID type.
[Greg Sabino Mullane]
Version 1.48 (released April 5, 2006)
- Bump minimum DBI version to 1.45
[Greg Sabino Mullane]
(RT ticket #18260)
- Fix typo in Pg.pm code
[marc at sssonline.com]
(RT ticket #18537)
- Ensure begin_work is properly set before err.
[Greg Sabino Mullane]
(RT ticket #18387)
- Force PQexecParams to only run with DML.
[Greg Sabino Mullane]
(RT ticket #18258)
- Fix bytea encoding problem
[Greg Sabino Mullane]
(RT ticket #18264)
- Add documentation about connection service files (pg_service.conf).
[David Fetter]
Version 1.47 (released March 20, 2006)
- Fix problem with selecting arrays.
[Greg Sabino Mullane]
(RT tickets #18128 and #18177)
- Fix problem with dollar-sign placeholders.
[Greg Sabino Mullane]
Version 1.46 (released March 16, 2006)
- Fix problem with dollar-sign placeholders.
[husseinp at gmail.com]
(RT ticket #18209)
Version 1.45 (released February 27, 2006)
- Fix bug preventing bytea values over 20 characters from showing.
Spotted by Igor Shevchenko.
[Greg Sabino Mullane]
Version 1.44 (released February 21, 2006)
- Make sure pg_warn does not warn if the database attribute
PrintWarn is off.
[Tyler MacDonald tyler at yi.org]
[Greg Sabino Mullane]
- Add SIGNATURE file for Module::Signature verification.
[Greg Sabino Mullane]
- Fix error in documentation for pg_errorlevel.
(RT ticket #17434)
- Add experimental support for using DEFAULT values inside
of execute with $DBDPG_DEFAULT.
[Greg Sabino Mullane]
- Return the proper SQLSTATE codes on connection failures.
(RT ticket #17115)
[Greg Sabino Mullane]
- Fix parser to handle leading parens.
(RT ticket #15481)
[Greg Sabino Mullane]
- Make statement handles destruction abort early if InactiveDestroy is set
(RT ticket #14978)
[Greg Sabino Mullane]
- Make quote work properly for time/date types
(RT ticket #15082)
[Greg Sabino Mullane]
- Ensure all lo_ functions begin a transaction as needed
if they are the first action in a script
(RT ticket #13810)
[Greg Sabino Mullane]
- Fix memory leak in dbdimp.c
[Kenchi Sawada]
- Fix memory leak in dbdimp.c
[dmitri at karasik.eu.org]
(RT ticket #16054)
- Move package declaration lines to fix RPM parser problems
[Greg Sabino Mullane]
(RT ticket #14509)
- Add support for dollar quoting
[Greg Sabino Mullane]
(RT ticket #13608)
- Added $dbh->{pg_default_port} method
[Greg Sabino Mullane]
- Overhaul get_info data, add many more values
[Greg Sabino Mullane]
- Overhaul type_info data
[Greg Sabino Mullane]
(RT ticket #13806)
- Rewrite some of the quoting functions, reduce dependence
on libpq versions
[Greg Sabino Mullane]
- Rewrite and optimize the do() method. Should be much faster when called
without placeholders. Thanks to Tom Lane for suggesting this.
[Greg Sabino Mullane]
- Double check PQserverVersion return and use alternate method if it returns 0
(RT ticket #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
(RT ticket #13942)
[Greg Sabino Mullane]
- Fix pg_notifies() bug
[door at lcpi.ru]
(RT ticket #14232)
- Add pg_ping() method
[Greg Sabino Mullane]
- Make sure ping returns true, even if in failed transaction state (thanks to Bill Moseley)
[Greg Sabino Mullane]
- Fix COPY-related core dump
[Greg Sabino Mullane]
- Fix strncpy bug in quote.c
(RT ticket #14897)
[Jun Kuriyama]
- Fix error in is_high_bit_set()
(RT ticket #13406)
[Alexey Tourbin]
Version 1.43 (released June 23, 2005)
- Added README.dev file.
[Greg Sabino Mullane]
- Fix statement-name related core dump.
[Greg Sabino Mullane]
- Ensure state() returns an empty string, not 00000 on success.
[michael.bell at web.de of OpenCA]
[Greg Sabino Mullane]
(RT ticket #13237)
- Fix rare core dump when $sth still in scope after disconnect
[Greg Sabino Mullane]
- Enhancements to README.win32
[fenlisesi at gmail.com]
- Fix incorrect sprintf calls
[Jakub Jelinek]
(RT ticket #12204)
- Fix get_info(18) ("ODBCVERSION")
[szinger at lanl.gov]
[Greg Sabino Mullane]
(RT ticket #12968)
Version 1.42 (released May 21, 2005)
- Fix minor issues with copying and bytea quoting on older
servers. Fix some other memory leaks.
[Greg Sabino Mullane]
- Fix backslash parsing in statements
[felix.klee at inka.de]
[Greg Sabino Mullane]
(RT ticket #12870)
- Make rollback/commit reset copy state
[imb at rentrak.com]
[Greg Sabino Mullane]
(RT ticket #12866)
- Make sure lo_creat issues a BEGIN if necessary
[Greg Sabino Mullane]
- Fix incorrect behavior when AutoCommit switched on (thanks to Vivek Khera)
[Greg Sabino Mullane]
(RT ticket #12748)
- Have last_insert_id use set_err, not die (thanks to Alexandra Walford)
[Greg Sabino Mullane]
(RT ticket #12503)
- Fixed tests to correctly handle older DBI versions reporting
failures on last_insert_id()
[jpo at di.uminho.pt]
[Greg Sabino Mullane]
(RT ticket #12204)
- Re-enable REMARKS field on column_info (thanks to morni at cpan.org)
(RT ticket #12399)
[Greg Sabino Mullane]
- Many minor compiler optimizations and cleanups
[Greg Sabino Mullane]
- Fix two separate memory leaks in dbdimp.c
[hertzog at debian.org and richardg at eSentire.com]
- Change VARCHAROID to UNKNOWNOID, suggested by users on mailing list
[Greg Sabino Mullane]
Version 1.41 (released April 6, 2005)
- Make sure tests remove all temporary tables.
[Frank Bax]
[Greg Sabino Mullane]
- Preserve sqlstate if rolling back on deallocate, fix potential segfault.
[Stephen Clouse]
- Both commit and rollback now return true (thanks to ivan-dbdpg at 420.am)
[Greg Sabino Mullane]
(RT ticket #12004)
- Overhaul and update COPY support; use new protocol.
New dbh methods: pg_putline, pg_getline, pg_endcopy.
[Greg Sabino Mullane]
- Rewrote version detection code. Compiled version and target version are now
available via $dbh->{pg_lib_version} and $dbh->{pg_server_version}
[Greg Sabino Mullane]
- Set our default type_id to 0, not 1043 (VARCHAR) when possible.
Suggested by Abhijit Menon-Sen via David Wheeler.
[Greg Sabino Mullane]
- Add $dbh methods pg_savepoint(), pg_rollback_to(), and pg_release()
[Stephen Clouse]
[Greg Sabino Mullane]
Version 1.40 (released February 22, 2005)
- Raise required DBI version to 1.38
- Execute returns 0 (0E0) not -1 for successful DDL commands.
[Robert Treat]
[Greg Sabino Mullane]
- Change all string lengths to use STRLEN
[rink at stack.nl]
- Added $dbh->pg_server_trace($fh)
[Greg Sabino Mullane]
- Added $dbh->{pg_errorlevel}.
[Greg Sabino Mullane]
- Fix utf8 quote() support
[Dominic Mitchell <dom at semantico.com>]
- Added explicit support for types SQL_BOOLEAN, DATE, TIME, TIMESTAMP, and TIMESTAMPTZ.
Return correct values for DATEOID and TIMEOID.
[Greg Sabino Mullane]
- Added tablespace support for table_info and primary_key_info.
[Greg Sabino Mullane]
- Added new attributes to $dbh: pg_db, pg_user, pg_pass,
pg_host, pg_port, pg_options, pg_socket, pg_pid
[Greg Sabino Mullane]
- Minor fixes in quote.c, dbdimp.c, and types.h
[Christophe Martin: schplurtz at free.fr]
- Added support for SQLSTATE via $dbh->state and $sth->state
[Greg Sabino Mullane]
- Major overhaul of prepare/execute to handle new server-side
prepare system. See Pg.pm for details.
[Greg Sabino Mullane]
- Make the tests honor the DBD_SCHEMA variable instead of
assuming that the "public" schema is available.
[Rainer Weikusat]
- Cleanup of dbdimp.c: better error messages, ensure commit
is only called once after a transaction fails.
[Alexey Slynko]
- The primary_key() method returns empty list not undef if no match.
[Julian Mehnle]
- Added the pg_protocol database handle attribute
[Greg Sabino Mullane]
- Changed "noprefix" to pg_noprefix
Version 1.32 (released February 25, 2004)
- Bug fix for memory allocation problems on win systems
[Rafael Kitover <caelum at debian.org>]
- Rewrote the foreign_key_info() method to handle multi-column keys.
[Greg Sabino Mullane]
- Rewrote the primary_key_info() and primary_key() methods to cleanly handle
multi-column primary keys. Also added a "pg_onerow" attribute to allow
primary_key_info() to return a single row containing multiple-column information.
[Greg Sabino Mullane]
- Switched commit behavior from commit->execute->begin to begin->execute->commit
[xelah-junk at xelah.com]
[Greg Sabino Mullane]
- Made the _pg_use_catalog subroutine use {private_dbgpg}.
[Greg Sabino Mullane]
(RT ticket #4841)
- Changed strdup to safemalloc/strcpy in dbdimp.c
(RT ticket #4578)
- Made the data_sources method escape the database names as needed.
Added support for databases with spaces in their names.
[Greg Sabino Mullane]
- Added the "noprefix" attribute to prevent the tables() method
from prepending the schema name.
[Greg Sabino Mullane]
- Rewrote the testing suite. Many more tests are performed.
Servers with a low client_min_messages are handled correctly.
[Greg Sabino Mullane]
- Fixed bug causing '$\d' to be picked up as a placeholder.
[Greg Sabino Mullane]
(RT ticket #4799)
- The pg_notifies() method now catches and reports when PQconsumeInput fails.
[nmueller at cs.wisc.edu]
(RT ticket #4027)
- Enabled the "pg_bool_tf" database handle
[Greg Sabino Mullane]
- Added required fields to the type_info() method:
SQL_DATA_TYPE, SQL_DATETIME_SUB, and INTERVAL PRECISION
[Greg Sabino Mullane]
- Fixed bug where the table_attributes() method was incorrectly
removing the NULLABLE column.
[Greg Sabino Mullane]
- Fixed bug where case was not being preserved by the
foreign_key_info() method
[Greg Sabino Mullane]
- Calling fetch on any column that had a type that did not have an entry
in the type_info array would segfault DBD::Pg.
[Rudy Lippan]
(RT tickets #4818,4432)
- Duplicate rows bug with column_info() REMARKS has been fixed. However,
support for Postgres 7.1.x which worked briefly for 1.31 has now been
dropped for this feature.
[Mark Stosberg]
- Bumped required Perl version to 5.6.1 in Makefile.PL. We were already
already requiring 5.6.1 for Pg.pm since 1.31.
- Removed extra "return" statement in quote.c to make Solaris happy
(RT ticket #4419)
[Rudy Lippan]
- Changed get_info(29) to return (") instead of (\")
(RT ticket #4829)
[Greg Sabino Mullane]
Version 1.31 (released November 17, 2003)
- Calling $dbh->{TYPE} now returns SQL_TYPE_TIMESTAMP instead of 1114 for
timestamp columns. In 1.31_x {x| x<8} $sth->{TYPE} returned 0
[Joachim Hirche <Joachim.Hirche at cimconcepts.com>]
- Raised required versions to Perl 5.6.1 and DBI 1.35
- Fix syntax error related to pg_server_version
(RT tickets #2492,2755,3121)
- Cache multiple calls to pg_server_version.
- Notice messages generated by the database now use the perl
warning mechanism instead of going to stderr.
[Dominic Mitchell <dom at semantico.com>]
- The $dbh->prepare() method now rewrites the SQL statement into an internal form, stripping out
comments and whitespace, and if PostgreSQL > 7.3 it takes the stripped statement and passes
that to Postgres' PREPARE statement, then rewrites the statement
as 'EXECUTE "DBD::PG::cached_query n" ($1, $2, ... $n, $n+1)' for DBD::Pg::execute.
- Allows the use of :n and :foo bind params.
So (SELECT * FROM foo WHERE 1 = :this and 2 = :that) will now work.
- Complains on execute when unbound bind params are submitted (instead of defaulting to NULL)
- Switched over to use driver.xst.
- The pg_error() method removes newlines rather than truncating the message on the first \n.
- Fixed statement scan problem where the preparse
of "SELECT foo[3:33] from bar" was scanning :33 as a placeholder
- Moved the quoting of bind values out of execute() and into bind -- as there
is no need to requote the value every time execute is called.
- Fixed use of :veryverylongplaceholdername
- The quote() method is now in C and uses same code as bind_param.
- Quoting and dequoting now use libpq quoting functions where available
- The bind_param() method will convert from 1,0 to TRUE/FALSE when pg_type is PGBOOLOID.
- Fixed many heap buffer overruns.
- Added support for the get_info() method
[Greg Sabino Mullane]
- Added tests for POD validation
[Mark Stosberg]
- Several improvements to column_info, including:
- Fixed column_info so NULLABLE field shows correctly.
[kevin at sysexperts.com]
- Fixed column_info so REMARKS field works properly
[Mark Stosberbg]
- Various fixes to column_info: COLUMN_DEF, COLUMN_SIZE
- The pg_constraint column added to display column constraints
- The make test command is now more intelligent and will bail out early if
db connection fails.
[Greg Sabino Mullane]
Version 1.22 (released March 26, 2003)
- Win32 compile fix for snprintf
[Joe Spears]
- Fix memory allocation problem in bytea escaping
[Barrie Slaymaker]
- Add utf8 support
[Dominic Mitchell <dom at semantico.com>]
- Transform Perl arrays into PostgreSQL arrays
[Alexey Slynko]
- Fix for foreign_key_info()
[Keith Keller]
- Fix PG_TEXT parameter binding
- Doc cleanups
[Greg Sabino Mullane]
- Fix warning from func($table, 'table_attributes')
[Greg Sabino Mullane]
- Added support for schemas
[Greg Sabino Mullane]
- Fix binary to a bytea field conversion
[Chris Dunlop <chris at onthe.net.au>]
Version 1.21 (released January 12, 2003)
- System tables no longer returned by tables()
[Dave Rolsky]
- Fix table_attributes to handle removal of pg_relcheck in 7.3
[Ian Barwick <barwick at gmx.net>]
- Properly reset transaction status after failed transaction when
autocommit is off. Properly report transaction failure message.
[Kai <kai at xs4all.nl>]
- New pg_bool_tf database handle that when set to true booleans are
returned as 't'/'f' rather than 1/0.
Version 1.20 (released November 27, 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.
[Garth Webb]
- Added LISTEN/NOTIFY functionality.
[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]
- Deprecated 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]
Version 1.15 (released April 27, 2002)
- Add default at end of switch statement for pg_type attrib, along with tests.
[Jeffrey W. Baker]
Version 1.12 (released April 9, 2002)
- Applied patch from Thomas A. Lowery concerning metadata in table_info and so forth.
[Jeffrey W. Baker]
Version 1.10 (released March 6, 2002)
- Applied patch from David Wheeler to simplify and speed up quoting.
[Jeffrey W. Baker]
- Added tests for quoting changes above.
- Added tests for placeholder parsing in quoted strings.
Version 1.01 (released June 27, 2001)
- Fixed core dump when trying to use a BYTEA value with a byte outside 0..127
[Alex Pilosov <alex at pilosoft.com>]
Version 1.00 (released May 27, 2001)
- Fetching all records now resets Active flag as it should.
Version 0.99 (released May 24, 2001)
- Fix the segmentation fault in pg_error.
Version 0.98 (released April 25, 2001)
- Bug fix for core-dump after any failed function call.
- Applied patch from Alex Pilosov <alex at pilosoft.com> which adds support for the datatype bytea
Version 0.97 (released April 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 at pc.xs4all.nl>, which removed the special handling
of a backslash when used for octal presentation. Now a backslash always will be escaped.
Version 0.96 (released April 09, 2001)
- Remove memory-leak in ping function
[Doug Perham <dperham at wgate.com>]
- Correct the recognition of primary keys in table_attributes().
[Brian Powell <brian at nicklebys.com>]
- Fix a segmentation fault in DBD::pg::blob_read() when reading LOBs that required perl to
reallocate space for the variable holding the scalar value
[David D. Kilzer <ddkilzer at lubricants-oil.com>]
- Updated test.pl to create a test blob larger than 256 bytes (now 128 Kbytes)
- Fix a segmentation fault when inserting large amounts of text.
[Tom Lane]
- Removes the newlines from the error messages and which quotes date placeholders.
[Peter Haworth <pmh at edison.ioppublishing.com>]
Version 0.95 (released July 10, 2000)
- Add Win32 port
[Bob Kline <bkline at rksystems.com>]
Version 0.94 (released July 07, 2000)
- Fix a memory-leak with failed connections.
[Rudy Lippan <almighty at randomc.com>]
- Fix a bug with escaping a backslash except for octal presentation
[Hein Roehrig <hein at acm.org>]
Fix a segmentation fault when all bound parameters are NULL
[Francis J. Lacoste <francis.lacoste at iNsu.COM]
- Adapt test.pl to avoid warnings with postgresql-7.0
- Added support for 'COPY FROM STDIN' and 'COPY TO STDOUT'
- Enhance the table_attributes subroutine
[Mark Stosberg <mark at summersault.com>]
Version 0.93 (released September 29, 1999)
- It is required now to set the environment variables POSTGRES_INCLUDE
and POSTGRES_LIB for compiling the module.
- Add Win32 port
[Bob Kline <bkline at rksystems.com>]
- Support for all large-object functions via the func interface.
- Fixed bug with placeholders and casts
[spotted by bymschout at gkg.net]
- Replaced the method attributes by the method table_attributes,
[Scott Williams <scott at james.com>]
- Fix type definitions for type_info_all().
[spotted by "carlos" <emarcet at intramed.net.ar>]
- Now the Pg-specific quote() method also evaluates the data-type parameter.
Version 0.92 (released June 16, 1999)
- Increase BUFSIZE from 1024 to 32768 in order to improve I/O performance.
[Philip Warner <pjw at rhyme.com.au>]
- Fix in Makefile.PL for $POSTGRES_HOME not defined
[spotted by Mark Dalphin mdalphin at amgen.com]
- Fix for data-type datetime in type_info_all
[spotted by Alan Grover <awgrover at iconnect-inc.com>]
- Fix for escaped 's
[spotted by Hankin <hankin at consultco.com>]
- Removed 'large objects' related tests from test.pl
Version 0.91 (released February 14, 1999)
- Removed restriction for commercial use in copyright
- Corrected DATA_TYPE in type_info_all()
Version 0.90 (released January 15, 1998)
- Discard parameter authtype from connect string
- Remove work-around for bug in the large object interface of postgresql
Version 0.89 (released November 05, 1998)
- Fix problem with quoting Null in bind variables.
[Jan Iven <j.iven at rz.uni-sb.de>]
Version 0.88 (released October 10, 1998)
- Fixed blob_read
- Suppressed warning when testing DBI::errstr
Version 0.87 (released September 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
- Documentation and tests added for blob_read
- Added support for attr parameter in bind_param()
Version 0.86 (released August 21, 1998)
- Added /usr/lib/ to search path for libpq.
- Added ChopBlanks, patch from Victor Krasinsky <victor at rdovira.lviv.ua>
- Changed test.pl to test multiple database handles
Version 0.85 (released July 19, 1998)
- Non-printable characters in parameters will not be converted to '.'.
They are passed unchanged to the database.
Version 0.84 (released July 18, 1998)
- Check for \xxx presentation before escaping backslash in parameters.
[Max Cohan max at cohan.biz]
- 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.
Version 0.83 (released July 10, 1998)
- Bug fix for core dump when using traces together with undef
[Max Cohan max at cohan.biz]
Version 0.82 (released June 20, 1998)
- Corrected include path in Makefile.PL .
[Matthew Lenz <matthew at nocturnal.org>]
- Added 'use strict;' to test.pl
Version 0.81 (released June 13, 1998)
- 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.
[Rolf Grossmann <grossman at securitas.net>]
- Change ping method to use libpq-interface.
Version 0.80 (released 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.
Version 0.73 (released June 03, 1998)
- Changed include directives in Makefile.PL from archlib to installarchlib and from
sitearch to installsitearch
[Tony.Curtis at vcpc.univie.ac.at]
Quote method also doubles backslash.
[Junio Hamano <junio at twinsun.com>]
Version 0.72 (released April 20, 1998)
- Fix bug with queries containing the cast operator.
[Michael J Schout <mschout at gkg.net>]
- Fix memory leak
[Irving Reid <irving at tor.securecomputing.com>]
Version 0.71 (released April 04, 1998)
- Fix problem with InactiveDestroy
[Irving Reid <irving at tor.securecomputing.com>]
Version 0.70 (released March 28, 1998)
- Linking again with the shared version of libpq due to problems on several operating systems.
Version 0.69 (released March 6, 1998)
- Expanded the search path for include files
- Module is now linked with static libpq.a
Version 0.68 (released March 3, 1998)
- Return to UNIX domain sockets in test-scripts
Version 0.67 (released February 21, 1998)
- Remove part of Driver.xst due to compile error on some systems.
Version 0.66 (released February 19, 1998)
- Remove defines in Pg.h so that it compiles also with postgresql-6.2.1
- Changed ping method: set RaiseError=0
Version 0.65 (released 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.
Version 0.64 (released February 01, 1998)
- Changed syntax of data_source (ODBC-conformant): 'dbi:Pg:dbname=dbname;host=host;port=port'
- 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
Version 0.63 (released October 05, 1997)
- Adapted to PostgreSQL-6.2: $sth->rows as well as $sth->execute and $sth->do return the
number of affected rows even for non-Select statements. 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!
Version 0.62 (released August 26, 1997)
- Added blobs/README
Version 0.61 (released August 23, 1997)
- Adapted to DBI-0.89/Driver.xst
- Added support for blob_read
Version 0.52 (released August 15, 1997)
- Added support for literal $sth->{'TYPE'}, pg_type.pl / pg_type.pm.
Version 0.51 (released August 12, 1997)
- Changed attributes to be DBI conformant: OID_STATUS
to pg_oid_status, CMD_STATUS to pg_cmd_status
Version 0.5 (released August 05, 1997)
- Support for user authentication
- Support for bind_columns
- Added $dbh->tables
Version 0.4 (released June 24, 1997)
- Adapted to DBI-0.84: new syntax for DBI->connect.
Method execute returns 0E0 -> n for SELECT statement, -1 for
non SELECT statement, -2 on error
New attribute $sth->{'OID_STATUS'}
New attribute $sth->{'CMD_STATUS'}
Version 0.3 (released April 24, 1997)
- Bug fix release, ( still alpha ! )
Version 0.2 (released March 13, 1997)
- Complete rewrite, ( still alpha ! )
Version 0.1 (released February 15, 1997)
- Creation, ( totally pre-alpha ! )
|