Re: [HACKERS] CBAC (content based access control), OIDs, auto fields

Thus spake De Clarke
> In fact, while I'm dreaming: why not have a set of *three*
> table creation options?
> -recno causes an autonumber field to be prepended
> to each record.
> -user causes the user ID of the inserting process
> to be prepended to each record.
> -stamp causes the timestamp at insert time to be
> prepended.
> The fields could have fixed names (like oid), say "recno",
> "user", and "stamp" -- or as a luxury option the user could
> supply their names as part of the option syntax:
> -user uid -stamp itime -recno seqno
>
> Like oid, these fields would *not appear* in result streams
> unless explicitly included in the FSE. 'select *' would not
> reveal them, but 'select oid,recno,user,stamp,*' would show
> all fields. (If these options are specified at table create

I like the general idea but I think they should either show up
when '*' is selected or else automatically put them into each
table. If you don't then generic functions will have problems.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.