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
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 |