odbc can't edit postgresql database ??

Hi all,

I have postgresql 8.1, unixodbc and openoffice on a Ubuntu 6.06.1
machine and can connect to my postgresql
databases fine --- but can't edit data, only view. pgadmin3 also only
allows viewing
but not editing.

I can insert records with psql.

To make matters worse, I have another machine with (as far as I can see!) the
same software and which works perfectly...???

The admin config files are below.

Cheers,
Geoff Russell

---------------------------- /etc/odbc.ini owned by root 644
[testdb]
Description = testdb
Driver = PostgreSQL
Trace = No
TraceFile = /tmp/psqlodbc.log
Database = testdb
Servername = blackie
UserName = geoff
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =

-------------------------------- /etc/odbcinst.ini owned by root 644
[PostgreSQL]
Description = PostgreSQL ODBC driver
Driver = /usr/lib/odbc/psqlodbc.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1

-------------------------------------- change to pg_hba.conf
#host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 trust