Trouble with foreign key

Поиск
Список
Период
Сортировка
От otakarek@post.cz
Тема Trouble with foreign key
Дата
Msg-id 1849.3090-1810-1925128801-1207667558@post.cz
обсуждение исходный текст
Ответы Re: Trouble with foreign key  (Kevin Hunter <hunteke@earlham.edu>)
Re: Trouble with foreign key  (Kyle Wilcox <Kyle.Wilcox@noaa.gov>)
Список pgsql-general
Hi,

there is a problem with foreign key (PG 8.3RC2). Please, look at below. I don't understand this behavior. Why this
INSERTis ending with this error message. In my opinion, the key is obviously present. Thank you. 
--
Otakarek

# INSERT INTO www_es_orderhead_cs(_status,_tmp_ip,_tmp_stamp)
VALUES('n','xx.121.111.31','2f980de9f2297c7902f3415f6537c6be');

ERROR:  insert or update on table "www_es_orderhead_cs" violates foreign key constraint
"www_es_orderhead_cs__tmp_stamp_fkey"
DETAIL:  Key (_tmp_stamp)=(2f980de9f2297c7902f3415f6537c6be) is not present in table "tmp_stamp".

# SELECT * from tmp_stamp;
       _ip        |              _stamp              |           _expired            | _var
------------------+----------------------------------+-------------------------------+------
 xx.121.111.31/32 | 2f980de9f2297c7902f3415f6537c6be | 2008-04-08 17:49:33.193914+02 |
(1 row)

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Amiel
Дата:
Сообщение: more SSL crash woes....
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: wrong query result