[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    [BUGS] BUG #4119: Add foreign key fails for non-presence of a record that does exist.
From:       "Buk" <p9e883002 () sneakemail ! com>
Date:       2008-04-21 1:58:45
Message-ID: 200804210158.m3L1wj2t013524 () wwwmaster ! postgresql ! org
[Download RAW message or body]


The following bug has been logged online:

Bug reference:      4119
Logged by:          Buk
Email address:      p9e883002@sneakemail.com
PostgreSQL version: 8.2.4,
Operating system:   XP SP1
Description:        Add foreign key fails for non-presence of a record that
does exist.
Details: 

I'm trying to run this:

big_db=# ALTER TABLE word_doc ADD FOREIGN KEY (word_id) REFERENCES words
(word_id) ON UPDATE RESTRICT ON DELETE RESTRICT;

I'm getting this error:

ERROR:  insert or update on table "word_doc" violates foreign key constraint
"word_doc_word_id_fkey"
DETAIL:  Key (word_id)=(65935) is not present in table "words".

And yet, there is the "missing" key:

big_db=# select * from words where word_id = 65935;
 word_id |      word
---------+----------------
   65935 | bioremediation
(1 row)


What am I doing wrong??

Cheers, Buk.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]