Re: FK pointing to a VIEW

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: FK pointing to a VIEW
Date: 2006-11-10 19:36:50
Message-ID: 20061110193650.GA1945@KanotixBox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sandro Dentella <sandro(at)e-den(dot)it> schrieb:

> Do I understad correctly that i cannot point a Foreign Key to a view? Which
> is the rationale of this?

A VIEW is simply a regular SELECT ..., a string that contains a SELECT.

Question: How can you add a FK to a string? You can add a FK to a table,
no problem, but to a simple string?

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-11-10 19:41:43 Re: Using GIN indexes on 8.2
Previous Message Brendan Jurd 2006-11-10 19:34:36 Request for replication advice