X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1A58130EC11 for ; Mon, 16 Jun 2003 22:25:35 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 41162-07 for ; Mon, 16 Jun 2003 19:25:24 -0300 (ADT) Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1]) by svr1.postgresql.org (Postfix) with ESMTP id 002A930DE85 for ; Mon, 16 Jun 2003 19:25:23 -0300 (ADT) Received: from nibiru.UUCP (uucp@localhost) by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5GMPNma017936 for pgsql-sql@postgresql.org; Tue, 17 Jun 2003 00:25:23 +0200 Received: (from weigelt@localhost) by metux.de (8.12.6/8.12.7) id h5GMKdn4006090 for pgsql-sql@postgresql.org; Tue, 17 Jun 2003 00:20:39 +0200 Date: Tue, 17 Jun 2003 00:20:39 +0200 From: weigelt@metux.de To: PGSQL-SQL Subject: unique keys on inherited classes Message-ID: <20030616222039.GG14595@metux.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.27i X-Message-Flag: Wenn dieser Text erscheint besteht enorme Virengefahr. Bitte verwenden Sie niemals Outlook oder Outlook Express. X-Archive-Number: 200306/162 X-Sequence-Number: 13920 hi folks, in many of my applications i'm deriving all classes from the base _inode, which stores general information needed for mirroring. the _inode class defines an inode_id (cluster-wide object id) and an timestamp field for the modification time. I've defined an unique index on the inode_id field of _inode. This doesn't seem to be inherited to the derived classes. The goal is to prevent double inode_id values in all _all_ derived classes. How could i achieve this ? cu -- --------------------------------------------------------------------- Enrico Weigelt == metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: contact@metux.de cellphone: +49 174 7066481 smsgate: sms.weigelt@metux.de --------------------------------------------------------------------- Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/