Re: DEFERRABLE NOT NULL constraint

Chris Angelico <rosuav@gmail.com>

From: Chris Angelico <rosuav@gmail.com>
To: pgsql-general@postgresql.org
Date: 2013-02-06T09:22:03Z
Lists: pgsql-general
On Wed, Feb 6, 2013 at 8:01 PM, Jasen Betts <jasen@xnet.co.nz> wrote:
> On 2013-02-06, Bèrto ëd Sèra <berto.d.sera@gmail.com> wrote:
>> Hi
>>
>>> You've hidden nothing from INSERT-RETURNING.
>>
>> ?? Or from a select, if the final value is what you mean. What we hide
>> is the way values are made, clearly not the final value. That bit is
>> accessible to anyone who can select the table, obviously.
>>
>
> so the trigger function is opaque, written in C or some other language
> where they can't access the source easily?

I still don't see how that's any better than a stored procedure that
directly does the INSERT. You can conceal the code every bit as
easily.

ChrisA