| From: | Jan Wieck <janwieck(at)yahoo(dot)com> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] VIEWs and FOREIGN keys |
| Date: | 2002-06-10 17:20:10 |
| Message-ID: | 200206101720.g5AHKAK29836@saturn.janwieck.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Achilleus Mantzios wrote:
>
> can someone have a foreign key constraint that references
> a view??
No, and this is not planned either. Remember that it is not
only required for referential integrity to check if a key
exists on INSERT or UPDATE to the referencing table. The
system must guarantee that you cannot remove existing keys
while they are referenced (or more precise perform the
requested referential action).
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-06-10 17:31:57 | Re: MAX TABLE TUPLES and MAX ARRAY SIZE |
| Previous Message | Thomas Beutin | 2002-06-10 17:16:29 | Re: Checking that Pg is running from a shell script |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-06-10 17:33:48 | Re: [HACKERS] Efficient DELETE Strategies |
| Previous Message | Bruce Momjian | 2002-06-10 16:48:16 | Re: Efficient DELETE Strategies |