Re: COMMIT in PostgreSQL

Thanks all for help.

I really like the way how postgresql lists are working and, answers,
feedback.
Stefan

On Sat, 20 Jul 2002 stefan(at)extum(dot)com wrote:

>
>
> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>