Re: Actions requiring commit - Mailing list pgsql-novice

From Tom Lane
Subject Re: Actions requiring commit
Date
Msg-id 19376.1266294336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Actions requiring commit  ("Lee Horowitz" <leeh@panix.com>)
List pgsql-novice
"Lee Horowitz" <leeh@panix.com> writes:
> OK, so far so good. Now, just to be clear,  are you saying in addition
> that the dblink(), insert,commit stuff has to be all "in line" in the
> original psql script and can't be in a pl/xxxx language?

No.  The previous responses were about what you could do *directly* in a
PL function.  They weren't considering the possibility of using dblink
to issue commands to another transaction.

            regards, tom lane

pgsql-novice by date:

Previous
From: Mag Gam
Date:
Subject: Re: storing a text file
Next
From: Jasen Betts
Date:
Subject: Re: storing a text file