Hi,
I managed to connect a PostgreSQL test database
to OpenOffice via Pg-JDBC. OO reports 'Driver
successfully loaded' and 'Connection successfully
established' and displays the tables, but I cannot
add or delete rows or edit field contents. Perhaps
it is just the matter of an additional connection
parameter that invokes the appropriate class inside
the driver? Something like 'modify=true' or 'rw=true'?
Funny, adding or deleting columns DOES work and
everything else seems to be alright too.
Many thanks in advance for reply and help.
Kind regards, J. Brastrup
P.S. Versions are:
postgresql-8.1_8.1.4-2
openoffice.org_2.0.3-7
postgresql-8.1-407.jdbc3.jar
sun-java5-jre_1.5.0-08-1
unixodbc_2.2.11-13
running on Debian Linux
with kernel 2.6.11