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). ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
