postgres ODBC problem with view
Reizinger Zoltán <[email protected]> Sat, 09 Oct 2010 13:55:28 +0200
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi all, See View problem in forum post: http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=34843&p=159735#p159735 I can reproduce it with any OOo, 3.2.1, OOO330m9, DEV300m89, on win7 32bit, with psqlODBC0804, and postgersql 9.0. I created a view in psql, I can access it via JDBC driver, but get error with ODBC: The data content could not be loaded. SQL Status: 42703 Error code: 7 ERROR: column "ctid" does not exist; Error while executing the query The SQL command leading to this error is: SELECT * FROM "openoffice"."public"."Test_view" I found similar problem in issue tracker, with different error message: http://qa.openoffice.org/issues/show_bug.cgi?id=10229 I think it is similar problem, and we can not solve it OOo, it is a driver problem? Thanks, Zoltan