Re: Question about commit - Mailing list pgsql-novice

From Tom Lane
Subject Re: Question about commit
Date
Msg-id 21343.1265854317@sss.pgh.pa.us
Whole thread Raw
In response to Question about commit  (Lee <Lee@JamToday.com>)
List pgsql-novice
Lee <Lee@JamToday.com> writes:
>    If postgreSQL had such a thing as an "automomous transaction" as in
> Oracle or mySql, then there would be problem; but AFAIK
>    (but then again, I don't know much)   it doesn't, so how do people
> get the same effect?

If you really need it, you can do it with contrib/dblink: connect back
to your own database and issue commands you want to commit immediately.

            regards, tom lane

pgsql-novice by date:

Previous
From: Mladen Gogala
Date:
Subject: Full text search
Next
From: u235sentinel
Date:
Subject: Postgres Triggers issue