Re: Problem with getImportedKeys / getExportedKeys

Jason,

Thanks for the patch. I will try it out soon.

Regarding the case sensitivity, I think this is an issue that needs to be
resolved in many more places in JDBC (if at all).

Thanks,


Jeroen

-----Original Message-----
From: Jason Davies
To: Vianen, Jeroen van
Cc: PostgreSQL JDBC
Sent: 15-1-02 21:26
Subject: Re: [JDBC] Problem with getImportedKeys / getExportedKeys

Yes, at the moment they are the wrong way round because of a
misinterpretation on my part. Easily fixed, by changing the SQL part so
that the Java code reads:

...

+ ((primaryTable != null) ? "AND c.relname='" + primaryTable + "' " :
"")
+ ((foreignTable != null) ? "AND c2.relname='" + foreignTable + "' " :
"")

...

I've attached a patch for this for now. But maybe case-sensitive stuff
needs to be resolved?

Thanks,
Jason Davies