Re: [PATCH] Docs: Make notes on sequences and rollback more obvious - Mailing list pgsql-hackers

From David Fetter
Subject Re: [PATCH] Docs: Make notes on sequences and rollback more obvious
Date
Msg-id 20120807171334.GB1697@fetter.org
Whole thread Raw
In response to Re: [PATCH] Docs: Make notes on sequences and rollback more obvious  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-hackers
On Tue, Aug 07, 2012 at 03:59:42PM +0800, Craig Ringer wrote:
> On 08/07/2012 02:27 AM, Robert Haas wrote:
> >I did not commit the advanced.sgml changes.
> 
> That's arguably the most important point to raise this. The most
> recent question came from someone who actually bothered to RTFM and
> believed based on the advanced-transactions page that rollback rolls
> *everything* back.

Perhaps we should see about correcting that misapprehension.  When
PostgreSQL does any irreversible process
<http://en.wikipedia.org/wiki/Irreversible_process> such as
incrementing a sequence, writing a file, sending an email, etc., it
can't be rolled back.  Might it be useful to find those irreversible
operations we document and mark same?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: pg_upgrade bug in Windows on PG 9.2
Next
From: Robert Haas
Date:
Subject: Re: Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding