diff options
| author | Joe Conway | 2006-06-21 16:43:11 +0000 |
|---|---|---|
| committer | Joe Conway | 2006-06-21 16:43:11 +0000 |
| commit | 1d895f426fdad4a0bfa9037b325f14004ceb9262 (patch) | |
| tree | 04420a159f46f1a8aed739a607c834df12c46c85 /contrib/dblink/expected | |
| parent | 04c5b69603c4ec7f80022d0ae6d92ad8a6730141 (diff) | |
- During dblink_open, if transaction state was IDLE, force cursor count to
initially be 0. This is needed as a previous ABORT might have wiped out
an automatically opened transaction without maintaining the cursor count.
- Fix regression test expected file for the correct ERROR message, which
we now get given the above bug fix.
Diffstat (limited to 'contrib/dblink/expected')
| -rw-r--r-- | contrib/dblink/expected/dblink.out | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/dblink/expected/dblink.out b/contrib/dblink/expected/dblink.out index 55d2b9e7c4c..f2e364a9423 100644 --- a/contrib/dblink/expected/dblink.out +++ b/contrib/dblink/expected/dblink.out @@ -509,7 +509,7 @@ SELECT dblink_close('myconn','rmt_foo_cursor'); -- this should fail because there is no open transaction SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo'); ERROR: sql error -DETAIL: ERROR: cursor "xact_test" already exists +DETAIL: ERROR: DECLARE CURSOR may only be used in transaction blocks -- reset remote transaction state SELECT dblink_exec('myconn','ABORT'); |
