Add to TODO:
* Have /contrib/dblink reuse unnamed connections
http://archives.postgresql.org/pgsql-hackers/2007-10/msg00895.php
---
Decibel! wrote:
> Is it intentional that dblink's unnamed connections don't get re-used
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,
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---
Hannu Krosing wrote:
> ?hel kenal p?eval, R, 2007-10-19 kell 15:42, kirjutas Joe Conway:
> > Decibel! wrote:
> > > O
Ühel kenal päeval, R, 2007-10-19 kell 15:42, kirjutas Joe Conway:
> Decibel! wrote:
> > On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
> >>
> >> Seriously though, I can change it for 8.3, but is it really worth
> >> back-patching?
> >
> > I think it'd be worth changing for 8.3. While C forces y
Decibel! wrote:
On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
Seriously though, I can change it for 8.3, but is it really worth
back-patching?
I think it'd be worth changing for 8.3. While C forces you to worry
about memory, SQL does not, so I bet this is a surprise to most folks.
I d
On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-
used?
yes
stats=# select dblink_connect('dbname=stats');
dblink_connect
OK
(1 row)
stats=# select dblink_connect('dbname=postgres');
dblink_conne
Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-used?
yes
stats=# select dblink_connect('dbname=stats');
dblink_connect
OK
(1 row)
stats=# select dblink_connect('dbname=postgres');
dblink_connect
OK
(1 row)
AFAIK there's no
Sorry for the self-reply...
On Oct 18, 2007, at 9:09 AM, Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-used?
From the dblink docs (both 8.1 and HEAD):
if only one argument is given, the connection is unnamed; only
one unnamed
connection can exist
