Received: from mail.computalog.com (mail.computalog.com [209.82.103.230]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBSMSCm28683 for ; Fri, 28 Dec 2001 17:28:12 -0500 (EST) (envelope-from lluong@computalog.com) Received: from jamie.edmonton.computalog.com (mug [209.82.103.229]) by mail.computalog.com (8.11.2/8.11.2) with ESMTP id fBT6HKZ05138 for ; Fri, 28 Dec 2001 23:17:20 -0700 Received: by jamie.edmonton.computalog.com (Postfix, from userid 1005) id 555C0197395; Fri, 28 Dec 2001 15:27:30 -0700 (MST) Content-Type: text/plain; charset="iso-8859-1" From: Linh Luong Reply-To: linh.luong@computalog.com To: pgsql-sql@postgresql.org Subject: Begin/Commit Date: Fri, 28 Dec 2001 15:27:29 -0700 X-Mailer: KMail [version 1.3] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20011228222730.555C0197395@jamie.edmonton.computalog.com> X-ECS-MailScanner: Found to be clean X-Archive-Number: 200112/254 X-Sequence-Number: 6076 Hi, I was wondering is there a limitation in the number of sql stmt that can go between a begin and commit. I have a very large file that contains many updates and inserts (I mean many). And it is taking too long to restore the data. Pg_restore is out of the questions at the current moment because of the data version. Example, Begin Work; .... ... .. (1000 update/inserts sql smts) Commit Work; Is this allowed???? Thanks LL