summaryrefslogtreecommitdiff
path: root/contrib/dblink/expected
diff options
context:
space:
mode:
authorJoe Conway <mail@joeconway.com>2003-11-28 05:03:02 +0000
committerJoe Conway <mail@joeconway.com>2003-11-28 05:03:02 +0000
commitd1824a5ccb5ace3080ffa33db55bfd36640633a6 (patch)
treef7ed9e55104de72e21f98781707c741e995cdc87 /contrib/dblink/expected
parentdd01cfe1c49bcd352fa7a723130a92376802d5c7 (diff)
downloadpostgresql-d1824a5ccb5ace3080ffa33db55bfd36640633a6.tar.gz
Fix regression in dblink_disconnect() reported by Eduardo Stern:
persistent_conn was left dangling after a disconnect in the unnamed connection case, causing a subsequent disconnect to crash the backend.
Diffstat (limited to 'contrib/dblink/expected')
-rw-r--r--contrib/dblink/expected/dblink.out6
1 files changed, 2 insertions, 4 deletions
diff --git a/contrib/dblink/expected/dblink.out b/contrib/dblink/expected/dblink.out
index 50938b3ef1..7ef40b06d7 100644
--- a/contrib/dblink/expected/dblink.out
+++ b/contrib/dblink/expected/dblink.out
@@ -185,13 +185,11 @@ SELECT dblink_disconnect();
OK
(1 row)
--- should generate "no connection to the server" error
+-- should generate "connection not available" error
SELECT *
FROM dblink('SELECT * FROM foo') AS t(a int, b text, c text[])
WHERE t.a > 7;
-ERROR: sql error
-DETAIL: no connection to the server
-
+ERROR: connection not available
-- put more data into our slave table, first using arbitrary connection syntax
-- but truncate the actual return value so we can use diff to check for success
SELECT substr(dblink_exec('dbname=regression','INSERT INTO foo VALUES(10,''k'',''{"a10","b10","c10"}'')'),1,6);