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