Re: Multi column foreign keys.

Oh wow, thanks alot for that Kris,

Some questions though:
When I do
DatabaseMetaData metaData = connection.getMetaData ();
ResultSet tableResultSet = metaData.getTables ("", null, null, new
String[]{"TABLE"})

I'm actually getting alot more tables than I wanted. I seem to be getting all
the system tables, which I don't want.
I also get messages like :
"Column is_insertable_into in table views has unknown type code 1111"

Is this something to do with upgrading from 7.3 to 7.4 ?

Mof.


On Tue, 9 Dec 2003 09:02 pm, you wrote:
> On Tue, 9 Dec 2003, Mofeed Shahin wrote:
> > Ummm Thanks for that.
> > The problem is that its not my database.
> > I'm just writing a bridge between JDBC, and another format, and therefore
> > I am expect to handle all sorts of weird table setups....
>
> Here's a patch that should fix your problem if you are running a 7.4 or
> better server.  A prebuilt binary for the 1.4 jdk is available here:
>
> http://www.ejurka.com/pgsql/
>
> This jar file has a different default port compiled in so you must be
> certain to specify the port you want to connect to if you try and use it.
>
> Kris Jurka