Home > mailing lists

Re: security barrier INSERT - Mailing list pgsql-hackers

From	Brightwell, Adam
Subject	Re: security barrier INSERT
Date	October 25, 2014 05:26:30
Msg-id	CAKRt6CRG6AEHSMn=yBWDAwQiY1ungGsDw6Y58wPRJOAnLwAHmA@mail.gmail.com Whole thread Raw
In response to	security barrier INSERT (Drew Crawford <drew@sealedabstract.com>)
List	pgsql-hackers

Drew,

IMHO this is nonintuitive, the intuitive behavior of a security_barrier view should be to forbid inserting rows that can’t appear in the view.

Isn't that what WITH CHECK OPTION is meant to accomplish?

-Adam

From: Drew Crawford
Date: 25 October 2014, 05:05:28
Subject: security barrier INSERT

From: Robert Haas
Date: 25 October 2014, 06:19:15
Subject: Re: How ugly would this be? (ALTER DATABASE)