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

BUG #3134: Can't edit with odbc

From: "Geoff Russell" <geoffrey(dot)russell(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3134: Can't edit with odbc
Date: 2007-03-10 10:17:21
Message-ID: 200703101017.l2AAHLAr021716@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3134
Logged by:          Geoff Russell
Email address:      geoffrey(dot)russell(at)gmail(dot)com
PostgreSQL version: 8.1
Operating system:   Ubuntu 6.10
Description:        Can't edit with odbc
Details: 

odbc-postgresql 1:08.01.0200-2
postgresql 8.1.8-0ubuntu6.10 
unixodbc 2.2.11-13 
openoffice.org2-base 2.0.4-0ubuntu4

Open database in openoffice using odbc, but
can only get read only access.

Have another machine with 6.06.1 which works fine.

Prior to installing 6.10, the current machine had
6.06 on it and also had this problem, so I upgraded
to 6.10, installed all the latest patches, and
still am getting the problems.

odbc.ini:

[Testdb]
Description         = Testdb 
Driver              = PostgreSQL
Trace               = No
TraceFile           = /tmp/psqlodbc.log
Database            = testdb
Servername          = blackie
UserName            = geoff
Password            = 
Port                = 5432
Protocol            = 7.0
ReadOnly            = No 
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =


odbcinst.ini:
[PostgreSQL]
Description     = PostgreSQL ODBC driver (ANSI version)
Driver          = /usr/lib/odbc/psqlodbca.so
Setup           = /usr/lib/odbc/libodbcpsqlS.so
Debug           = 0
CommLog         = 1


I can edit the table with psql.

Many thanks,

Geoff Russell

pgsql-bugs by date

Next:From: Michael FuhrDate: 2007-03-10 15:56:05
Subject: Re: alter column type (from timestamp to date) violates not null
Previous:From: Duilio Andre Chavez CuariteDate: 2007-03-09 23:14:34
Subject: BUG #3132: I don't access to DB

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