Your message dated Thu, 09 Oct 2014 13:21:06 +0000 with message-id <[email protected]> and subject line Bug#760564: fixed in postgresql-9.4 9.4~beta3-1 has caused the Debian Bug report #760564, regarding regexp_matches behavior change 9.1 -> 9.3 to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 760564: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=760564 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: postgresql-9.4 Version: 9.4~beta2-1+b1 Severity: normal Dear Maintainer, With postgres 9.3 i have select regexp_matches('gestion/football/ligue-des-champions', '^((?!d{4}-d{1,2}-d{1,2})[^/]+?)(?:/((?!d{4}-d{1,2}-d{1,2})[^/]+?))(?:/((?!d{4}-d{1,2}-d{1,2})[^/]+?))?$', 'g'); regexp_matches ---------------------------------------- {gestion,football,ligue-des-champions} With postgres 9.4 it returns 0 row. Removing the greedy quantifier at the end [^/]+? -> [^/]+ makes it return a result again. Regards, Jérémy. -- System Information: Debian Release: jessie/sid APT prefers unstable APT policy: (670, 'unstable'), (650, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 3.16-trunk-amd64 (SMP w/4 CPU cores) Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages postgresql-9.4 depends on: ii libc6 2.19-10 ii libgssapi-krb5-2 1.12.1+dfsg-9 ii libldap-2.4-2 2.4.39-1.1+b1 ii libpam0g 1.1.8-3.1 ii libpq5 9.4~beta2-1+b1 ii libssl1.0.0 1.0.1i-2 ii libxml2 2.9.1+dfsg1-4 ii locales 2.19-10 ii postgresql-client-9.4 9.4~beta2-1+b1 ii postgresql-common 160 ii ssl-cert 1.0.34 ii tzdata 2014g-1 postgresql-9.4 recommends no packages. Versions of packages postgresql-9.4 suggests: pn locales-all <none> pn oidentd | ident-server <none> -- no debconf information
--- End Message ---
--- Begin Message ---Source: postgresql-9.4 Source-Version: 9.4~beta3-1 We believe that the bug you reported is fixed in the latest version of postgresql-9.4, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Christoph Berg <[email protected]> (supplier of updated postgresql-9.4 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Tue, 07 Oct 2014 20:39:57 +0200 Source: postgresql-9.4 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-9.4 postgresql-9.4-dbg postgresql-client-9.4 postgresql-server-dev-9.4 postgresql-doc-9.4 postgresql-contrib-9.4 postgresql-plperl-9.4 postgresql-plpython-9.4 postgresql-plpython3-9.4 postgresql-pltcl-9.4 Architecture: source amd64 all Version: 9.4~beta3-1 Distribution: unstable Urgency: medium Maintainer: Debian PostgreSQL Maintainers <[email protected]> Changed-By: Christoph Berg <[email protected]> Description: libecpg-compat3 - older version of run-time library for ECPG programs libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) libecpg6 - run-time library for ECPG programs libpgtypes3 - shared library libpgtypes for PostgreSQL 9.4 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql-9.4 - object-relational SQL database, version 9.4 server postgresql-9.4-dbg - debug symbols for postgresql-9.4 postgresql-client-9.4 - front-end programs for PostgreSQL 9.4 postgresql-contrib-9.4 - additional facilities for PostgreSQL postgresql-doc-9.4 - documentation for the PostgreSQL database management system postgresql-plperl-9.4 - PL/Perl procedural language for PostgreSQL 9.4 postgresql-plpython-9.4 - PL/Python procedural language for PostgreSQL 9.4 postgresql-plpython3-9.4 - PL/Python 3 procedural language for PostgreSQL 9.4 postgresql-pltcl-9.4 - PL/Tcl procedural language for PostgreSQL 9.4 postgresql-server-dev-9.4 - development files for PostgreSQL 9.4 server-side programming Closes: 757520 760564 762389 763098 Changes: postgresql-9.4 (9.4~beta3-1) unstable; urgency=medium . * New upstream beta version. + Catalog version number changed, older 9.4 clusters need to be dumped and reloaded. + Regexp regression fixed. (Closes: #760564) + CACHE_LINE_SIZE definition renamed to mitigate conflict on *BSD. (Closes: #763098) . [ Martin Pitt ] * Add missing logrotate test dependency. . [ Christoph Berg ] * Set Multi-Arch: foreign in postgresql-client-9.4 and postgresql-doc-9.4. (Closes: #757520; do it even on non-multiarch dists, it doesn't hurt.) * Fix postgresql_fdw in description, spotted by Andrei Popescu, thanks! (Closes: #762389) Checksums-Sha1: 16673b021de92c43a3a564294b64399508793a2e 3522 postgresql-9.4_9.4~beta3-1.dsc e6af179dfea2f2d05e416fce9ee30cfff9beeff6 17355677 postgresql-9.4_9.4~beta3.orig.tar.bz2 bfd68005f7ff3274daa67c42be4a1baefdffed4b 18824 postgresql-9.4_9.4~beta3-1.debian.tar.xz 98d7a149fb42bbbaf4cc772261ea269f6ed7ec0a 159574 libpq-dev_9.4~beta3-1_amd64.deb f355459c8ae045c2080b36db82c9d726979a0f6a 119368 libpq5_9.4~beta3-1_amd64.deb ca90e22dfebabcc1441eb6accd09bf9c79774977 76318 libecpg6_9.4~beta3-1_amd64.deb 48a627569d8535f38245ccb7b0c7de13a0383ee0 213970 libecpg-dev_9.4~beta3-1_amd64.deb 9ebb7b7d381f744fa3a0dcc94fded58e5e341790 12344 libecpg-compat3_9.4~beta3-1_amd64.deb 952e5e370790c0e5a36fb4519b2ab302676df504 34344 libpgtypes3_9.4~beta3-1_amd64.deb b9136bc7305438a27cd1f4739daafc2942913991 3687774 postgresql-9.4_9.4~beta3-1_amd64.deb e1d0b1d6086dabd1a9460268dd2212219cd6c100 12016982 postgresql-9.4-dbg_9.4~beta3-1_amd64.deb 42e2574d628d6dd233806475fad9993cbdce5422 1078620 postgresql-client-9.4_9.4~beta3-1_amd64.deb 3871fd113dfece981c7e52ce50cd9e19e8c79d59 630914 postgresql-server-dev-9.4_9.4~beta3-1_amd64.deb abc2cf3b3614d5454547d7a328ca28236bfeed60 1813652 postgresql-doc-9.4_9.4~beta3-1_all.deb 24a41da0c614f27eb74baa9d7e80e17ecda410cf 446270 postgresql-contrib-9.4_9.4~beta3-1_amd64.deb fcfbffb14cf15d8df2f89a3e6270edb1dcd2f748 52354 postgresql-plperl-9.4_9.4~beta3-1_amd64.deb 9be4123dcdfb8e1db8901066beb8f6187a67f308 41288 postgresql-plpython-9.4_9.4~beta3-1_amd64.deb fb74a283c7bda7556ab2ae4ac48ce7df21074f5c 41022 postgresql-plpython3-9.4_9.4~beta3-1_amd64.deb ff056beefcf040a3cd669c84390c78b3fa7763dd 26970 postgresql-pltcl-9.4_9.4~beta3-1_amd64.deb Checksums-Sha256: 3ba1ccdd9aa0b07a75f3b1571466e5614465e13cdd80b83ece962db129509fe9 3522 postgresql-9.4_9.4~beta3-1.dsc 5ad1d86a5b9a70d5c153dd862b306a930c6cf67fb4a3f00813eef19fabe6aa5d 17355677 postgresql-9.4_9.4~beta3.orig.tar.bz2 3ee4f2b7a1eb4f9a02ff7015a72f20b07b4ec49aaa51fb0c617157b55e76950b 18824 postgresql-9.4_9.4~beta3-1.debian.tar.xz d72b5d98133588d795fb9abd652ce4c3f4691f6e648b5e15a73aeb1c532cf2f9 159574 libpq-dev_9.4~beta3-1_amd64.deb 958d68ad04911d8af90a0c2a3fe2643372e8cf06e4805cbd5e13244d49e25001 119368 libpq5_9.4~beta3-1_amd64.deb 54f3ed03d6a686cac954444bfc77581ae2ca1dcb4f3696cd0b894db01b7f1324 76318 libecpg6_9.4~beta3-1_amd64.deb 80385e3239c1928b54b1c6ee17884e3fe61155d376884062974e745c115f101f 213970 libecpg-dev_9.4~beta3-1_amd64.deb 990f23c4c547482b4dc046ae7689a4e2b48465b56da6c6a832e8ee7b0cbe1633 12344 libecpg-compat3_9.4~beta3-1_amd64.deb f6ec8e33aa40b76fae43e080a1e58f891586ed0c04e709c845b3a6b6dd0d1d04 34344 libpgtypes3_9.4~beta3-1_amd64.deb c1810dfe84e58717949e9f6db3f4a700ec50d6e445b360629ccf6239ad5d45b9 3687774 postgresql-9.4_9.4~beta3-1_amd64.deb b6db45d6ecd4fbb1e610a0aa5e54fb4b08786636d891e3e3ff67665b6f45b6cb 12016982 postgresql-9.4-dbg_9.4~beta3-1_amd64.deb 52c159ab06645c1e529d20e216e0b3e73c1f5b3a0eb24de4067900951868faea 1078620 postgresql-client-9.4_9.4~beta3-1_amd64.deb 4cf2756fe7bef02b6c523effda6a629141fc4515ad969a8552d8251c3ec25fe4 630914 postgresql-server-dev-9.4_9.4~beta3-1_amd64.deb ce2160b84df3be37f438198e27560508d279625d492e6b7739f6b7c69f2bc453 1813652 postgresql-doc-9.4_9.4~beta3-1_all.deb 60db7d4d88cc948e08da52c04fca417dcc36056eb4ea81befff297bdbb2c1a28 446270 postgresql-contrib-9.4_9.4~beta3-1_amd64.deb 984ed33c128b735950039cf810746b3f3dbbf94c46fb4ac791203597d531c2fe 52354 postgresql-plperl-9.4_9.4~beta3-1_amd64.deb ca2b5549fa6100cbeaea5e2b4820ab9b48208b4ad7422c589916277c565543f2 41288 postgresql-plpython-9.4_9.4~beta3-1_amd64.deb 44cb2ae27ab839f6d95a34f99a3e555cb55d8e507c63e1764baf1cdaf22db994 41022 postgresql-plpython3-9.4_9.4~beta3-1_amd64.deb 8b76cb3fc1b9c40587515e8206a9c40f5f0c8acfb5e0b5e648276643b5888e9d 26970 postgresql-pltcl-9.4_9.4~beta3-1_amd64.deb Files: 627a10fea3b23f48034cd21ac15e8b92 3522 database optional postgresql-9.4_9.4~beta3-1.dsc b9bcab84971b456b8460b4ed468037b9 17355677 database optional postgresql-9.4_9.4~beta3.orig.tar.bz2 e6fb6081330f860a7ccc8be9318fb935 18824 database optional postgresql-9.4_9.4~beta3-1.debian.tar.xz 28d8c5cf999d67ebc5d7c2aacf2b8639 159574 libdevel optional libpq-dev_9.4~beta3-1_amd64.deb 4b48e94f597694632ad03af6d7bdd4a4 119368 libs optional libpq5_9.4~beta3-1_amd64.deb 1d8214cbb13613caeee1d57e5868e129 76318 libs optional libecpg6_9.4~beta3-1_amd64.deb 25f028476bd6daa967f60ceb14a906a1 213970 libdevel optional libecpg-dev_9.4~beta3-1_amd64.deb 9d176938cd7aaa2a39909b092e6aedee 12344 libs optional libecpg-compat3_9.4~beta3-1_amd64.deb 28dd80d3a0ceeb4966a8bb57a7ceeb6a 34344 libs optional libpgtypes3_9.4~beta3-1_amd64.deb f5f9055403e093351a3ae8c84e5243ee 3687774 database optional postgresql-9.4_9.4~beta3-1_amd64.deb 1f22153a2d4190038e0d2b6ab68b4f10 12016982 debug extra postgresql-9.4-dbg_9.4~beta3-1_amd64.deb 8c9a98733155ea3fe1851fad11eee314 1078620 database optional postgresql-client-9.4_9.4~beta3-1_amd64.deb 1dd8b5f366f45a92c01a8eaa91f3d742 630914 libdevel optional postgresql-server-dev-9.4_9.4~beta3-1_amd64.deb e9db1469fe5933559b2c8467da281def 1813652 doc optional postgresql-doc-9.4_9.4~beta3-1_all.deb 63cb6c85ac210366d77d85925ba5e5de 446270 database optional postgresql-contrib-9.4_9.4~beta3-1_amd64.deb fb39bc6a487164ebc04825bb9d769d87 52354 database optional postgresql-plperl-9.4_9.4~beta3-1_amd64.deb 1247c7b382e3847d6048aedbd3accd50 41288 database optional postgresql-plpython-9.4_9.4~beta3-1_amd64.deb 9bb1cbbb8b47de07f3670facc68d9c2d 41022 database optional postgresql-plpython3-9.4_9.4~beta3-1_amd64.deb 79e4102c5349f4d92619e6b5f01f71bf 26970 database optional postgresql-pltcl-9.4_9.4~beta3-1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCAAGBQJUNipdAAoJENFO8V2v4RNHuDEQAManut4UMmu8dwXufjj4nmnc bSSORD/QqwdPVGlbGYudAh7CukcoC7jQcrt87NLl2XVEg44DQGmgP6Yjeq7xB7dE 6UJThafKqkB9b4xuG3VnoevJagwyBebTh5z8E3mkypnmm8C9FPY4Jxc1FEV4wD0w MRmnzOSdvGe/qUwyckZpfcGAgv7M4lVTnDfUSG/8+yaGRKzdyWEpZTxrA3QqG+sd 9VDU/3C9jMIVbdVGH1mK/SMkXA3dCtfa7a71iplnW7M/vqH2JxtVT1actj6cfKkD Eq3OPlnra6Tqr1kMXZa9OSJ1Rpr3uC0W+egeTSBGNRG4kUkQO3x3XWEQRT0bojBp 035qh1l0VuM9u/UTDCAKPSMiBOCqm1maIqWMrveGvM9ph8+V9QLHiTCq0DwC1Jk9 ldh6dF5cuA6iThN62bX7LL5usX9j184zGk6iLBlcLul+TXddbpa4bKRnQTDtRaOZ qNoe7DOEMu/z/3AsMhOVdvHdch2/7cGQ6DlY6OF4EOqgngd6bzNkonV9y5+iLjYh eOknrlWCbA3vYGMF6wumLvmPCkpw0iVWu6/fNZx01Jnp/W6rkPI3RVXaYqS9nJei 6Ye3t/whYkcJvNW9tMakUygvf3RbzON+Oc0mAEOz0/bxqjk2KZCzHR9jKi5+RU7W HpkGo1RW6mrntc1GyaFH =Wr9x -----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________ Pkg-postgresql-public mailing list [email protected] http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
