From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Jan Wieck <wieck(at)debis(dot)com> |
Cc: | Vassiliadis Spyros <aceteam(at)it(dot)teithe(dot)gr>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: referencial integrity constraint bug in version 7.0 beta 5 |
Date: | 2000-04-28 14:44:29 |
Message-ID: | 200004281444.KAA28255@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Done and updated.
> Spyros Vasileiadis wrote:
>
> > I am running a slackware 7 linux box (kernel 2.2.14 g++2.91.66) and i 've
> > installed the ver 7 beta 5. So i had the following problem
> >
> > I suppose when you make a constraint statement for reference key theere
> > should be a check for the fields names , example:
>
> You're right. Bruce, would you please add these items to the
> 7.1 todo:
>
> Check PK attributes to exist (maybe to be comparable with
> corresponding FK attribute if possible) at foreign key
> definition time.
>
> Deny column dropping if column in question is used by an
> FK constraint.
>
> Propagate column or table renaming to FK constraints.
>
> Emit a warning if at FK creation time no UNIQUE index
> exists over referenced PK attributes.
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #========================================= wieck(at)debis(dot)com (Jan Wieck) #
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-04-28 14:48:34 | Re: Revisited: Transactions, insert unique. |
Previous Message | Julio Dominguez, BNC | 2000-04-28 14:18:58 | Data Warehousing and PostgreSQL |