From: | David Hedberg <david(dot)hedberg(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: [PATCH] Return the correct column names in SQLTables |
Date: | 2014-09-22 20:40:04 |
Message-ID: | CAB5ZCnQMaXJ_fSXxC62OJMNBZVgX73hB1jY+pz3Hafju6MzHiw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Any comments on this one?
On Sat, Aug 9, 2014 at 6:29 PM, David Hedberg <david(dot)hedberg(at)gmail(dot)com> wrote:
> As noted in bug #1007689, the column names returned from SQLTables
> differs between ODBCv2 and ODBCv3. This patch was needed to be able to
> list the tables when trying to import data in Excel 2010/PowerPivot.
>
> A somewhat unrelated question:
> There is one more "fix" needed to get the import of data in PowerPivot
> working properly, and that is because PowerPivot insists on creating
> the query with mssql-style quotes. (select [schema].[table].* instead
> of select "schema"."table".* ..).
>
> I have not managed to find any way of making it issue the query with
> the correct form of quoting. Unless anyone reading this happens to
> know of a way, would you accept a patch that adds an option to the
> driver that makes it translate []-style quoting to ""-style quoting?
>
> --
> David Hedberg
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-09-23 09:46:40 | Re: [PATCH] Return the correct column names in SQLTables |
Previous Message | chava | 2014-09-22 16:54:39 | Re: 126 Error Connecting With psqlODBC 32 bit |