Re: Actions requiring commit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lee Horowitz" <leeh(at)panix(dot)com>
Cc: "Greg Stark" <gsstark(at)mit(dot)edu>, "Lee" <lee(at)jamtoday(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Actions requiring commit
Date: 2010-02-16 04:25:36
Message-ID: 19376.1266294336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Lee Horowitz" <leeh(at)panix(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2010-02-16 09:59:29 Re: storing a text file
Previous Message Mag Gam 2010-02-15 18:26:29 Re: storing a text file