[pkg-xtuple-maintainers] Bug#724305: postbooks: Does not work on postgres 9.3

[Daniel Pocock]

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
> (42703)
>
> procpid was renamed to pid in 9.2 and is not coming back[1].
>
> 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?