Re: COMMIT in PostgreSQL

From: stefan(at)extum(dot)com
To: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COMMIT in PostgreSQL
Date: 2002-07-20 12:07:17
Message-ID: Pine.LNX.4.44.0207201503280.3777-100000@extum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-20 13:09:59 Re: Linux max on shared buffers?
Previous Message stefan 2002-07-20 12:03:02 Re: COMMIT in PostgreSQL