[BUGS]

[Valery Kocubinsky]

============================================================================                         POSTGRESQL BUG REPORT TEMPLATE ============================================================================   Your name  : Valery Kocubinsky Your email address :[EMAIL PROTECTED]   System Configuration ---------------------   Architecture (example: Intel Pentium)   :Intel Pentium     Operating System (example: Linux 2.0.26 ELF)  :Linux 2.4 ELF (RedHat 7.1)     PostgreSQL version (example: PostgreSQL-7.1.3):   PostgreSQL-7.1.3     Compiler used (example:  gcc 2.95.2)  :   Please enter a FULL description of your problem: ------------------------------------------------ I have duplicate value of column in table with unique index on this column.     Please describe a way to repeat the problem.   Please try to provide a concise reproducible example, if at all possible: ----------------------------------------------------------------------   For example I have table     url ( id integer ,url varchar(256) unique,crc32 bigint); Programm insert data into url table.After I'm getting error can' insert duplicate value if I try update this table. I also can't run vacuum on this table.Vaccum write can't insert duplicate value. When I try select duplicate value      select url,count(url) from url group by url having count(url)>1; I get empty result.     I can found duplicate value only by query     select id from url where crc32 in ( select crc32,count(crc32) from url group by crc32 having count(crc32)>1);   I had this problem with other tables .     For insert row I use jdbc .   I insert rows from different connections .Different thread can write the same data in one time .     2. I had also another porblem.When I try insert,update and select data from differert thread with different connection I get SQLException "query return no result"     If you know how this problem might be fixed, list the solution below: ---------------------------------------------------------------------