=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
POSTGRESQL BUG REPORT TEMPLATE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
Your name : Valery Kocubinsky
Your email address :kocubinsky@yahoo.com
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:=20
----------------------------------------------------------------------
For example I have table=20
url ( id integer ,url varchar(256) unique,crc32 bigint);
Programm insert data into url table.After I'm getting error can' insert dup=
licate value if I try update this table.
I also can't run vacuum on this table.Vaccum write can't insert duplicate v=
alue.
When I try select duplicate value=20
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 sa=
me 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:
---------------------------------------------------------------------
