| From: | Frank Miles <fpm(at)u(dot)washington(dot)edu> |
|---|---|
| To: | snpe <snpe(at)snpe(dot)co(dot)yu> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DECLARE CURSOR |
| Date: | 2002-11-16 21:29:25 |
| Message-ID: | Pine.A41.4.44.0211161326500.141922-100000@homer08.u.washington.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, 15 Nov 2002, snpe wrote:
> Hello,
> When I call DECLARE CURSOR out of transaction command success,
> but cursor is not created
> Reference manual say that this get error :
> ERROR: DECLARE CURSOR may only be used in begin/end transaction blocks
> I don't find this text in pgsql source code
> What is problem ?
According to the documentation for DECLARE CURSOR (v.7.2.x):
"Cursors are only available in transactions. Use to BEGIN, COMMIT and
ROLLBACK to define a transaction block."
This seems consistent with your error message. Please try
wrapping your DECLARE inside a transaction using BEGIN,...
HTH--
-frank
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Medi Montaseri | 2002-11-16 21:53:39 | pfree() core dump in 7.2.3 |
| Previous Message | Joe Conway | 2002-11-16 20:40:22 | Re: Doing sth. like oracles "connect by" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Pais | 2002-11-16 22:27:22 | Re: [HACKERS] ipc-daemon |
| Previous Message | Rod Taylor | 2002-11-16 21:08:58 | Re: pg_dump in 7.4 |