diff options
| author | Tom Lane | 2008-11-29 00:13:21 +0000 |
|---|---|---|
| committer | Tom Lane | 2008-11-29 00:13:21 +0000 |
| commit | b651b2a5c257945ba0ef78df22948cf805ba2b57 (patch) | |
| tree | 13f5c5a7f04ad3aea869777bc7231fb42b34f4aa /src/interfaces | |
| parent | 2a6108ac247ed27f084a25269288a2818371aec1 (diff) | |
Make sure we give an appropriate user-facing error when attempting
to drop a table that is referenced by an open cursor. Fix unstable
ecpg regression test result that was produced by this oversight.
Diffstat (limited to 'src/interfaces')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/sql-fetch.stderr | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-fetch.stderr b/src/interfaces/ecpg/test/expected/sql-fetch.stderr index 3e4d7961c3b..32781e2173a 100644 --- a/src/interfaces/ecpg/test/expected/sql-fetch.stderr +++ b/src/interfaces/ecpg/test/expected/sql-fetch.stderr @@ -138,10 +138,10 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 53: using PQexec [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_check_PQresult on line 53: ERROR: relation 16491 is still open +[NO_PID]: ecpg_check_PQresult on line 53: ERROR: cannot drop "my_table" because it is being used by active queries in this session [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: raising sqlstate XX000 (sqlcode -400) on line 53: relation 16491 is still open on line 53 -[NO_PID]: sqlca: code: -400, state: XX000 -sql error: relation 16491 is still open on line 53 +[NO_PID]: raising sqlstate 55006 (sqlcode -400) on line 53: cannot drop "my_table" because it is being used by active queries in this session on line 53 +[NO_PID]: sqlca: code: -400, state: 55006 +sql error: cannot drop "my_table" because it is being used by active queries in this session on line 53 [NO_PID]: ecpg_finish: connection regress1 closed [NO_PID]: sqlca: code: 0, state: 00000 |