Re: [GENERAL] Nested tables

Jason Vasquez wrote:
>
> I've looked through the documentation, but I've not found anything that
> addresses this situation. Is this possible with PostgreSQL?  Or maybe there is
> a better way to accomplish what I want to do?
>
> Basically, I'd like to set up an ACL-like property for each record. A table
> could be strucured like this:
>
> Table ACL:
>    Attribute   |    Type     |          Modifier
> ---------------+-------------+----------------------------
>  uniqid        | varchar(12) | not null
>  date_created  | timestamp   | not null
>  date_modified | timestamp   | not null
>  read          | boolean     | not null default 'f'::bool
>  write         | boolean     | not null default 'f'::bool
>  execute       | boolean     | not null default 'f'::bool
>  delete        | boolean     | not null default 'f'::bool
>
> Table myItem:
>    Attribute    |    Type     | Modifier
> ----------------+-------------+----------
>  uniqid         | varchar(12) | not null
>  date_created   | timestamp   | not null
>  date_modified  | timestamp   | not null
>  author         | text        | not null
>  title          | text        | not null
>  access_control | acl         | not null
>
> PostgreSQL lets me create the class myItem with a "acl" field type, but I
> can't figure out how to insert multiple values (or any values!) into the
> access_control field...

Hmmm.  Why would you want that?  Do you really mean to insert multiple
records, each with an individual access_control value?  At the risk of
completely oversimplifying your problem, my guess is that you're
looking for the notion of a foreign key in myItem, i.e.,

Table ACL:
   uniqid   integer not null unique,  -- or use pgsql 'serial' type...
   ...

Table myItem:
   uniqid      integer not null unique,
   ...
   ACL_uniqid  integer not null  -- a foreign key into ACL

Cheers,
Ed Loehr