X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 355E3D1B44B for ; Sat, 20 Dec 2003 00:01:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96079-08 for ; Fri, 19 Dec 2003 20:00:52 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CAC83D1B46B for ; Fri, 19 Dec 2003 20:00:47 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hBK00dU6004349 for ; Sat, 20 Dec 2003 00:00:39 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hBJNu3Wv096616 for pgsql-sql@postgresql.org; Fri, 19 Dec 2003 23:56:03 GMT Date: Sat, 20 Dec 2003 00:51:03 +0100 From: Pedro User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031127 Thunderbird/0.4a X-Accept-Language: en-us, en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.sql Subject: Re: INHERITS and Foreign keys References: <6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no> In-Reply-To: <6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 14 Message-ID: <3fe39013$0$6978$7a628cd7@news.club-internet.fr> Organization: Club-Internet / T-Online France X-Complaints-To: abuse@club-internet.fr To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/152 X-Sequence-Number: 16318 >> Foreign keys, unique and primary key constraints do not meaningfully >> inherit currently. At some point in the future, that's likely to change, >> but for now you're pretty much stuck with workarounds (for example, using >> a separate table to store the ids and triggers/rules on each of the >> tables >> in the hierarchy in order to keep the id table in date.) hi same problem here on 7.4 can we vote for this bug somewhere ?! thanks for your time Pedro