| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| 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 20:14:17 |
| Message-ID: | 20021116121239.K27646-100000@megazone23.bigpanda.com |
| 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 ?
I get that error text in 7.3b2. Don't have an earlier version available
right at the moment to test.
It may very well be making the cursor, but IIRC the cursor would have gone
away at the end of the implicit transaction wrapping the statement.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Burski | 2002-11-16 20:21:47 | Re: Parse error |
| Previous Message | Josh Berkus | 2002-11-16 18:58:34 | Re: More than 16 args to postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-11-16 20:36:38 | Re: Where can I find a list of the new features appearing |
| Previous Message | Tom Lane | 2002-11-16 20:13:55 | Re: Missing file from CVS? |