Begin/Commit - Mailing list pgsql-sql

From Linh Luong
Subject Begin/Commit
Date
Msg-id 20011228222730.555C0197395@jamie.edmonton.computalog.com
Whole thread Raw
Responses Re: Begin/Commit
Re: Begin/Commit
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Chester Carlton Young
Date:
Subject: query by tableoid, oid
Next
From: Stephan Szabo
Date:
Subject: Re: Begin/Commit