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

Re: case sensitivity on table & column names / workaround?

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: postgresql(dot)org(at)tgice(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: case sensitivity on table & column names / workaround?
Date: 2006-06-16 08:18:45
Message-ID: 20060616081845.GB25182@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-odbc by date

Next:From: zhaoxinDate: 2006-06-16 09:03:14
Subject: Re: Memory Leak ?
Previous:From: Ludek FinstrleDate: 2006-06-16 08:08:05
Subject: Re: Memory Leak ?

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