From: ow <oneway_111@yahoo.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Programatically switching database
Date: Sat, 15 Nov 2003 08:00:36 -0800 (PST)
Message-ID: <20031115160036.4919.qmail@web21409.mail.yahoo.com> (raw)
In-Reply-To: <20031115043616.90388.qmail@web21405.mail.yahoo.com>
--- Peter Eisentraut wrote:
> Nothing prevents you from keeping the connection to db1 open when you open
> a connection to db2. By the way, psql's "\c" command does exactly
> disconnect-from-db1-connect-to-db2.
That's the whole point: I'm trying to avoid maintaining *separate* connection
pools for each db. In other words, instead of having, say, 5 connection pools
to 5 dbs with total of 1000 connections, I could've used just one (1) pool with
200 connections, if there was a way to "switch db" (or to do a cross-db query).
Any ideas? Thanks
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oneway_111@yahoo.com, peter_e@gmx.net
Subject: Re: Programatically switching database
In-Reply-To: <20031115160036.4919.qmail@web21409.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox