Re: setCatalog()

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Patrik Lundgren <patrik(at)mensa(dot)se>
Cc: 'Barry Lind' <blind(at)xythos(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: setCatalog()
Date: 2003-03-31 23:39:34
Message-ID: 1049153974.1106.48.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Yes, they connect to each catalog over a seperate conection.

Dave
On Mon, 2003-03-31 at 16:04, Patrik Lundgren wrote:
> But when I use pgAdmin II I can administrate the different catalogs. Are
> you saying that a different connection is created for each catalog?
>
> Regards
>
> --------------------------------------------
>
> Patrik,
>
> It is currently implemented. Because of how postgres connections work,
> setCatalog is a noop. In postgres a connection connects to a specific
> database. There is no way that a connection can be repointed to a
> different database (that would be a different connection). So
> setCatalog is implemented in the only way that is compatible with the
> postgres architecture.
>
> thanks,
> --Barry
>
>
> Patrik Lundgren wrote:
> > Anyone knows of any plans of implementing the setCatalog method in
> > Connection?
> >
> > Regards,
> > Patrik Lundgren
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
> >
>
>
> ---------------------------(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>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jean-Christian Imbeault 2003-04-01 02:19:20 character coding problems
Previous Message Miguel Angel Martin 2003-03-31 22:21:48 I can't connect to a database from application