I am trying to access PostgreSQL from Openoffice using iodbc on Linux
When trying to look at any views I get ERROR: column "ctid" does not exist.
Any suggestions?
My .odbc.ini file is:
[ODBC Data Sources]
PostgreSQL = PostgreSQL native driver
[PostgreSQL]
Description = Production Database
Driver = /usr/local/lib/psqlodbc.so
Trace = No
TraceFile = /tmp/odbc.log
Database = data
Server = 192.168.2.254
UserName = ggibson
Password =
Port = 5432
Protocol = 6.4
ReadOnly = Yes
RowVersioning = Yes
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings = SET SEARCH_PATH TO public
[ODBC]
;Tracing = 1
;TraceFile = /tmp/odbctrace.log
;Debugging = 1
;DebugFile = /tmp/odbcdebug.log
--
George Gibson
J.B. Stamping, Inc.
7413 Associate Ave.
Cleveland, OH 44144
216.631.0013 216.631.1327 fax
gtgibson@jbstamping.com