From: weigelt@metux.de
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: unique keys on inherited classes
Date: Tue, 17 Jun 2003 00:20:39 +0200
Message-ID: <20030616222039.GG14595@metux.de> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: weigelt@metux.de
Subject: Re: unique keys on inherited classes
In-Reply-To: <20030616222039.GG14595@metux.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox