pgsql-odbc bug querying VIEWs
От | Mahlon Stacy |
---|---|
Тема | pgsql-odbc bug querying VIEWs |
Дата | |
Msg-id | 4B08D99CFA03D04EAF34E1A28C4D159C2E949F@pocono.mayo.edu обсуждение исходный текст |
Список | pgsql-odbc |
I have created a postgres VIEW for a user into a set of tables, and want to provide the user access from ODBC on Windows. The query into the VIEW fails, however, with the following message: Microsoft Query: Error: No such attribute as bdstatview.oid I am not requesting an explicit query on the OID. I am only requesting retrieval of the columns listed in the view. Queries into the other (real) tables in the same database work fine. pgsql-odbc version 7.02.00.05 Postgresql version 7.3.2-1 Windows OS XP Pro DB Server OS Red Hat Linux 8.0 I have tried restricting the query to a small subset of the VIEW columns, same result. I have also turned on Fake OIDs in the ODBC config and re-run the query, same results. I cannot access the pgsql-odbc server this morning to see if there is a later version of the driver. -Mahlon ------------------------------------------------------------- Mahlon Stacy Internet: mcs@mayo.edu Mayo Foundation (507) 284-4558 Medical Science Bldg 1-43 FAX (507) 284-1632 Rochester, MN 55905 -------------------------------------------------------------
В списке pgsql-odbc по дате отправления: