Thanks to all for the great responses. Foreign keys do seem to be the way to
go. That would be my luck to pick a data type for a table name...this type
seems a bit obscure--I wasn't able to find any documentation on it. Does
anyone know what it is for?
Thanks,
-Jason
Ed Loehr <eloehr@austin.rr.com> on 03/03/2000 06:32:19 PM
To: Jason Vasquez/AM/LLY@Lilly, pgsql-general@postgreSQL.org
cc:
bcc:
Subject: Re: [GENERAL] Nested tables
Ed Loehr wrote:
>
> Jason Vasquez wrote:
> > 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
Well, I snooped around a bit and apparently there is a built-in type
called 'acl'. So either I spoke up when I had no idea what I was
talking about (and no idea that I had no idea) but you did, or you got
unlucky and named a table by the same name as a pgsql built-in type.
Chances are it's the former.
Cheers,
Ed Loehr
************
