Monday, September 15, 2008

Re: [HACKERS] Transaction Snapshots and Hot Standby

On Friday 12 September 2008 07:44:36 Csaba Nagy wrote:
> And then
> the actually interesting question: what will the slave do with views,
> rules, triggers ? I guess triggers are out of the question to be
> executed, what about rules ? Probably must be also ignored... user
> functions will probably get errors if they try to update something...
> Views should probably function correctly.

If we dont have rules, we dont get views, so those need to be. Really we
should allow anything that would work in the context of a read only
transaction. (ie. functions that dont change anything should be fine to call)

Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

No comments: