| From: | David Hedberg <david(dot)hedberg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | [PATCH] Return the correct column names in SQLTables |
| Date: | 2014-08-09 16:29:23 |
| Message-ID: | CAB5ZCnSrt-b0SEBCU8d5O6TL7rFxo1zWFWDj86fGzhg0N4tZog@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Support-ODBCv3-column-names-in-SQLTables.patch | text/x-patch | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-08-10 13:18:05 | Re: Removing support for < 7.4 servers |
| Previous Message | Anna Gershnik | 2014-08-08 17:47:40 | openSSL 1.0.1i released |