Skip site navigation (1) Skip section navigation (2)

Re: referencial integrity constraint bug in version 7.0 beta 5

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 (view raw or flat)
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

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2000-04-28 14:48:34
Subject: Re: Revisited: Transactions, insert unique.
Previous:From: Julio Dominguez, BNCDate: 2000-04-28 14:18:58
Subject: Data Warehousing and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group