Re: Is a SERIAL column a "black box", or not?

[Bruno Wolff III <bruno(at)wolff(dot)to>]

On Sun, Apr 30, 2006 at 12:28:50 +0200,
> 
> Since a real stumbling block with the macro approach seems to be the
> granting of permissions maybe we should work on that problem. For
> example, making SERIAL be a macro that expands to:
> 
> id integer default nextval(sequence) SECURITY DEFINER,
> 
> Which would mean that the default expression would be executed as the
> creator of the table, thus obviating the need to grant explicit
> permission to the sequence.

I suggested a long time ago that default expressions should always be
executed as the owner of the table. This got shot down, but I don't remember
if it was because people thought the idea was bad in itself or if it was
the work involved (which I wasn't in a position to do).