Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Jasen BettsDate: 2010-02-16 09:59:29
Subject: Re: storing a text file
Previous:From: Mag GamDate: 2010-02-15 18:26:29
Subject: Re: storing a text file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group