Re: psqlodbc - SysTAble Prefixes issue

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: 'Heikki Linnakangas' <hlinnaka(at)iki(dot)fi>, brajmohan saxena <braj(dot)saxena(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlodbc - SysTAble Prefixes issue
Date: 2016-12-26 01:58:08
Message-ID: 0A3221C70F24FB45833433255569204D1F66C96F@G01JPEXMBYT05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message ldani 2016-12-26 23:54:03 Re: helpful article
Previous Message Andres Ramirez 2016-12-15 06:01:03 Re: weird problem when running a sql stmt