> 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