X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 700503A3B22 for ; Tue, 4 Jan 2005 12:14:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74350-01 for ; Tue, 4 Jan 2005 12:14:08 +0000 (GMT) Received: from www7.pobox.sk (www7.pobox.sk [212.5.216.17]) by svr1.postgresql.org (Postfix) with ESMTP id 93CCE3A3C42 for ; Tue, 4 Jan 2005 12:14:09 +0000 (GMT) Received: from www7.pobox.sk (www7.pobox.sk [212.5.216.17]) by www7.pobox.sk (8.12.9-20030917/8.12.9) with SMTP id j04CFe7s017600 for ; Tue, 4 Jan 2005 13:15:40 +0100 Date: Tue, 4 Jan 2005 13:15:40 +0100 Message-Id: <200501041215.j04CFe7s017600@www7.pobox.sk> From: "=?iso-8859-2?Q?BARTKO,_Zolt=E1n?=" Reply-To: "=?iso-8859-2?Q?BARTKO,_Zolt=E1n?=" Subject: foreign key problems To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: MULTIPART/mixed; charset=iso-8859-2; BOUNDARY="97784280-1804289383-1104840940=:17598" Content-Transfer-Encoding: 8BIT X-Pobox-Id: 3955839445 X-User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; sk-SK; rv:1.7.2) Gecko/20040803 X-Mailer: POBOX (mico's engine 5.0/4.0.1) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=MIME_BASE64_TEXT X-Spam-Level: X-Archive-Number: 200501/8 X-Sequence-Number: 19796 --97784280-1804289383-1104840940=:17598 Content-Type: TEXT/plain; CHARSET=US-ASCII Content-Transfer-Encoding: QUOTED-PRINTABLE Dear all, I have a problem: if I create the tables that are in the attached file, I can't insert rows into the AAttachment table, even though the rows in DObject with the given primary key exist (PgSQL 8.0 rc1 complains about (ownerid)=3D(insert the number here) not available in DObject. The same happens with attribute bodyid). I have noticed that this behavior is different, if I do not use inherited tables, e.g. if I use create table A ( a integer references B(b), b integer references B(b)); create table B (b serial primary key); insert into B values (1); insert into B values (2); insert into A (a,b) values (1,2); works flawlessly. Is this a feature or a bug or is the problem in front of the computer? thanks Zoltan =0A____________________________________=0ARAMMSTEIN, 22.02.2005 o 20,00, Br= atislava Incheba, =0AInfo: 0904 666 363, http://www.xl.sk =0A --97784280-1804289383-1104840940=:17598 Content-Type: TEXT/plain; name="tables.txt" Content-Transfer-Encoding: BASE64 CmNyZWF0ZSB0YWJsZSBBQXNzb2NpYXRpb24gKAoJY3JlYXRlZEJ5CWludGVn ZXIsCQkJCQktLSogdGhlIGNyZWF0b3Igb2YgdGhlIGFzc29jaWF0aW9uCglj cmVhdGlvbgl0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgZGVmYXVsdCAnbm93 JwkJLS0qIGNyZWF0aW9uIHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZQopOwoK Y3JlYXRlIHRhYmxlIEFPYmpBc3NvY2lhdGlvbiAoCglwcml2aWxlZ2UJaW50 ZWdlciBub3QgbnVsbCByZWZlcmVuY2VzIFN5c1ByaXZpbGVnZShwcml2aWxl Z2UpLAoJCQktLSogdGhlIHByaXZpbGVnZSB1c2VkIHRvIGNyZWF0ZSB0aGUg YXNzb2NpYXRpb24KCWluc3RlYWRPZglpbnRlZ2VyIHJlZmVyZW5jZXMgRFBl cnNvbihwZXJzb24pCgkJCS0tKiBpbnN0ZWFkIG9mIHdob20gaXMgdGhlIGFj dGlvbiB0YWtlbgopIGluaGVyaXRzIChBQXNzb2NpYXRpb24pOwoKY3JlYXRl IHRhYmxlIEFBdHRhY2htZW50ICgKCW93bmVySUQJYmlnaW50IHJlZmVyZW5j ZXMgRE9iamVjdChvYmplY3QpLAktLSogb3duZXIgb2JqZWN0Cglib2R5SUQJ YmlnaW50IHJlZmVyZW5jZXMgRE9iamVjdChvYmplY3QpCS0tKiBhdHRhY2hl ZCBvYmplY3QKKSBpbmhlcml0cyAoQU9iakFzc29jaWF0aW9uKTsKCmNyZWF0 ZSB0YWJsZSBEUGVyc29uICgKCXBlcnNvbgkJc2VyaWFsIHByaW1hcnkga2V5 LAktLSogcGVyc29uIHJvdyBpZCMKCWxvZ2luCQl2YXJjaGFyKDE2KSBub3Qg bnVsbCB1bmlxdWUsCS0tKiBsb2dpbiBuYW1lCglwYXNzd2QJCXZhcmNoYXIo MTYpIG5vdCBudWxsLAktLSogcGFzc3dvcmQKCWFuYW1lCQl2YXJjaGFyIG5v dCBudWxsLAktLSogbmFtZSAKCXN1cm5hbWUJCXZhcmNoYXIgbm90IG51bGws CS0tKiBzdXJuYW1lCglpc0FkbWluCQlib29sZWFuIGRlZmF1bHQgZmFsc2Us CS0tKiBpcyB0aGUgcGVyc29uIGFuIGFkbWluPwoJdW5pcXVlIChhbmFtZSwg c3VybmFtZSkKKSBpbmhlcml0cyAoRE9yZ0VudGl0eSk7CgpjcmVhdGUgdGFi bGUgRE9yZ0VudGl0eSAoCgl3aG8JCWludGVnZXIgbm90IG51bGwsCQkJLS0q IHJlY29yZCBhdXRob3IKCWNyZWF0ZWRBdAl0aW1lc3RhbXAgd2l0aCB0aW1l IHpvbmUgZGVmYXVsdCAnbm93JywJLS0qIGNyZWF0aW9uIHRpbWVzdGFtcCB3 aXRoIHRpbWUgem9uZQoJaXNBY3RpdmUJYm9vbGVhbiBkZWZhdWx0IHRydWUJ CQktLSogaXMgdGhlIGVudGl0eSBhY3RpdmU/Cik7CgpjcmVhdGUgdGFibGUg U3lzT2JqVHlwZXMgKAoJb2JqZWN0VHlwZQlpbnRlZ2VyIHVuaXF1ZSBub3Qg bnVsbCBwcmltYXJ5IGtleSwJLS0qIG9iamVjdCB0eXBlCglhbmFtZQkJdGV4 dCwJCQkJCS0tKiBuYW1lCglpc0F0dGFjaG1lbnQJYm9vbGVhbiwJCQkJLS0q IGlzIGF0dGFjaG1lbnQgb2Ygb3RoZXIgb2JqZWN0cwoJaGFzQXR0YWNobWVu dAlib29sZWFuCQkJCQktLSogaGFzIGF0dGFjaG1lbnRzCik7CgpjcmVhdGUg dGFibGUgU3lzU3RhdHVzICgKCXN0YXR1cwkJaW50ZWdlciB1bmlxdWUgbm90 IG51bGwgcHJpbWFyeSBrZXksCS0tKiBpZCMKCWFkZEF0dGFjaG1lbnQJYm9v bGVhbiwJCQkJLS0qIGFsbG93IGFkZGluZyBuZXcgYXR0YWNobWVudHMKCWRy b3BBdHRhY2htZW50CWJvb2xlYW4sCQkJCS0tKiBhbGxvdyBkcm9wcGluZyBl eGlzdGluZyBhdHRhY2htZW50cwoJYW5hbWUJCXRleHQgbm90IG51bGwsCQkJ CS0tKiBzdGF0dXMgbmFtZQoJZGVzY3JpcHRpb24JdGV4dAkJCQkJLS0qIHN0 YXR1cyBkZXNjcmlwdGlvbgopOwoKY3JlYXRlIHRhYmxlIERPYmplY3QgKAoJ b2JqZWN0CQliaWdzZXJpYWwgcHJpbWFyeSBrZXksCQktLSogaWQjCglyZXZp c2lvbglpbnRlZ2VyIG5vdCBudWxsIGRlZmF1bHQgMCwJLS0qIG9yZGluYWwg bnVtYmVyIG9mIHRoZSBjb21taXRlZCBjaGFuZ2UKCWFuYW1lCQl0ZXh0IG5v dCBudWxsLAkJCS0tKiBvYmplY3QgbmFtZQoJZGVzY3JpcHRpb24JdGV4dCBk ZWZhdWx0ICcnLAkJLS0qIG9iamVjdCBkZXNjcmlwdGlvbgoJb2JqZWN0VHlw ZQlpbnRlZ2VyIG5vdCBudWxsIHJlZmVyZW5jZXMgU3lzT2JqVHlwZXMob2Jq ZWN0VHlwZSksCgkJCQkJCQktLSogdGhlIG9iamVjdCB0eXBlCglzdGF0dXMJ CWludGVnZXIgbm90IG51bGwgcmVmZXJlbmNlcyBTeXNTdGF0dXMoc3RhdHVz KSwKCQkJCQkJCS0tKiB0aGUgb2JqZWN0IHN0YXR1cwoJdW5pcXVlIChhbmFt ZSwgZGVzY3JpcHRpb24sIG9iamVjdFR5cGUpCikgaW5oZXJpdHMgKERSZWNv cmQpOwoKY3JlYXRlIHRhYmxlIFN5c1ByaXZpbGVnZSAoCglwcml2aWxlZ2UJ aW50ZWdlciB1bmlxdWUgbm90IG51bGwgcHJpbWFyeSBrZXksCS0tKiBpZCMK CWFuYW1lCQl0ZXh0IG5vdCBudWxsLAkJCQktLSogcHJpdmlsZWdlIG5hbWUK CWRlc2NyaXB0aW9uCXRleHQgCQkJCQktLSogcHJpdmlsZWdlIGRlc2NyaXB0 aW9uCik7Cg== --97784280-1804289383-1104840940=:17598--