Re: COMMIT in PostgreSQL

That's right you define a block transaction in this way.
I was a bit confused because each query performed the results are
commited in table without no need of COMMIT.

thank you,
stefan


> 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;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>