[Pkg-postgresql-public] postgresql-9.1

[Yavuz Selim Komur]

On Wednesday, September 11, 2013 10:43:17 Christoph Berg wrote:
> Re: Yavuz Selim Komur 2013-09-11 <1511277.MlFUrz8KWe at yoda>
> 
> > i wrote a program using python3-postgesql (py-postgresql) this package is
> > not work with postgresql-9.3
> > 
> > please update python3-postgresql 1.1.0  version and i will drop/migrate my
> > 9.1 database to 9.3 database
> 
> Hi Yavuz,
> 
> did you give python3-psycopg2 a try? That's the DB driver people
> usually use.
> 
> For py-postgresql, it might help to file a bug in the Debian BTS to
> request an update.
> 
> Do you have a short test program that shows where py-postgresql is
> incompatible with PostgreSQL 9.3?
> 
> Christoph
$ dpkg -l | awk '/postgresql/{print $2 " " $3}'
postgresql 9.3+149
postgresql-9.3 9.3.0-2
postgresql-client 9.3+149
postgresql-client-9.3 9.3.0-2
postgresql-client-common 149
postgresql-common 149
postgresql-contrib 9.3+149
postgresql-contrib-9.3 9.3.0-2
postgresql-plpython3-9.3 9.3.0-2
python3-postgresql 1.0.2-1+b3



---------------  traceback --- ------------

    sess_info['channel'] = postgresql.open(self.uri)
  File "/usr/lib/python3/dist-packages/postgresql/__init__.py", line 88, in 
open
    c.connect()
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 2559, 
in connect
    sd = self.sys.startup_data()
  File "/usr/lib/python3/dist-packages/postgresql/lib/__init__.py", line 398, 
in __getattr__
    bs = BoundSymbol(sym, db)
  File "/usr/lib/python3/dist-packages/postgresql/lib/__init__.py", line 288, 
in __init__
    ps = database.prepare(symbol)
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 2352, 
in prepare
    ps._fini()
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 1460, 
in _fini
    self.database._pq_complete()
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 2599, 
in _pq_complete
    self.typio.raise_error(x.error_message, cause = getattr(x, 'exception', 
None))
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 507, in 
raise_error
    self.raise_server_error(error_message, **kw)
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 498, in 
raise_server_error
    raise server_error
postgresql.exceptions.UndefinedColumnError: column "procpid" does not exist
  CODE: 42703
  LOCATION: File 'parse_relation.c', line 2628, in errorMissingColumn from 
SERVER
  POSITION: 147
STATEMENT: [parsing]
  LINE:
    FROM pg_catalog.pg_stat_activity WHERE procpid = 
pg_catalog.pg_backend_pid()
                                           ^ [line 6, character 40]
  statement_id: py:0x7f581b50aa10
  string:
    SYMBOL: startup_data
      source:
        SELECT
         pg_catalog.version()::text AS version,
         backend_start::text,
         client_addr::text,
         client_port::int
        FROM pg_catalog.pg_stat_activity WHERE procpid = 
pg_catalog.pg_backend_pid()
        UNION ALL SELECT
         pg_catalog.version()::text AS version,
         NULL::text AS backend_start,
         NULL::text AS client_addr,
         NULL::int AS client_port
        LIMIT 1;
    LIBRARY: /usr/share/python3-postgresql/libsys.sql
CONNECTION: [idle]
CONNECTOR: [Host] pq://xxxx:***@localhost:5432/xxxx
  category: None
DRIVER: postgresql.driver.pq3.Driver