Pg7.1-beta and CVS psqlodbc.dll: No views
От | Joel Burton |
---|---|
Тема | Pg7.1-beta and CVS psqlodbc.dll: No views |
Дата | |
Msg-id | 3A1BEB71.28895.44245B38@localhost обсуждение исходный текст |
Ответы |
Re: Pg7.1-beta and CVS psqlodbc.dll: No views
|
Список | pgsql-interfaces |
I'm using 7.1beta (gotta love those views with unions, distincts, etc.!). As has been noted earlier, the 6.50 ODBC driver (current stable version) does not work w/7.1beta. So, I compiled last night's CVS sources to create a new psqlodbc.dll. This works *great* -- for tables. I don't see any of the views (I did w/Pg7.0.2 and the stable 7.50 ODBC driver). I can see through the ODBC trace that the driver gets the tables with select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and usesysid = relowner order by relname (relkind='r' is for normal tables, 'v' is for views). Is this an intended change? Something I did? Something I/someone else can fix? I do read this list, but always appreciate a 'cc' so I don't miss any reponses. TIA. BTW, the improvements to the ODBC driver also include a fix so that referential integrity errors are reported properly as errors. No more "looks like it worked, but really didn't". Thanks to everyone who fixed this! -- Joel Burton, Director of Information Systems -*- jburton@scw.org Support Center of Washington (www.scw.org)
В списке pgsql-interfaces по дате отправления: