-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
On 25/09/13 11:41, Christoph Berg wrote:
> Re: Daniel Pocock 2013-09-25 <5242a851.1080...@pocock.com.au>
>> Apart from the procpid issue, are there likely to be many other
>> painful issues with migrating apps?
>
> standard_conforming_strings defaults to 'on' in 9.2+, just like
> the pg_stat_activity was already changed in 9.2.
>
> Given that 9.2 has been around for a year (plus the beta period
> before that), there's little excuse for applications not to have
> been fixed yet.
>
>> Given that concurrent versions are supported on Debian, is there
>> any hope of keeping 9.1 as an option for people who want to build
>> Debian systems that are more in sync with commercial
>> distributions?
>
> You could use wheezy, it has 9.1. (Or apt.postgresql.org as Martin
> said.)
>
Ok, thanks for all that feedback
upstream has SQL code in the client GUI and also in their database
creation code, which is a separate source package
upstream also provides individual tarballs with database upgrade code
to help people migrate between versions. Patching all of those would
be a real pain.
Access to the procpid stuff is via stored procs, not just in regular
C++ code where we could put conditional logic for the database version.
I only found one reference to procpid in the C++ source, but the SQL
schema creation code has a few things, I also see similarly named
symbols like soheadlock_procpid, do those have to change too?
$ grep procpid postbooks_empty-4.0.2.sql
PERFORM pg_try_advisory_lock(datid::integer, procpid)
WHERE(procpid = pg_backend_pid());
PERFORM pg_advisory_unlock(datid::integer, procpid)
WHERE(procpid = pg_backend_pid());
AND (procpid = pg_backend_pid()));
AND (soheadlock_procpid=pg_backend_pid()) );
227 desktop userOnline Copyright (c) 1999-2012 by OpenMFG LLC, d/b/a
xTuple. See www.xtuple.com/CPAL for the full text of the software
license. -- Group: desktop\n-- Name: userOnline\n-- Notes: \n--
Copyright (c) 1999-2012 by OpenMFG LLC, d/b/a xTuple.\n-- See
www.xtuple.com/CPAL for the full text of the software
license.\n\nSELECT usr_id, usr_username, usr_propername, usr_email,\n
min(backend_start) AS client_start, max(query_start) AS
query_start,\n sum(CASE WHEN(database IS NULL) THEN 0 ELSE 1
END) AS cnt_internal,\n sum(CASE WHEN(database IS NULL) THEN 1
ELSE 0 END) AS cnt_external,\n client_addr, '0' AS
cnt_internal_xttotalrole, '0' AS cnt_external_xttotalrole\n FROM
pg_stat_activity\n JOIN usr ON (usr_id=usesysid)\n LEFT OUTER JOIN
pg_locks ON (database=datid AND classid=datid AND objid=procpid AND
objsubid=2)\n WHERE(datname=current_database())\n GROUP BY usr_id,
usr_username, usr_propername, usr_email,\n client_addr,
cnt_internal_xttotalrole, cnt_external_xttotalrole;\n \N \N 0
The full SQL is here:
http://anonscm.debian.org/gitweb/?p=collab-maint/postbooks-schema-empty.git;a=tree
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/
iQIcBAEBCAAGBQJSQ0elAAoJEOm1uwJp1aqDL7oP/0POMypCNoYRQlTBYR5gRS/g
SpMhva4Ah7Z1ZDrX+eRzH7bUcgkkDgY3OlKMjxRP8Z/HQNwCZBdQl4ms2q4kMwx4
ant4WFyQFLSZkpk9+2c+jv1x4MzAt2Uyboa0F/pMXZLBEpN3fGuXvF4JFd2yhIGM
Qq9BfjjvZuPezhRo8jA8vRV0QfsW9eIOViPI/DL/BhUN+RVyF/ne02vIqXii/fDG
SUzNGY8T0PzKUs2sL81CKTRwMdUk9t8mI13D2uHEj3/jbI6x/PYmB0dBl5trC08l
SDWzWt5Oi5x8dBsEgtMUxydAG9SdlXIr498963tXnrcNbGypSHJ2mUj2j25kqkxG
6iVLTfiTJZyvk+Yz8ddoUkLjYE85rG+DvfqP99s/83/dyvAtCZdc1dPMhtKpbQHP
7ZI4zUzS/XOPLWBHPdXGWyB3FioOuVn98GElbfmqg9QpQ9cgIW6EVYGywhqJ/Jlx
bDPTyATtfQv49jJ6itwwZU61jwNzwrACu4caouEf5LMfnzPKLJaaBa9TwAyWooIT
HlxwNr93g2/0BIp/FT7KZPhN+c+PzMKfMnjHz17HOXl70VKzdTUBDNAg+82w+2ru
iY1HVvszh1zuaZuGQB3NxmOlyRylpPJlVt9aYj5l46PjK+EAXVJjvOzxCtDCVa0Q
goUT9LMTTIJ2guN4OU3v
=5zHU
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
