ODBC Schema problems - Postgres 7.3

Hi all

I'm developing a multi-user application for Postgresql with wxWindows and ODBC

My .odbc.ini file is:

[ODBC Data Sources]
Media = Media SA Development Database
[Media]
Database = mediaerp
Servername = localhost
ReadOnly = 0
Driver = /server/postgresql/lib/psqlodbc.so
Port = 5432
Protocol = 7.2
ConnSettings = SET SEARCH_PATH to public,admin;

The psqlodbc.so file is from psqlodbc-07.03.0100 downloaded from gborg.postgresql.org and the database is 7.3. (also tried Protocol = 7.3, although I think it doesn't make any difference).

There is a schema on the user admin (and as admin I have GRANTED select on all tables/sequences to users)
I connect as user "mkab" and I see in Postgres server.log the command
SET SEARCH_PATH to public,admin
But when I try to select something from a table named "doy" of the admin schema, I see that the DB is looking for the table "doy" in mkab's schema. Then it does a "select" on the table named "doy" and returns nothing.
Is that normal, am I doing something wrong or is there a bug in odbc library? Everything works as expected when I connect as "admin".

Thanks in advance

Part of the server log to follow
2003-07-07 20:49:16 LOG: connection received: host=127.0.0.1 port=33426
2003-07-07 20:49:16 LOG: connection authorized: user=mkab database=mediaerp
2003-07-07 20:49:17 LOG: query: select version()
2003-07-07 20:49:17 LOG: duration: 0.001410 sec
2003-07-07 20:49:17 LOG: query: set DateStyle to 'ISO'
2003-07-07 20:49:17 LOG: duration: 0.000236 sec
2003-07-07 20:49:17 LOG: query: set geqo to 'OFF'
2003-07-07 20:49:17 LOG: duration: 0.000077 sec
2003-07-07 20:49:17 LOG: query: SET SEARCH_PATH to public,admin
2003-07-07 20:49:17 LOG: duration: 0.000146 sec
2003-07-07 20:49:17 LOG: query: select oid from pg_type where typname='lo'
2003-07-07 20:49:17 LOG: duration: 0.003538 sec
2003-07-07 20:49:17 LOG: query: select pg_client_encoding()
2003-07-07 20:49:17 LOG: duration: 0.000497 sec
2003-07-07 20:49:19 LOG: query: BEGIN;select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and nspname like 'mkab' and relname like 'doy' and relname !~ '^pg_|^dd_' and pg_namespace.oid = relnamespace order by nspname, relname
2003-07-07 20:49:19 LOG: duration: 0.006647 sec
2003-07-07 20:49:19 LOG: query: SELECT code,name FROM doy
2003-07-07 20:49:19 LOG: duration: 0.001148 sec

--
Michalis Kabrianis
mk(at)interzone(dot)gr