[Sqlrelay-discussion] Talking to SQLRelay via psycopg2 and drop-in replacement library for PostgreSQL

[Frank J. <fr...@jo...>]

Hello! I am trying to talk to SQLRelay from python via psycopg2 and
the drop-in replacement library for PostgreSQL. this is what I get at
the python end:

--- snip ---
frank@host09:~$ python
Python 2.5.2 (r252:60911, May 28 2008, 19:19:25)
[GCC 4.2.4 (Debian 4.2.4-1)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg2
>>> conn = psycopg2.connect("user='routeruser' host='localhost' password='routerpassword' port='9000' dbname='foo'")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg2.OperationalError: can't fetch client_encoding
--- snap ---

and the SQLRelay debug log says:

--- snip ---
getting authentication...

listener-based authentication succeeded

incrementing session count...

waiting for exclusive access...

done waiting for exclusive access...

1

waiting for the scaler...

done waiting for the scaler...

done incrementing session count

getting a connection...

acquiring exclusive shm access

done acquiring exclusive shm access

waiting for an available connection

done waiting for an available connection

handoff=pass

signalling connection that we've read

done signalling connection that we've read

releasing exclusive shm access

done releasing exclusive shm access

done getting a connection

passing descriptor...

done passing descriptor

decrementing busy listeners

done decrementing busy listeners
--- snap ---

The lib appears to support:

PQclientEncoding	                yes
PQsetClientEncoding	yes

And it seems to look alright from the debug log - but python barfs.

Any ideas how to fix this?

Cheers,

Frank