The following bug has been logged online:
Bug reference: 3134
Logged by: Geoff Russell
Email address: geoffrey.russell@gmail.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