meta-data problem

Hi everyone,

I use cayenne as on object relational mapping system and have a question
about using it with pgsql. It seems that when I try to reverse engineer a
pgsql db (server v.8.1.2), the table structure is OK, but no table relations
are discovered, so all the foreign keys are simply interpreted as additional
integer columns, instead of foreign keys. I've tried using the driver
supplied with pgsql 8.1.2 (8.0-310?) and 8.2dev-501, but it makes no obvious
difference.
My question is: could this be a jdbc-driver bug? I can't tell, but I've used
another RDBMS with cayenne and database structure discovery worked
flawlessly there. Could be a cayenne issue, but the developers suggest it's
probably not, but could be worked arround if needed.

I don't think there's anything wrong with the table and references
definitions. To illustrate, here's one:
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;

Btw, I don't use any composite keys in this database whatsoever, so that's
not part of the problem (I've seen it mentioned in o post some time ago).
I'll reconstruct the relationships by hand this time, but it'd be nice if we
find out why the relationships aren't found.

TIA,
Tomislav