|
|
Choosing A Webhost: |
ERROR: column "ctid" does not exist: msg#00034db.postgresql.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@xxxxxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: MS Access error "could not connect to remote socket", Richard Huxton |
|---|---|
| Next by Date: | Re: Access 2002 and psqlodbc 7.03.02, David P. Lurie |
| Previous by Thread: | ODBC int2 Paremeters to PostgreSQL functions, Gary Doades |
| Next by Thread: | Re: ERROR: column "ctid" does not exist, Jeff Eckermann |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |