Re: limits - Mailing list pgsql-general

From Bruce Momjian
Subject Re: limits
Date
Msg-id 200712160229.lBG2Tix09895@momjian.us
Whole thread Raw
In response to limits  (luca.ciciriello@email.it)
Responses Re: limits
List pgsql-general
luca.ciciriello@email.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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

pgsql-general by date:

Previous
From: snacktime
Date:
Subject: Conditional updateable view
Next
From: "ivo nascimento"
Date:
Subject: about new feature