DECLARE CURSOR

From: Atif Jung <atifjung(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: DECLARE CURSOR
Date: 2010-06-28 11:27:01
Message-ID: AANLkTikODkbN8odVXr2FlMKX1Ylzx-XNMfbwiAOEqJYy@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm getting an error msg which reads:

DECLARE CURSOR can only be used in transaction blocks.

does that mean to DECLARE a cursor I must surrond it with a BEGIN & COMMIT
work?

Atif

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-06-28 14:00:17 Re: DECLARE CURSOR
Previous Message Tom Lane 2010-06-27 14:51:07 Re: view and column rights