Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f15Hbtx39505 for ; Mon, 5 Feb 2001 12:37:55 -0500 (EST) (envelope-from pgsql-hackers-owner@postgresql.org) Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0TLWRq36152; Mon, 29 Jan 2001 16:32:27 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@ll20.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id UAA26080; Mon, 29 Jan 2001 20:25:36 GMT Message-ID: <3A7733E6.E02FCF22@mondo-live.com> Date: Tue, 30 Jan 2001 16:36:38 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: Kovacs Zoltan CC: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] 7.1beta4 bug creating a certain table References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/100 X-Sequence-Number: 4221 Hi, I ran the same code on 7.1beta 3 and it works... I don't have beta4 installed... newdb=# CREATE TABLE pakolas_cikktetel ( newdb(# pakolas int4 not null, newdb(# cikk int4 not null, newdb(# minoseg int4 not null, newdb(# sorszam int4 check (sorszam > 0), newdb(# helyrol int4, newdb(# helyre int4, newdb(# mennyi numeric(14,4) not null , newdb(# lezarva bool default 'f', newdb(# primary key (pakolas, cikk, minoseg, sorszam), newdb(# unique (pakolas, cikk, minoseg, helyrol, helyre)); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'pakolas_cikktetel_pkey' for table 'pakolas_cikktetel' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'pakolas_cikktetel_pakolas_key' for table 'pakolas_cikktetel' CREATE Najm Kovacs Zoltan wrote: > 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