This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---------------------------------------------------------------------------
Decibel! wrote:
> 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 [EMAIL PROTECTED]
> Give your computer some brain candy! www.distributed.net Team #1828
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
--
Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
