diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-01-03 21:27:59 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-01-03 21:27:59 +0000 |
| commit | 919c9f6cceeae8468672462a23eab470e18ceda0 (patch) | |
| tree | 57fcce56479c0efb590bab7b1ff957c6f1fa4aeb /contrib/dblink/expected | |
| parent | eedb068c0a7474fb11d67d03b0a9e1ded5df82c4 (diff) | |
| download | postgresql-919c9f6cceeae8468672462a23eab470e18ceda0.tar.gz | |
The original patch to disallow non-passworded connections to non-superusers
failed to cover all the ways in which a connection can be initiated in dblink.
Plug the remaining holes. Also, disallow transient connections in functions
for which that feature makes no sense (because they are only sensible as
part of a sequence of operations on the same connection). Joe Conway
Security: CVE-2007-6601
Diffstat (limited to 'contrib/dblink/expected')
| -rw-r--r-- | contrib/dblink/expected/dblink.out | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/contrib/dblink/expected/dblink.out b/contrib/dblink/expected/dblink.out index bdd2f9926f..fd35d76af9 100644 --- a/contrib/dblink/expected/dblink.out +++ b/contrib/dblink/expected/dblink.out @@ -724,6 +724,12 @@ SELECT dblink_get_connections(); {dtest1,dtest2,dtest3} (1 row) +SELECT dblink_is_busy('dtest1'); + dblink_is_busy +---------------- + 0 +(1 row) + SELECT dblink_disconnect('dtest1'); dblink_disconnect ------------------- @@ -758,3 +764,34 @@ SELECT * from result; 10 | k | {a10,b10,c10} (11 rows) +SELECT dblink_connect('dtest1', 'dbname=contrib_regression'); + dblink_connect +---------------- + OK +(1 row) + +SELECT * from + dblink_send_query('dtest1', 'select * from foo where f1 < 3') as t1; + t1 +---- + 1 +(1 row) + +SELECT dblink_cancel_query('dtest1'); + dblink_cancel_query +--------------------- + OK +(1 row) + +SELECT dblink_error_message('dtest1'); + dblink_error_message +---------------------- + OK +(1 row) + +SELECT dblink_disconnect('dtest1'); + dblink_disconnect +------------------- + OK +(1 row) + |