[pkg-xtuple-maintainers] Bug#724305: Bug#724305: postbooks: Does not work on postgres 9.3
fsateler at debian.org
Mon Sep 23 15:50:41 UTC 2013
On Mon, Sep 23, 2013 at 12:16 PM, Daniel Pocock <daniel at pocock.com.au> wrote:
> On 23/09/13 17:07, Felipe Sateler wrote:
>> Package: postbooks
>> Version: 4.0.2-3
>> Severity: important
>> Tags: upstream
>> Postbooks relies on functionality removed in 9.2. After setting up the
>> quickstart schema, trying to login yields:
>> A System Error occurred at login2.cpp::344:
>> ERROR: column "procpid" does not exist
>> LINE 1: SELECT pg_try_advisory_lock(datid::integer, procpid)
>> QUERY: SELECT pg_try_advisory_lock(datid::integer, procpid)
>> FROM pg_stat_activity
>> WHERE(procpid = pg_backend_pid())
>> CONTEXT: PL/pgSQL function login(boolean) line 10 at PERFORM
>> procpid was renamed to pid in 9.2 and is not coming back.
>> Filing as important because 9.1 is still installable (thus possibly not
>> RC), but as the default postgres version is 9.3 this should really be
>> fixed soon.
> Thanks for this feedback
> I will check the PostgreSQL 9.3 plans from upstream. They also have a
> new version (4.2) in beta, that could go on a branch in the Debian
> postbooks VCS (and maybe experimental) for testing with PostgreSQL 9.3.
> Did you do any further testing with 9.3 to see if further problems exist?
No, I was trying to give postbook a test-drive based on your recent
blog post. I've stopped after this problem.
BTW, the instructions appear to create a superuser called admin, is it
More information about the pkg-xtuple-maintainers