Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2007 PostgreSQL Global Development Group