| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Linh Luong <linh(dot)luong(at)computalog(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Begin/Commit |
| Date: | 2001-12-28 23:41:17 |
| Message-ID: | 20011228154024.H62612-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, 28 Dec 2001, Linh Luong wrote:
> 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????
Yes, in general that should be fine (excepting that
any failed statement will force a rollback which
affects all of the statements in the transaction)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dempsey Bullock | 2001-12-28 23:54:37 | Retrieving information from System Tables |
| Previous Message | Linh Luong | 2001-12-28 22:27:29 | Begin/Commit |