Re: Connecting Openoffice Postgres

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@postgresql.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@comcast.net