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

Re: Actions requiring commit

From: "Lee Horowitz" <leeh(at)panix(dot)com>
To: "Greg Stark" <gsstark(at)mit(dot)edu>
Cc: "Lee" <lee(at)jamtoday(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Actions requiring commit
Date: 2010-02-15 01:50:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
> On Sun, Feb 14, 2010 at 7:07 PM, Lee <Lee(at)jamtoday(dot)com> wrote:
>> What's the postgres story? If I write to a native operating system file,
>> (and don't commit), does the output appear immediately (no counting
>> internal
>> small delay) ?
>> What about issuing a "system" (shell) comnmand? Causing an signal,  (er
>> "Notify" in postrges land, I guess) , putting something on a queue via
>> PGQ
>> or similar
>> tool?
> In Postgres anything that Postgres manages itself only happens at
> commit. So aside from table modifications and schema changes NOTIFY
> only takes place at commit. But if you have a pl language like plperl
> or plsh write to a file that's outside Postgres's sphere of influence
> and it will happen right away.
> I'm not familiar with PGQ, I'm not sure which tack it takes. Its
> documentation should have an answer though.
Thanks for the reply.

Does that go for pl/pgsql as well?

If I call a pl/pgsql procedure from the psql  command line (or from
another pl/pgsql procedure?) will commits in the called procedure cause
commit in the calling procedure as well, or will the caller and callee
have in effect different "threads" or sessions so that their respective
commits are separated?

In response to


pgsql-novice by date

Next:From: Greg StarkDate: 2010-02-15 02:32:52
Subject: Re: Actions requiring commit
Previous:From: Greg StarkDate: 2010-02-15 01:34:13
Subject: Re: Actions requiring commit

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