From: | wieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | Vassiliadis Spyros <aceteam(at)it(dot)teithe(dot)gr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: referencial integrity constraint bug in version 7.0 beta 5 |
Date: | 2000-04-28 00:57:45 |
Message-ID: | m12kz6H-0003lNC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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) #
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2000-04-28 01:12:13 | Re: Re: [HACKERS] pgsql/php3/apache authentication |
Previous Message | Brett W. McCoy | 2000-04-28 00:57:17 | Pg.pm versus DBD::Pg |