From: | <stephen(dot)hindmarch(at)bt(dot)com> |
---|---|
To: | <inoue(at)tpf(dot)co(dot)jp> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: SQLColumns does not allow schema name |
Date: | 2009-09-25 13:08:37 |
Message-ID: | 6218342DD4A57C41A67FC276D91E625C09CB85E8@E03MVY2-UKDY.domain1.systemhost.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
> Sent: 25 September 2009 13:08
> To: Hindmarch,SJ,Stephen,DMM R
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] SQLColumns does not allow schema name
>
> stephen(dot)hindmarch(at)bt(dot)com wrote:
> > 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.
>
> The declaration of SQLColumns() is the following.
>
> SQLRETURN SQL_API
> SQLColumns(HSTMT StatementHandle,
> SQLCHAR *szCatalogName, SQLSMALLINT cbCatalogName,
> SQLCHAR *szSchemaName, SQLSMALLINT cbSchemaName,
> SQLCHAR *szTableName, SQLSMALLINT cbTableName,
> SQLCHAR *szColumnName, SQLSMALLINT cbColumnName);
>
> We specify the schema name as the 4th parameter together with
> the 5th length parameter.
>
Thank you. I understand this now. The developer of the original
application has acknowledged that it his bug and he had not used the API
correctly.
> > 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.
> >
So how can I describe a table in isql if it is part of a schema?
Steve Hindmarch
BT Design
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Parkinson | 2009-09-28 17:09:29 | Error installing ODBC driver |
Previous Message | Hiroshi Inoue | 2009-09-25 12:08:07 | Re: SQLColumns does not allow schema name |