Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and

Rod Taylor <pg@rbt.ca>

From: Rod Taylor <pg@rbt.ca>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Martijn van Oosterhout <kleptog@svana.org>, Tom Lane <tgl@sss.pgh.pa.us>, Greg Stark <gsstark@mit.edu>, Qingqing Zhou <zhouqq@cs.toronto.edu>, pgsql-hackers@postgresql.org
Date: 2005-12-29T14:35:27Z
Lists: pgsql-hackers
> So, my thinking would be to separate things into two:
> a) Add a TODO item "shared temp tables" that caters for (1) and (4)
> 
> 	ALTER TABLE name RELIABILITY 
> 		{DELETE ROWS AT RECOVERY | FULL RECOVERY}
> (syntax TBD)

DELETE ROWS AT RECOVERY would need to be careful or disallowed when
referenced via a foreign key to ensure the database is not restored in
an inconsistent state.

--