This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2
--------------------------------------------------------------------------- Sean Chittenden wrote: > > > > Um, why not make it an actual full blown security feature by > > > > applying the following patch? This gives PostgreSQL real read > > > > only transactions that users can't escape from. Notes about the > > > > patch: > > > > > > Way nifty. > > > > > > I vote in favor of this patch (suitably documented & debugged) for 7.5. > > > > Heh, there ain't much to debug: it's pretty straight forward. I ran > > all the use cases/syntaxes I could think of and they worked as > > expected. It's a pretty chump little ditty that I originally wrote > > for the sake of the 7.4 PR, but it's proving to be quite useful here > > in my tree... though I like the name "jail_read_only_transactions" > > more... patch updated for new name. > > Err.. and attached. -sc > > -- > Sean Chittenden [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])