Re: COMMIT in PostgreSQL

On Sat, Jul 20, 2002 at 02:50:34PM +0300,
 stefan@extum.com <stefan@extum.com> wrote
 a message of 19 lines which said:

> I was running a script which does some INSERTS and UPDATE some
> table. I found that there is no need for COMMIT; After each
> statement the TABLE is immediately commited.

There is probably no BEGIN; in your script. Try:

BEGIN;

INSERT INTO Domains (name, tech_contact, admin_contact, billing_contact, owner)
  VALUES ('pasteur.eu', 1, 1, 1, 1);

INSERT INTO Domains (name, tech_contact, admin_contact, billing_contact, owner)
  VALUES ('postgresql.eu', 1, 1, 1, 1);

COMMIT;