Hi all,
I have encountered a bug that I think is a major problem.
I have a table as follows:
CREATE TABLE registration (
registration_idint PRIMARY KEY;
course_name varchar(6) NOT NULL;
course_code varchar(6) NOT NULL;
etc...
)
Note: There is no index on course_n
"Alexei Barantsev" <[EMAIL PROTECTED]> writes:
> UPDATE buggy SET field1 = field1+1;
> psql:/home/barancev/tmp/pg_bug.sql:17: ERROR: Cannot insert a duplicate key
> into unique index buggy_field1_key
Unfortunately, that's never worked, as our unique constraints are tested
immediately not at end
Hi!
I have found that some of my queries stop working after upgrade from 7.0 to
7.1.3.
Some investigation show that UPDATE queries grow to crash.
Here is my SQL code that produces error (it is supposed to be in pg_bug.sql
file):
--
\connect template1 postgres
CREATE DATABASE "pg_bug
