You might want to submit this to the main bug/wish list.
This seems like something sane and probably fairly easy to support
in the server itself. It seems like there is nothing implicitly wrong
with the "table"."field" syntax and the server itself should understand
it.
Max
On Fri, Oct 08, 2004 at 11:11:29PM +0200, Giulio Orsero wrote:
> On Fri, 8 Oct 2004 21:45:26 +0100, "Dave Page" <dpage@vale-housing.co.uk>
> wrote:
>
> >I've just uploaded a new snapshot to
> >ftp://ftp.postgresql.org/pub/odbc/versions/snapshots/ (it should hit the
> >mirrors within 24 hours). This version of the driver is a minor update
> >with a fix to the string sizing code in SQLGetInfo, and removal of the
> >need for tables to be in the search path or public schema for them to be
> >returned by SQLTables.
>
> Since you are in a development phase, can you tell me if the following
> feature is in your roadmap?
>
> Add a check box "Quote every table/field identifier" yes/no, default: no
>
> This would solve one of the greatest problems interacting with psql server:
> - On the server you define MyTable.MyField
> - Excel/MSQuery receives MyTable.MyField names through ODBC
> - Excel/MSQuery builds a query with MyTable.MyField (not
> "MyTable"."MyField")
> - psql server lowercase to mytable.myfield and errors out
>
> I read all the explanations about how this behavior is right/good, but users
> just want it to work.
>
> Thanks
>
> --
> giulioo@pobox.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend