creating a table with ODBC
От | Bogus User |
---|---|
Тема | creating a table with ODBC |
Дата | |
Msg-id | 19990502163224.82999.qmail@hotmail.com обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: