Skip site navigation (1) Skip section navigation (2)

Re: Issues when using schema names with odbc

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: michael(dot)28(dot)smith(at)bt(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org, stephen(dot)hindmarch(at)bt(dot)com
Subject: Re: Issues when using schema names with odbc
Date: 2010-11-20 02:33:01
Message-ID: 4CE7335D.7080407@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
(2010/11/19 1:22), michael(dot)28(dot)smith(at)bt(dot)com wrote:
> I think there is an issue with the following version of postgresql-odbc
> where I am unable to use schema names.
>
> Using “isql ” “help table_name” returns information about the column
> names but “help schema.table_name returns nothing.

ODBC doesn't handle schema_name.table_name type format.
For example the syntax of SQLColumns() is as follows.

	SQLRETURN SQLColumns(
		SQLHSTMT       StatementHandle,
		SQLCHAR *      CatalogName,
		SQLSMALLINT    NameLength1,
		SQLCHAR *      SchemaName,
		SQLSMALLINT    NameLength2,
		SQLCHAR *      TableName,
		SQLSMALLINT    NameLength3,
		SQLCHAR *      ColumnName,
		SQLSMALLINT    NameLength4);

regards,
Hiroshi Inoue

> This assumes the identical tables are in public.table_name and
> schema.table_name
>
> I actually come across this when using asterisk realtime – I was about
> to raise this as an asterisk issue and came across this – which suggests
> it is actually an underlying odbc issue.
>
> https://issues.asterisk.org/view.php?id=15963
>
> Has this been seen before..?
>
> Many Thanks
>
> Mike
>
> rpm -qa |grep odbc
>
> postgresql-odbc-08.01.0200-3.1
>
> rpm -qa |grep postgres
>
> postgresql-server-8.1.11-1.el5_1.1
>
> postgresql-libs-8.1.11-1.el5_1.1
>
> postgresql-8.1.11-1.el5_1.1
>
> postgresql-libs-8.1.11-1.el5_1.1
>
> postgresql-odbc-08.01.0200-3.1
>
> Asterisk 1.6.2.12

In response to

Responses

pgsql-odbc by date

Next:From: Taizo ITODate: 2010-11-24 04:26:24
Subject: Problem when fetching data of BIT column.
Previous:From: noreplyDate: 2010-11-20 02:00:51
Subject: [ psqlodbc-Bugs-1010945 ] uninitialised value in QR_Constructor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group