Re: [GENERAL] problem with unique text column

2006-04-27 Thread Richard Huxton
Holger Zwingmann wrote: If I check, after the reconnect, for some given 'text key' my SELECT won't find it and my procedure will thus insert a new (key,value) pair. When I disconnect and reconnect sometimes later again, I will suddenly find both of the keys with the next query and will thus raise

[GENERAL] problem with unique text column

2006-04-26 Thread Holger Zwingmann
Hi, I have a problem with table which I use to store some variables. The table holds a primary key, a text column (unique) named 'text_key' and a text colum named 'text_value'. I query and update and insert into the table via appropriate store procedures, which usually work fine. This looks then