7.1beta4 bug creating a certain table

From: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: 7.1beta4 bug creating a certain table
Date: 2001-01-29 21:07:15
Message-ID: Pine.LNX.4.21.0101292205450.1541-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

I cannot create a certain table in 7.1beta4. With 7.0.2 there was not any
problem.

------------------------------------------------------------------------------
CREATE TABLE pakolas_cikktetel (
pakolas int4 not null,
cikk int4 not null,
minoseg int4 not null,
sorszam int4 check (sorszam > 0),
helyrol int4,
helyre int4,
mennyi numeric(14,4) not null ,
lezarva bool default 'f',
primary key (pakolas, cikk, minoseg, sorszam),
unique (pakolas, cikk, minoseg, helyrol, helyre));

CREATE TABLE keszlet_bevetel (
keszletnovekedes int4 not null primary key,
pakolas int4 not null,
cikk int4 not null,
minoseg int4 NOT NULL,
foreign key (pakolas, cikk, minoseg)
references pakolas_cikktetel(pakolas, cikk, minoseg));
------------------------------------------------------------------------------

Here I get the following error:

ERROR: UNIQUE constraint matching given keys for referenced table
"pakolas_cikktetel" not found

(The second table will not be created.)

By the way, is it possible generating patches between beta releases and
putting on the ftp server?

TIA, Zoltan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-01-29 21:54:52 Book enters second printing
Previous Message Bruce Momjian 2001-01-29 21:04:33 Re: Open 7.1 items

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-29 22:32:52 Re: 7.1beta4 bug creating a certain table
Previous Message Stef Telford 2001-01-29 20:00:50 Archival of Live database to Historical database