The problem is resolved. OpenOffice doesn't edit tables without primary
key with any driver (I've tried JDBC,native OpenOffice, ODBC). But - the
primary key can't be ignored, when it is made on OID.
Greetings
Adam
Adam Radlowski wrote:
I'm using very often OpenOffice to administrate databases (It has
options, wchich are not present in pgadmin3).
If I use JDBC connection and server don't requiers md5 passwords, I
can edit and administrate the databases/tables via OpenOffice and
JDBC. I can only read the tables. When server requiers md5 passwords I
can't. Of course, I want to have possibility to edit tables via
OpenOffice :-). Has anybody any idea, how to do this ?
I'm using "postgresql-8.2-504.jdbc3.jar" and "jre1.5.0_06". Server
8.0.7 compiled/using on FC3 or binary installation 8.0.6 on Win2003.
I've tried older *.jar version with this same result. OpenOffice 2.0.3
or 1.4.1.
Greetings
Adam
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
