Re: transaction limits?

MaXX <bs139412(at)skynet(dot)be> writes:
> jeff sacksteder wrote:
>
>> Are there known limits to how many rows can be inserted by one
>> transaction, or does that just reflect the already documented row, table
>> and database limits?
> An error string in the source code stands:
> "cannot have more than 2^32-1 commands in a transaction"
> (#: access/transam/xact.c:510)

That means you couldn't do more than 2^32-1 INSERT statements.

But that wouldn't (in principle) prevent having each of the 2^32-1 commands
use COPY to insert 2^31 rows, which would presumably mean that the
limit on the number of rows insertable could be 2^63-1.
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/x.html
"I am aware of the benefits of a micro kernel approach. However, the
fact remains that Linux is here, and GNU isn't --- and people have
been working on Hurd for a lot longer than Linus has been working on
Linux." -- Ted T'so, 1992.