Win32 ODBC 6.5 driver and PostgreSQL 7.0 Foreign Key s
От | Panon, Paul-Andre |
---|---|
Тема | Win32 ODBC 6.5 driver and PostgreSQL 7.0 Foreign Key s |
Дата | |
Msg-id | D1D937EF0E0FD311ADC800600815C3030262B5BB@SVVAN330 обсуждение исходный текст |
Список | pgsql-interfaces |
Hello, I am trying to use the win32 ODBC driver to allow ErWin to connect to a PostgresSQL 7.0 for database creation/synchronization. The PostgreSQL driver seems to be choking on the first SQLGetInfo call from Erwin. Here follows the result from connection logging: conn=46333984, SQLDriverConnect(out)='DSN=HoldingTank;DATABASE=holdingtank;SERVER=exhibitx. area51.sierrasys.com;PORT=5432;UID=...;PWD=...;READONLY=0;PROTOCOL=6.4;FAKEO IDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=' CONN ERROR: func=SQLGetInfo, desc='', errnum=209, errmsg='Unrecognized key passed to SQLGetInfo.' ------------------------------------------------------------ henv=46139368, conn=46333984,status=1, num_stmts=16 sock=46139384, stmts=46139424, lobj_type=-999 ---------------- SocketInfo ------------------------------- socket=228, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=46209888,buffer_out=46205784 buffer_filled_in=33, buffer_filled_out=0, buffer_read_in=32 conn=46333984, SQLDisconnect Unfortunately, the key (fInfoType) is not being logged so I'm not sure what Erwin is asking. After Erwin gets this error message, it gives up on the driver and uses it at the simplest level it can with no support for foreign or primary keys. My next step seems to be to modify the code to log the fInfoType and try to fix the problem. Before I go that far however, has the win32 ODBC driver (6.50) been updated to correctly understand and report PostgreSQL 7.0 Foreign Key contraints generated during either a CREATE TABLE or an ALTER TABLE...ADD CONSTRAINT statement? If it hasn't, it's probably not worth my time to track down the first problem. Thank you, Paul-Andre Panon
В списке pgsql-interfaces по дате отправления: