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

Reply via email to