From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: pgsql-sql@postgresql.org
Subject: Another constant in foreign key problem.
Date: Wed, 22 Feb 2012 10:35:11 +0000
Message-ID: <201202221035.11963.gary.stainburn@ringways.co.uk> (raw)
I have three tables,
users - all users of my web site
facilities - facilities available on my web site
facility_levels - access levels per user/facility.
One of my facilities is a document library (f_id = 22)
For this facility I have the levels
select * from facility_levels where fl_f_id=22 order by fl_level;
fl_f_id | fl_level | fl_desc
---------+----------+--------------
22 | 1 | Read Only
22 | 2 | Add Versions
22 | 3 | Amend
(3 rows)
This sets the global access level for the Document Library per user.
I now want to add authentication control on a document or folder level. For
this I need to create a table library_document_user_level
u_id - user id
ld_id - library document id
fl_level - level
The foreign key constraint on fl_level needs to check facility_levels for
fl_f_id = 22 as well as fl_level existing.
I've googled this but can't find a suitable solution. Can anyone help please.
--
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gary.stainburn@ringways.co.uk
Subject: Re: Another constant in foreign key problem.
In-Reply-To: <201202221035.11963.gary.stainburn@ringways.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox