creating a table with ODBC - Mailing list pgsql-general

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