dblink un-named connection doesn't get re-used

Поиск
Список
Период
Сортировка
От Decibel!
Тема dblink un-named connection doesn't get re-used
Дата
Msg-id F680AB59-6D6F-4026-9599-1BE28880273D@decibel.org
обсуждение исходный текст
Ответы Re: dblink un-named connection doesn't get re-used  (Decibel! <decibel@decibel.org>)
Re: dblink un-named connection doesn't get re-used  (Joe Conway <mail@joeconway.com>)
Re: dblink un-named connection doesn't get re-used  (Bruce Momjian <bruce@momjian.us>)
Re: dblink un-named connection doesn't get re-used  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Is it intentional that dblink's unnamed connections don't get re-used?

stats=# select datname, usename from pg_stat_activity;
datname | usename
---------+---------
stats   | decibel
(1 row)

stats=# select dblink_connect('dbname=stats');
dblink_connect
----------------
OK
(1 row)

stats=# select dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
(1 row)

stats=# select datname, usename from pg_stat_activity;
datname  | usename
----------+----------
stats    | decibel
stats    | postgres
postgres | postgres
(3 rows)

AFAIK there's no way I could possibly use or refer to the connection  
to stats at this point; so why doesn't dblink close it when I issue  
the second connect?
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: generate_iterator functions
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Proposal: generate_iterator functions