Hi Dave, I just started using the PG odbc driver with access and I noticed that the only schema that would show up was public, even though I had added several of my own that are visible. The only way I could get it to work was with the searchpath, and that does not seem to me how it should work. The search path is a marginal solution because if you add new schemas you have to update every single DSN with the new search path, this can be alleviated some by using a file DSN but it is still a huge PITA. I was using the stable version from Nov 2003
Thanks,
Tony Caduto Senior Programmer/Analyst M&I Trust and Investment Management
"Dave Page" <dpage@vale-housing.co.uk> Sent by: pgsql-odbc-owner@postgresql.org
10/04/2004 04:15 PM
To
<pgsql-odbc@postgresql.org>
cc
Subject
[ODBC] Schema support
There have been a couple of reports that psqlODBC does not support schemas. This is not strictly true, it actually has full support for schemas, however, SQLTables honours the search_path variable on the server and hides objects in schemas that are not visible.
I'm not convinced this is the correct behaviour - SQLTables should show everything afaict, unless a parameter is passed to it to filter the output. The micro-patch below corrects this - however I'm not 100% sure there won't be any side effects I haven't thought of. I'd appreciate it if I could get some feedback.