Received: from smtp.tiscalinet.it (fornax.tiscalinet.it [195.130.224.67])
	by hub.org (8.9.3/8.9.3) with SMTP id SAA58274
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 21 Oct 1999 18:25:04 -0400 (EDT) (envelope-from Lmib@yahoo.com)
Received: (qmail 28758 invoked by uid 7770); 21 Oct 1999 20:39:00 -0000
Received: from rm2-895.tiscalinet.it (HELO lmib) (abel@212.123.85.133)
	by fornax.tiscalinet.it with SMTP; 21 Oct 1999 20:39:00 -0000
From: "Fabio.di.Fabio" <Lmib@yahoo.com>
Organization: Linux Does It Better
To: Peter Mount <peter@retep.org.uk>
Subject: Re: [INTERFACES] PostgreSQL JDBC with StarOffice
Date: Thu, 21 Oct 1999 20:29:05 +0200
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
Cc: pgsql-interfaces@postgreSQL.org
References: <Pine.LNX.4.10.9910210640580.20667-100000@maidast.retep.org.uk>
In-Reply-To: <Pine.LNX.4.10.9910210640580.20667-100000@maidast.retep.org.uk>
MIME-Version: 1.0
Message-Id: <99102120481206.00414@lmib>
Content-Transfer-Encoding: 8bit

On gio, 21 ott 1999, Peter Mount wrote:
>On Wed, 20 Oct 1999, Fabio.di.Fabio wrote:
>
>> Hi,
>> 
>> I'm trying to connect to a PostgreSQL database via the
>> JDBC-PostgreSQL interface in StarOffice, but I got a error when I try
>> to create a table. Any suggestion?
>
>Not yet, although I am looking at it at the moment.

ok thanks,

for completeness my system is LinuxSuse6.2 with PostgreSQL 6.4.x and
StarOffice5.1, jdk1.1.7 from blackdown


these are my steps:

first I've created a database called "provasoffice" with pgaccess.
Then I've set the classpath with postgresql.jar.
From StarOffice File->New Database, in the dialog box I've choosen
JDBC for the type, and in the JDBC preferences I've set:

JDBC Class Driver:  postgresql.jar
URL: jdbc:postgresql:provasoffice
my user name and my login

after when I try to create a new table I get this error:

	ERROR: parser: parse error at or near "("


ciao, 
	Fabio