| From: | Ted Toth <txtoth(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | RLS 9.5rc1 configuration changes? |
| Date: | 2016-01-04 22:44:01 |
| Message-ID: | CAFPpqQHyp8Rht+4azCe8ADfb-4J8waQX8s_kJXgzO7nsO2jkPQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I had been using CrunchyDatas 9.4 with backported RLS but I decided
since my ultimate target is 9.5 that I update to it. However now the
function called for the SELECT policy is not being called. \dt shows
the policy but EXPLAIN ANALYZE of a select doesn't show the filter.
When I turn up debug in postghresql.conf in pgstartup.log I see the
library loaded and the _PG_init function called and in the daily log I
see the client auth function called each time I run psql. The only
changes I made for 9.5 were to no longer set row_security to 'force'
in postgresql.conf and to add:
ALTER TABLE <table name> FORCE ROW LEVEL SECURITY;
in addition to the:
ALTER TABLE <table name> ENABLE ROW LEVEL SECURITY;
which I was already doing as I want RLS to be used even for the owner
of the table.
Are there any other additional configuration changes needed to get RLS
to work again?
Ted
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-01-04 22:54:31 | Re: RLS 9.5rc1 configuration changes? |
| Previous Message | Arthur Pemberton | 2016-01-04 22:37:41 | Re: Cannot upgrade from 9.3 to 9.4 using pg_upgrade |