X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 18B9CD1B508 for ; Sat, 15 Nov 2003 16:01:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 47091-02 for ; Sat, 15 Nov 2003 12:00:38 -0400 (AST) Received: from web21409.mail.yahoo.com (web21409.mail.yahoo.com [216.136.232.79]) by svr1.postgresql.org (Postfix) with SMTP id B30B6D1B4EB for ; Sat, 15 Nov 2003 12:00:37 -0400 (AST) Message-ID: <20031115160036.4919.qmail@web21409.mail.yahoo.com> Received: from [64.81.205.234] by web21409.mail.yahoo.com via HTTP; Sat, 15 Nov 2003 08:00:36 PST Date: Sat, 15 Nov 2003 08:00:36 -0800 (PST) From: ow Subject: Re: Programatically switching database To: Peter Eisentraut Cc: pgsql-sql@postgresql.org In-Reply-To: <20031115043616.90388.qmail@web21405.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/168 X-Sequence-Number: 15983 --- 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