Begin/Commit

From: Linh Luong <linh(dot)luong(at)computalog(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Begin/Commit
Date: 2001-12-28 22:27:29
Message-ID: 20011228222730.555C0197395@jamie.edmonton.computalog.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-12-28 23:41:17 Re: Begin/Commit
Previous Message Chester Carlton Young 2001-12-28 17:49:49 query by tableoid, oid