Q: CURSOR tuples count - Mailing list pgsql-hackers

From Vazsonyi Peter[ke]
Subject Q: CURSOR tuples count
Date
Msg-id Pine.A32.4.05.9901041643220.16028-100000@kornel.szif.hu
Whole thread Raw
In response to Re: [HACKERS] MVCC works in serialized mode!  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Hello!

I want to make a filtered selection on a table. This can return with many
tuples. The download of the query results may take a few  minutes. I'd like
to show the progress status. How can i do this?
If i run this in two query (first i count the number of lines, than the real
query), than the backend calculates the query two times.
If i use cursor, i can not get the line count before i fetch the whole table.

--So long and thanx for all the fish.NeKo@(kva.hu|kornel.szif.hu)




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] NAN code
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] SQLJ