Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group