Re: Trapping QUERY_CANCELED: yes, no, maybe? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Trapping QUERY_CANCELED: yes, no, maybe?
Date
Msg-id 9532.1091323473@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trapping QUERY_CANCELED: yes, no, maybe?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Trapping QUERY_CANCELED: yes, no, maybe?  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> You are asking if a funciton itself might want to set query cancel and
> catch the cancel and do something else?

Exactly.  There's a proof-of-concept test at the bottom of
regress/sql/plpgsql.sql, wherein a function gets control back
from a query that would have run for an unreasonably long time.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Trapping QUERY_CANCELED: yes, no, maybe?
Next
From: Bruce Momjian
Date:
Subject: Re: Version Numbering -- The great debate