Re: [ODBC] psqlodbc - SysTAble Prefixes issue - Mailing list pgsql-odbc

From Tsunakawa, Takayuki
Subject Re: [ODBC] psqlodbc - SysTAble Prefixes issue
Date
Msg-id 0A3221C70F24FB45833433255569204D1F66C96F@G01JPEXMBYT05
Whole thread Raw
In response to Re: psqlodbc - SysTAble Prefixes issue  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-odbc
From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Heikki Linnakangas
> On 11/15/2016 10:21 AM, brajmohan saxena wrote:
> > I feel this is introduces to consider some default
> > *ExtraSysTablePrefixes *I am not sure in which case it will be used.
> > As for as i understand there will be no User specific system table
> > considered in Postgres prefixing with "dd_". So there is no point to
> > keep this extra psqlODBC config parameter in future.
> 
> The driver itself certainly doesn't need it for anything. I can see it being
> useful for forks or extensions, that introduce "system" tables, with a
> different prefix. Takayuki-san mentioned EnterpriseDB, and I know Greenplum
> has some tables with the gp_* prefix, for which this might be useful. I
> don't think either of those actually uses this feature, but it might come
> handy.
> 
> So, I removed the "dd_*" from the default, but left the option in place.

+1

Regards
Takayuki Tsunakawa


pgsql-odbc by date:

Previous
From: Andres Ramirez
Date:
Subject: Re: [ODBC] weird problem when running a sql stmt
Next
From: ldani
Date:
Subject: Re: [ODBC] helpful article