PGAPI_Columns() does not follow search path

From: "Ken Faiczak" <kfaiczak(at)sandvine(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: PGAPI_Columns() does not follow search path
Date: 2005-03-29 16:21:17
Message-ID: 71837C040963F748B9B94E123A289678415144@mailserver.sandvine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Trying to get the columns though odbc
we have a namespace 'user' so when we log in as that user
and the searchpath is $user,public

when queried for columns from a table that exists in public
the postgres-unixodbc driver specifically does a select current_schema()
and uses that to restrict the queries to the namespace 'user'
(all other SQL queries don't do this and allow the full search_path())

if I do the same query without the namespace restriction the columns are
returned
as expected.

Is there a particular reason why this query is limited to the namespace.

I notice there is a specific workaround if the 'specified name space' ==
'name'
then it will try public as well but only if current == public
but since there is a current namespace == the user this code doesn't
fire

This looks like someone trying to solve somewhat the same problem,
would it not be better to just remove the namespace restriction
and let it follow the search_path.

Ken Faiczak

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Simeó Reig 2005-03-29 16:23:42 Re: Driver maintenance continuation
Previous Message Joshua D. Drake 2005-03-29 16:04:00 Re: Driver maintenance continuation