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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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