Re: Issues when using schema names with odbc

(2010/11/29 23:51), michael.28.smith@bt.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@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