From: | Michalis Kabrianis <mk(at)interzone(dot)gr> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | ODBC Schema problems - Postgres 7.3 |
Date: | 2003-07-08 06:45:50 |
Message-ID: | 20030708094550.165b67a4.mk@interzone.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Gaiarin | 2003-07-08 13:48:17 | This thing drive me crazy! ;( |
Previous Message | Sam Williams | 2003-07-05 07:38:30 | problems with pgsql-odbc on unix |