Operations widh CURSORS - Mailing list pgsql-general

From Marcos Barreto de Castro
Subject Operations widh CURSORS
Date
Msg-id 20000602112930.27571.qmail@web6005.mail.yahoo.com
Whole thread Raw
Responses recipe database  (moebius@ip-solutions.net)
Re: Operations widh CURSORS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

  Is it possible to declare 2 cursors in the same
transaction?
  I am issuing a "BEGIN WORK" statement, after that I
am issuing "DECLARE c_cursor FOR SELECT * FROM table".
When, after that, I issue "DECLARE c_cursor1 FOR
SELECT COUNT(*) FROM table" I get a segmentation
fault.
  Is there a way to avoid this and still be able to
open 2 cursors in the same transaction?
  Thanks a lot.

Marcos Castro
email: mbdecastro@yahoo.com

__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com

pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: query optimiser changes 6.5->7.0
Next
From: Ed Loehr
Date:
Subject: Re: Vacuum Question