Re: Connecting Openoffice Postgres

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connecting Openoffice Postgres
Date: 2003-11-28 22:32:00
Message-ID: 200311281432.00716.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 26 November 2003 11:49 am, Tim Semmelhaack wrote:
> Hello,
> thank you for your reply.
>
> I had the same problems with ODBC. I could only run query, but I couldn't
> create or alter tables. If I tried, Openoffice failed without a precise
> Error
> message, so the same as if I used JDBC. So I think it's more a problem of a
> Postgres setting?
>
> I workl with Suse Linux 9.0 (newest version) and Postgres 7.3.4
>
> Tim
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> >
> > Is there a reason you're using the jdbc driver ? ODBC works perfectly
> > fine.
> > Also the platform would be interesting.
> >
> > On Saturday 22 November 2003 08:14 am, tim wrote:
> > > I have problems to connect my postgres db in Openoffice 1.1 via jdbc.
> > >
> > > I can open the tables and run queries. But when try to create or alter
> > > tables OpenOffice crashes.
> > >
> > > My Settings
> > >
> > > ClassPath
> >
> > /usr/share/pgsql/pg73b1jdbc2.jar:/usr/share/pgsql/pg73b1jdbc3.j
> > ar
> >
> > > JDBC Driver Class org.postgresql.Driver
> > >
> > > Tim
> > >
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> > > commands go to majordomo(at)postgresql(dot)org
> >
> > - --
> > Open Source Solutions 4U, LLC 2570 Fleetwood Drive
> > Phone: +1 650 872 2425 San Bruno, CA 94066
> > Cell: +1 650 302 2405 United States
> > Fax: +1 650 872 2417
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.2.1 (GNU/Linux)
> >
> > iD8DBQE/w0shjqGXBvRToM4RAhpYAKDMsCwomkwo+d+vbCDkW+ONdo0wUQCgk+Nm
> > wbxmN6dzFnRRF1Fco3agWHY=
> > =keka
> > -----END PGP SIGNATURE-----

The problem is that OpenOffice will not update tables without an identified
primary key. The Catch-22 is the that it cannot see primary keys in Postgres
when they are of the serial type. See the following for all the gory details-

http://www.openoffice.org/issues/show_bug.cgi?id=3872
--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2003-11-28 22:34:00 Re: Misplaced modifier in Postgresql license
Previous Message Bruce Momjian 2003-11-28 22:23:56 Re: [GENERAL] Misplaced modifier in Postgresql license