Re: Begin/Commit

On Fri, Dec 28, 2001 at 07:26:13PM -0500, Tom Lane wrote:
> Linh Luong <linh.luong@computalog.com> writes:
> > I was wondering is there a limitation in the number of sql stmt that can go 
> > between a begin and commit.
> 
> No, not as such.
> 
> If you are doing operations that involve foreign-key checks, you may see
> performance problems in pre-7.2 releases due to some operations that
> walk the list of pending foreign-key triggers.  You didn't give enough
> info to know if that is a problem, though.
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Would one of these conditions include deleting a row where there is
a field that is used as a foreign-key in another table?

Thanks

marc