All I can recommend is to make sure that the version of the driver
with the version of the DB match. COnstraints reengineering works for
me on 8.0.*. I remember there were reports about problems with
*older* versions, but never the newer ones.
Andrus
On Mar 9, 2006, at 8:20 PM, Tomi NA wrote:
> I just reengineered a pgsql (8.1.x) database schema with a number
> of tables like the one below (taken from the pgadmin3 table
> definition view).
> Focus on the DDL: the references are there, just not picked up by
> the modeler when it reengineers the database.
> I use a (level3) jdbc driver from the postgresql package.
>
> CREATE TABLE opca.dokument
> (
> sif_dokument int4 NOT NULL,
> sif_vrsta_dokumenta int4,
> sif_spis int4,
> zaprema timestamp,
> opis varchar(255),
> CONSTRAINT dokument_pkey PRIMARY KEY (sif_dokument),
> CONSTRAINT fk_dokument_1 FOREIGN KEY (sif_spis)
> REFERENCES opca.spis (sif_spis) MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> CONSTRAINT fk_dokument_2 FOREIGN KEY (sif_vrsta_dokumenta)
> REFERENCES opca.vrsta_dokumenta (sif_vrsta_dokumenta) MATCH
> SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION
> )
> WITHOUT OIDS;
>
> Why are the foreign key references not detected? Am I doing
> something wrong? It's been a while since I last reengineered a
> schema, especially on pgsql.
>
> TIA,
> Tomislav
This archive was generated by hypermail 2.0.0 : Thu Mar 09 2006 - 12:31:58 EST