Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group