Re: case sensitivity on table & column names / workaround? - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: case sensitivity on table & column names / workaround?
Date
Msg-id 20060616081845.GB25182@soptik.pzkagis.cz
Whole thread Raw
In response to case sensitivity on table & column names / workaround?  (postgresql.org@tgice.com)
Responses Re: case sensitivity on table & column names / workaround?  (postgresql.org@tgice.com)
List pgsql-odbc
> 1) Change *all* of my present and future PG code for this database (that
> touches the MSSQL tables, at least) to always surround table & column
> names with double quotes.
>
> 2) Figure out a way to get MSSQL or the PG ODBC driver to drop or ignore
> those double quotes on the SQL coming from the replication process.
>
> 3) Figure out a way for PG to modify its behavior and allow
> non-double-quoted identifiers to match ones that were originally double
> quoted.

What about updateable views? It could be the way for replication and name
changing. I'm not sure it's only an idea.

Regards,

Luf

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: Memory Leak ?
Next
From: zhaoxin
Date:
Subject: Re: Memory Leak ?