[GENERAL] Trouble with foreign key
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)
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)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Trouble with foreign key
Hi,whats 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)?LudwigHi,there is a problem with foreign key (PG 8.3RC2). Please, look at below. I dont 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) 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_fkeyDETAIL: 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)-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Trouble with foreign key
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. Upgrade, check the release notes, then see what's up. Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Trouble with foreign key
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 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)
--
Kyle Wilcox
NOAA Chesapeake Bay Office
410 Severn Avenue
Suite 107A
Annapolis, MD 21403
office: (410) 295-3151
[EMAIL PROTECTED]
A: It takes over twice as long to understand the conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the worst thing about plain text email discussions?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
