Re: [GENERAL] [9.5] next question: rls and indexes

2015-07-22 Thread Dean Rasheed
On 15 July 2015 at 09:34, Andreas Kretschmer wrote: > test=> explain select * from rls_test ; > QUERY PLAN > - > Seq Scan on rls_test (cost=0.00..630.00 rows=91 width=335) >Filter: (name = ("current_user"())

[GENERAL] [9.5] next question: rls and indexes

2015-07-15 Thread Andreas Kretschmer
hi @ll, my table: test=*# \d rls_test Table "public.rls_test" Column | Type | Modifiers +-+--- id | integer | name | text| txt| text| Indexes: "idx_name" btree (name) Policies: POLICY "my_policy" FOR ALL USING (name = ("current_u