Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 295869F9F7B for ; Wed, 6 Dec 2006 08:38:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 10397-05 for ; Wed, 6 Dec 2006 08:37:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id A0D129F9F66 for ; Wed, 6 Dec 2006 08:37:57 -0400 (AST) Received: (qmail 29660 invoked by uid 540); 6 Dec 2006 12:28:33 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(153.19.179.26):. Processed in 0.077236 secs); 06 Dec 2006 12:28:33 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 6 Dec 2006 12:28:32 -0000 Message-ID: <4576B8FF.7070809@informatyka.gdansk.pl> Date: Wed, 06 Dec 2006 13:35:11 +0100 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Adam Radlowski CC: pgsql-admin@postgresql.org Subject: Re: JDBC driver does not accept good md5 passwords References: <4575537E.6080002@informatyka.gdansk.pl> In-Reply-To: <4575537E.6080002@informatyka.gdansk.pl> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/39 X-Sequence-Number: 23831 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 > >