MaXX <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster