From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | list-postgresql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: reference to a view |
Date: | 2004-06-16 14:57:59 |
Message-ID: | 20040616075331.P12864@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 16 Jun 2004, Joolz wrote:
> In my db I have a table type_of_action, fields code varchar, name
> varchar, medical boolean. Two other tables refer to this table, one of
> them to the medical rows, the other one to the none-medical rows. I
> would like to make the reference with a view, like this:
>
> create table type of action_type (
> code varchar,
> name varchar,
> medical boolean
> );
>
> create view action_type_medical as select * from action_type
> where medical=true;
> create view action_type_non_medical as select * from action_type
> where medical=false;
>
> create table general_actions (
> field1, field2, field_etc,
> action_type varchar references action_type_non_medical(code)
> );
>
> create table medical_actions (
> field1, field2, field_etc,
> action_type varchar references action_type_medical(code)
> );
>
> But pg refuses this, can't create a reference to a view. I can now
> create a trigger plus function that will do the check, but is there a
> more elegant way? Thanks!
Not really right now. Note, that to do foreign keys properly you need
triggers on action_type as well and those triggers need to take into
account the view conditions to determine what checks to do.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-06-16 15:06:43 | Re: Multicolumn indexes and ORDER BY |
Previous Message | Tom Lane | 2004-06-16 14:32:35 | Re: Multicolumn indexes and ORDER BY |