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.
> # 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
In response to
pgsql-general by date
|Next:||From: Bruce Momjian||Date: 2000-04-28 14:48:34|
|Subject: Re: Revisited: Transactions, insert unique.|
|Previous:||From: Julio Dominguez, BNC||Date: 2000-04-28 14:18:58|
|Subject: Data Warehousing and PostgreSQL|