7.1beta4 bug creating a certain table

Поиск
Список
Период
Сортировка
От Kovacs Zoltan
Тема 7.1beta4 bug creating a certain table
Дата
Msg-id Pine.LNX.4.21.0101292205450.1541-100000@pc10.radnoti-szeged.sulinet.hu
обсуждение исходный текст
Ответы Re: [HACKERS] 7.1beta4 bug creating a certain table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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',
primarykey (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



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Stef Telford"
Дата:
Сообщение: Archival of Live database to Historical database
Следующее
От: Najm Hashmi
Дата:
Сообщение: Re: 7.1beta4 bug creating a certain table