Transaction within plpgsql - Mailing list pgsql-novice

From Walker, Jed S
Subject Transaction within plpgsql
Date
Msg-id F7638DABBEBB4A4CB70616DE2B19E6B825F846@COENGEXCMB01.cable.comcast.com
Whole thread Raw
Responses Re: Transaction within plpgsql
List pgsql-novice

I am coding a procedure to purge data from a table. I want to commit the data I'm purging at intervals (for example, every 1000 rows). The problem I'm encountering is that when I have

begin transaction;
commit;

statements in my plpgsql function it doesn't compile.

How can you explicitly create transactions within a plpgsql function?

Thanks,

Jed.

pgsql-novice by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: How to get tabloid
Next
From: Bruce Momjian
Date:
Subject: Re: Transaction within plpgsql