From: | <michael(dot)28(dot)smith(at)bt(dot)com> |
---|---|
To: | <inoue(at)tpf(dot)co(dot)jp> |
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-30 14:38:44 |
Message-ID: | 806CB309AA19EE4F8F30EB5DF3E372B33B5E636428@EMV61-UKRD.domain1.systemhost.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
[btoc(at)rdl10090app15 ~]$ rpm -qa |grep odbc
postgresql-odbc-08.01.0200-3.1
Are you using a later version ? is so which one and any ideas what version it has been fixed in ?
Cheers
Mike Smith
Voice & Multimedia Platform | BT Innovate & Design
Tel: +44 (0) 20 7876 8005
ClickDial Me
-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
Sent: 30 November 2010 14:17
To: Smith,M,Michael,DLW C
Cc: pgsql-odbc(at)postgresql(dot)org; Hindmarch,SJ,Stephen,DLW R
Subject: Re: [ODBC] Issues when using schema names with odbc
(2010/11/29 23:51), michael(dot)28(dot)smith(at)bt(dot)com wrote:
> Used a little test app to verify this and I get different results,
>
> Assuming create schema test_schema;
>
> create table public.test(
> row1 int,
> row2 text);
>
> create table test_schema.test(
> row_t_1 int,
> row_t_2 text);
>
> grant usage on schema test_schema to public;
> grant select on public.test to public;
> grant select on test_schema.test to public;
>
> insert into public.test values (1,'public schema');
> insert into test_schema.test values (2,'test schema');
>
> The test app shows the following results....:
>
> [root(at)winston scripts]# ./sqltest
> SQLColumns Connection Test
> Handles Allocated
>
> Getting columns from test_schema.test
> No data!
>
> Getting all rows from test_schema.test
> Row 0:1=2;2=test schema;
>
> Getting columns from public.test
> No data!
>
> Getting all rows from public.test
> Row 0:1=1;2=public schema;
>
> Getting columns from (null).test
> Column 0: row
> Column 1: row
> Column 2: row
> Column 3: row
>
> Getting all rows from (null).test
> Row 0:1=1;2=public schema;
Which version of psqlodbc driver are you using?
Here I get the following results.
Getting columns from test_schema.test
Column 0: row_t_1
Column 1: row_t_2
Getting all rows from test_schema.test
Row 0:1=2;2=test schema;
Getting columns from public.test
Column 0: row1
Column 1: row2
Getting all rows from public.test
Row 0:1=1;2=public schema;
Getting columns from (null).test
Column 0: row1
Column 1: row2
Getting all rows from (null).test
Row 0:1=1;2=public schema;
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Little, Douglas | 2010-12-01 09:22:14 | commlog destination in Solaris |
Previous Message | Hiroshi Inoue | 2010-11-30 14:17:30 | Re: Issues when using schema names with odbc |