Skip site navigation (1) Skip section navigation (2)

Re: RI / foreign key on VIEW

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To:
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: RI / foreign key on VIEW
Date: 2004-02-08 01:05:13
Message-ID: 40258B49.6080501@e-trolley.de (view raw or flat)
Thread:
Lists: pgsql-novice
Reshat Sabiq wrote:
> 
> 
> Nabil Sayegh wrote:
> 
>> Hi all,
>>
>> I have a db structure with a VIEW that I need to reference (ON DELETE 
>> CASCADE).
>> I know that it is not possible to have references on a VIEW, but maybe 
>> someone has some TRIGGERs at hand that do this job.
[...]
> Last i heard VIEWs aren't yet updateable, but there are plans to make 
> them so sometimes in the future?

Thanks for your answer, but I don't need updateable VIEWs.
I need referenceable VIEWs.

TFYH
-- 
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de

In response to

pgsql-novice by date

Next:From: Nabil SayeghDate: 2004-02-08 14:02:45
Subject: Re: RI / foreign key on VIEW
Previous:From: Tom LaneDate: 2004-02-07 20:51:56
Subject: Re: pgplpsql and the command line

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group