Hello,
I am not sure if i understand you.
I am using PostgreSQL 8.1.3 with the jdbc 8.2dev-501 JDBC 3
and already imported tables with thier relationships!
Try to update the server/jdbc and if now maybe you ask again to send the other settings.
Sako.
----- Original Message -----
From: Tomi NA
To: cayenne-use..bjectstyle.org
Sent: Saturday, March 11, 2006 3:54 PM
Subject: Re: reverse engineering a postgresql database: no relationships detected?
On 3/10/06, Cris Daniluk <cris.danilu..mail.com > wrote:
There's some sketchy documentation of this issue:
http://archives.postgresql.org/pgsql-bugs/2002-06/msg00088.php
http://archives.postgresql.org/pgsql-bugs/2003-08/msg00098.php
However, the JDBC driver project is run in a bit of a vacuum, so its hard to say if any good would come from telling them. Most likely, we'll have to submit a patch to them, or workaround in Cayenne.
The first problem is possibly related to what we're talking about: the second is not (there are no composite keys of any sort in my database).
I've asked on the pgsql-jdbc mailing list if someone there knew anything about this. The response couldn't have been any different, really, as I can't provide any real details:
"If you can get some info about exactly what the postgresql driver is
returning that is incorrect or not what cayenne expects, then you might
make some progress.. Otherwise this is a bit vague."
The complete thread is available at http://groups.google.com/group/pgsql.interfaces.jdbc/browse_thread/thread/41c765c91f2c4ca6/29e9cd36678435e1#29e9cd36678435e1
Can someone provide more precise information so that the jdbc developers could get a better idea of what the problem is?
Regards,
Tomislav
This archive was generated by hypermail 2.0.0 : Sat Mar 11 2006 - 11:33:10 EST