Re: setCatalog

On Mon, 2003-04-14 at 07:14, Patrik Lundgren wrote:
> I would like to know if there are any plans to implement the setCatalog
> function?
Not at the moment. Essentially you would internally have to drop the
connection and recreate to another catalog(db). The driver cannot do
this, as it is connection based. In fact psql doesn't do it either, it
must drop and recreate the connection as wll
>
> I'm developing a swing based db admin tool that I think people will
> like. As my application works now the user has to manually create a new
> db item for each catalog. Get's a bit irritating after a while.
>
> Perhaps this is not a very important function for most people. If I find
> a solution can I get it included in the driver?
You can certainly send a patch in.
>
> Another question I have asked about earlier is about
> DatabaseMetaData.getExportedKey(). I got the answer that it only works
> if one of the columns in a constraint is a primary key. My problem is
> that I get an empty resultSet when asking for keys I know exist. Someone
> else beside me who thinks this is wrong, even though the jdbc spec might
> say otherwise?
Can you define how you expect this to work? What are you looking for;
Foreign Keys that are related to non-primary keys in another table?

Dave
>
> Regards,
> Patrik Lundgren
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Dave Cramer <Dave(at)micro-automation(dot)net>