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