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
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 |
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 |