<span style="font-family: Verdana"><pre></pre><p>Hi, <p>what's the result of <p> SELECT * from tmp_stamp where _stamp =
'2f980de9f2297c7902f3415f6537c6be';<p>?<p>Perhapsdifferent fieldtypes (f. e. VARCHAR in table www_es_orderhead_cs
versusCHAR(n) in Table _stamp filled up with blanks)?<p> <p>Ludwig<p> <p> <p>Hi,<br /><br />there is a problem with
foreignkey (PG 8.3RC2). Please, look at below. I don't understand this behavior. Why this INSERT is ending with this
errormessage. 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('n','xx.121.111.31','2f980de9f2297c7902f3415f6537c6be');<br /><br
/>ERROR:insert or update on table "www_es_orderhead_cs" violates foreign key constraint
"www_es_orderhead_cs__tmp_stamp_fkey"<br/>DETAIL: Key (_tmp_stamp)=(2f980de9f2297c7902f3415f6537c6be) is not present in
table"tmp_stamp".<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-generalmailing list (pgsql-general@postgresql.org)<br />To make changes to your subscription:<br /><a
href="/xml/deref?link=http%3A%2F%2Fwww.postgresql.org%2Fmailpref%2Fpgsql-general"
target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a></span>
