RLS 9.5rc1 configuration changes?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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