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

Re: Schema support

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Schema support
Date: 2004-10-08 09:45:13
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E43069FA@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
Patch applied.
 

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: 04 October 2004 22:16
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Schema support
> 
> There have been a couple of reports that psqlODBC does not 
> support schemas. This is not strictly true, it actually has 
> full support for schemas, however, SQLTables honours the 
> search_path variable on the server and hides objects in 
> schemas that are not visible.
> 
> I'm not convinced this is the correct behaviour - SQLTables 
> should show everything afaict, unless a parameter is passed 
> to it to filter the output. The micro-patch below corrects 
> this - however I'm not 100% sure there won't be any side 
> effects I haven't thought of. I'd appreciate it if I could 
> get some feedback.
> 
> Thanks Dave.
> 
> Index: info.c
> ===================================================================
> RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/info.c,v
> retrieving revision 1.114
> diff -u -r1.114 info.c
> --- info.c	26 Jul 2004 14:10:37 -0000	1.114
> +++ info.c	4 Oct 2004 20:59:31 -0000
> @@ -1284,7 +1284,6 @@
>  	if (conn->schema_support)
>  	{
>  		schema_strcat1(tables_query, " and nspname %s 
> '%.*s'", likeeq, szSchemaName, cbSchemaName, szTableName, 
> cbTableName, conn);
> -		strcat(tables_query, " and
> pg_catalog.pg_table_is_visible(c.oid)");
>  	}
>  	else
>  		my_strcat1(tables_query, " and usename %s 
> '%.*s'", likeeq, szSchemaName, cbSchemaName);
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

pgsql-odbc by date

Next:From: Dave PageDate: 2004-10-08 19:50:30
Subject: Re: Schema support problems with latest snapshot
Previous:From: Jeff EckermannDate: 2004-10-07 21:01:22
Subject: Re: update rules + views + odbc problems

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