plpgsql - raising exceptions with open cursors

From: Tim Penhey <tim(at)penhey(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: plpgsql - raising exceptions with open cursors
Date: 2004-09-14 09:49:43
Message-ID: 4146BEB7.2080205@penhey.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am writing a plpgsql function and I have come across the situation
where I want to raise an exception, but there are cursors open.

Do these need to be closed before raising the exception or is that all
handled for me?

Thanks,
Tim

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-09-14 09:53:16 Re: Rollback on Error
Previous Message Michael Paesold 2004-09-14 09:39:32 Rollback on Error