SQLColumns does not allow schema name

From: <stephen(dot)hindmarch(at)bt(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: SQLColumns does not allow schema name
Date: 2009-09-24 14:40:40
Message-ID: 6218342DD4A57C41A67FC276D91E625C09CB7E1E@E03MVY2-UKDY.domain1.systemhost.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I came across this problem while trying to debug another application
that uses unix ODBC to access a Postgresql database. The application
uses the SQLColumns function to describe tables. When the table is in
the public schema and the table name is given just as "tname" then the
columns are returned. When the table is given as "public.tname" then the
request returns empty.

You can reproduce this in isql. If you connect to the database and do
"help tname" you get the columns listed. If you try "help public.tname"
no rows are returned. Selects return the same results either way, so it
is just the description functions that appears broken.

I am using unixODBC-2.2.12-9, Postgresql-odbc-08.03.0200-1 and
Postgresql-server-8.3.8-1.

Steve Hindmarch
BT Design

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrus 2009-09-25 07:33:27 Re: 08.04.0100: Couldn't load libpq library
Previous Message Nico Callewaert 2009-09-24 13:16:41 Delphi connection ?