Re: limits

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: luca(dot)ciciriello(at)email(dot)it
Cc: pgsql-general(at)postgresql(dot)org, alessandra(dot)autunno(at)galileoavionica(dot)it
Subject: Re: limits
Date: 2007-12-16 02:29:44
Message-ID: 200712160229.lBG2Tix09895@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

luca(dot)ciciriello(at)email(dot)it wrote:
> Hi All.
> My question is simple and plain: Are there some limit in the number of
> database operations between a BEGIN statement and a COMMIT statement?

Yes, there is a command counter that is incremented for every command
between BEGIN and COMMIT. It can't exceed 4 billion commands.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

  • limits at 2007-12-04 06:55:10 from luca.ciciriello

Responses

  • Re: limits at 2007-12-16 05:12:47 from Erik Jones

Browse pgsql-general by date

  From Date Subject
Next Message ivo nascimento 2007-12-16 02:48:12 about new feature
Previous Message snacktime 2007-12-16 01:57:27 Conditional updateable view