Re: Programatically switching database

Поиск
Список
Период
Сортировка
От ow
Тема Re: Programatically switching database
Дата
Msg-id 20031115160036.4919.qmail@web21409.mail.yahoo.com
обсуждение исходный текст
Ответ на Programatically switching database  (ow <oneway_111@yahoo.com>)
Ответы Re: Programatically switching database
Список pgsql-sql
---  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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Guillaume LELARGE
Дата:
Сообщение: Re: Getting last insert value
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Programatically switching database