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

Actions requiring commit

From: Lee <Lee(at)JamToday(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Actions requiring commit
Date: 2010-02-14 19:07:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
This may sound wierd for those not coming from an Oracle background, but 
in Oracle land, certain actions such as writing to a native operating 
system file,
placing a job on a queue for asynchronous processing, and such like 
actions don't actually happen until commit time.

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

Do all or any of those require a commit to "make it so" or not?


pgsql-novice by date

Next:From: Joshua TolleyDate: 2010-02-14 19:29:34
Subject: Re: storing a text file
Previous:From: Mag GamDate: 2010-02-14 14:39:13
Subject: storing a text file

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