Hi,
I'm using PostgreSQL-v6.5beta1 on Debian Linux.
I have a simple ODBC program that I'm trying to run. It seems to connect to
the database ok, but when I try to create a table I get a return code of -1
on the client side and a message saying
"pq_recvbuf: unexpected EOF on client connection"
on the server side. The sql query I'm using works fine inside of psql.
I'm using iodbc version 2.50.2 and I compiled the pgsql ODBC driver at the
same time as the server.
The debug output from the server is:
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 5
/usr/local/pgsql/bin/postmaster: BackendStartup: environ dump:
-----------------------------------------
HZ=100
HOSTNAME=htr-118
MANPATH=:/usr/local/pgsql/man
PS1=\$
USER=postgres
MACHTYPE=i486-pc-linux-gnu
MAIL=/var/spool/mail/postgres
LANG=C
LOGNAME=postgres
SHLVL=1
SHELL=/bin/sh
PGLIB=/usr/local/pgsql/lib
HOSTTYPE=i486
OSTYPE=linux-gnu
TERM=xterm-debian
HOME=/home/postgres
PGDATA=/usr/local/pgsql/data
PATH=/bin:/usr/bin:/usr/local/pgsql/bin
_=/usr/local/pgsql/bin/postmaster
POSTPORT=5432
POSTID=2147483647
PG_USER=postgres
IPC_KEY=5432000
-----------------------------------------
/usr/local/pgsql/bin/postmaster: BackendStartup: pid 18045 user postgres db
postgres socket 5
/usr/local/pgsql/bin/postmaster child[18045]: starting with
(/usr/local/pgsql/bin/postgres, -p, -d3, -P5, -v131072, postgres, )
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
debug info:
User = postgres
RemoteHost = 127.0.0.1
RemotePort = 6370
DatabaseName = postgres
Verbose = 3
Noversion = f
timings = f
dates = Normal
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: set DateStyle to 'ISO'
ProcessUtility: set DateStyle to 'ISO'
CommitTransactionCommand
StartTransactionCommand
query: set geqo to 'OFF'
ProcessUtility: set geqo to 'OFF'
CommitTransactionCommand
StartTransactionCommand
query: set ksqo to 'ON'
ProcessUtility: set ksqo to 'ON'
CommitTransactionCommand
StartTransactionCommand
query: select oid from pg_type where typname='lo'
ProcessQuery
CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 18045 exited with status 0
Thanks,
Rich
_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com