ERROR: column "ctid" does not exist

From: "George T(dot) Gibson" <gtgibson(at)jbstamping(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ERROR: column "ctid" does not exist
Date: 2004-03-12 22:43:49
Message-ID: 35772.192.168.2.250.1079131429.squirrel@192.168.2.254
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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(at)jbstamping(dot)com

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message David P. Lurie 2004-03-12 22:56:00 Re: Access 2002 and psqlodbc 7.03.02
Previous Message Jeff Eckermann 2004-03-12 14:49:35 Re: Very Puzzled ---