reverse engineering a postgresql database: no relationships detected?

From: Tomi NA (hefes..mail.com)
Date: Thu Mar 09 2006 - 12:20:59 EST

  • Next message: Tomi NA: "Re: cayenne.jar signing problem"

    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:21:01 EST