Re: Begin/Commit

On Fri, Dec 28, 2001 at 07:26:13PM -0500, Tom Lane wrote:
> Linh Luong <linh(dot)luong(at)computalog(dot)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