[HACKERS] security barrier INSERT

2014-10-24 Thread Drew Crawford
Hi guys, I’m seeing some non-intuitive behavior with the new updateable security barrier views in 9.4. Below is the behavior of 9.4b3: > =# create table widget ( id integer); > CREATE TABLE > =# create view widget_sb WITH (security_barrier=true) AS SELECT * from widget > where id = 22; > CREATE

[HACKERS] automatically updating security barrier views

2014-04-06 Thread Drew Crawford
Hello list, I am posting here since Craig Ringer suggested user feedback on this feature at this time may make a difference for 9.4 inclusion. I apologize if I am in the wrong place. Row-level security is probably THE major element the FOSS databases are behind compared to proprietary databas