Re: COMMIT in PostgreSQL - Mailing list pgsql-general

From stefan@extum.com
Subject Re: COMMIT in PostgreSQL
Date
Msg-id Pine.LNX.4.44.0207201503280.3777-100000@extum.com
Whole thread Raw
In response to Re: COMMIT in PostgreSQL  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
Responses Re: COMMIT in PostgreSQL
List pgsql-general

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
>


pgsql-general by date:

Previous
From: stefan@extum.com
Date:
Subject: Re: COMMIT in PostgreSQL
Next
From: Martijn van Oosterhout
Date:
Subject: Re: COMMIT in PostgreSQL