Re: RLS policy dump/restore failure due to elided type-casts - Mailing list pgsql-general

From Tom Lane
Subject Re: RLS policy dump/restore failure due to elided type-casts
Date
Msg-id 18967.1461201440@sss.pgh.pa.us
Whole thread Raw
In response to RLS policy dump/restore failure due to elided type-casts  (Karl Czajkowski <karlcz@isi.edu>)
Responses Re: RLS policy dump/restore failure due to elided type-casts
List pgsql-general
Karl Czajkowski <karlcz@isi.edu> writes:
>   CREATE POLICY delete_stuff ON stuff
>   FOR DELETE USING ('example attribute value' = ANY ( ((SELECT current_attributes()))::text[] ));

Just out of curiosity, why are you doing it like that, and not simply

USING ('example attribute value' = ANY (current_attributes()))

It seems like you're going out of your way to complicate matters.

            regards, tom lane


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: RLS policy dump/restore failure due to elided type-casts
Next
From:
Date:
Subject: Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?