Re: Trouble with foreign key

<span style="font-family: Verdana"><pre><p>Hi,&nbsp;</p><p>what&#39;s the result of </p><p>&nbsp;SELECT * from tmp_stamp where _stamp = &#39;2f980de9f2297c7902f3415f6537c6be&#39;;</p><p>?</p><p>Perhaps different fieldtypes (f. e. VARCHAR in table www_es_orderhead_cs versus CHAR(n) in Table _stamp filled up with blanks)?</p><p>&nbsp;</p><p>Ludwig</p><p>&nbsp;</p><p>&nbsp;</p><p>Hi,<br /><br />there is a problem with foreign key (PG 8.3RC2). Please, look at below. I don&#39;t understand this behavior. Why this INSERT is ending with this error message. In my opinion, the key is obviously present. Thank you.<br />--<br />Otakarek<br /><br /># INSERT INTO www_es_orderhead_cs(_status,_tmp_ip,_tmp_stamp) VALUES(&#39;n&#39;,&#39;xx.121.111.31&#39;,&#39;2f980de9f2297c7902f3415f6537c6be&#39;);<br
/><br />ERROR: insert or update on table &quot;www_es_orderhead_cs&quot; violates foreign key constraint &quot;www_es_orderhead_cs__tmp_stamp_fkey&quot;<br />DETAIL: Key (_tmp_stamp)=(2f980de9f2297c7902f3415f6537c6be) is not present in table &quot;tmp_stamp&quot;.<br /><br /># SELECT * from tmp_stamp;<br /> _ip | _stamp | _expired | _var<br />------------------+----------------------------------+-------------------------------+------<br /> xx.121.111.31/32 | 2f980de9f2297c7902f3415f6537c6be | 2008-04-08 17:49:33.193914+02 |<br />(1 row)<br /><br />-- <br />Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)<br />To make changes to your subscription:<br /><a target="_blank"
href="/xml/deref?link=http%3A%2F%2Fwww.postgresql.org%2Fmailpref%2Fpgsql-general">http://www.postgresql.org/mailpref/pgsql-general</a></p></pre></span>