Re: [GENERAL] Trouble with foreign key

2008-04-09 Thread Kyle Wilcox
How is your foreign key defined? From a quick look it seems the column is named "_stamp" not "_tmp_stamp" in the tmp_stamp table. [EMAIL PROTECTED] wrote: Hi, there is a problem with foreign key (PG 8.3RC2). Please, look at below. I don't understand this behavior. Why this INSERT is ending

Re: [GENERAL] Trouble with foreign key

2008-04-09 Thread ludwig
Hi, what's the result of  SELECT * from tmp_stamp where _stamp = '2f980de9f2297c7902f3415f6537c6be';?Perhaps different fieldtypes (f. e. VARCHAR in table www_es_orderhead_cs versus CHAR(n) in Table _stamp filled up with blanks)? Ludwig  Hi,there is a problem with foreign key (PG 8.3RC2). Please, lo

Re: [GENERAL] Trouble with foreign key

2008-04-09 Thread Kevin Hunter
At 11:12p -0400 on Tue, 08 Apr 2008), Otakarek wrote: > there is a problem with foreign key (PG 8.3RC2). Please, look at ^^ Before you go any further, I'd highly suggest updating. 8.3 was released over 2 months ago, and has already progressed to 8.3.1

[GENERAL] Trouble with foreign key

2008-04-09 Thread otakarek
Hi, there is a problem with foreign key (PG 8.3RC2). Please, look at below. I don't understand this behavior. Why this INSERT is 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) VAL