unique keys on inherited classes

From: weigelt(at)metux(dot)de
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: unique keys on inherited classes
Date: 2003-06-16 22:20:39
Message-ID: 20030616222039.GG14595@metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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(at)metux(dot)de
cellphone: +49 174 7066481 smsgate: sms(dot)weigelt(at)metux(dot)de
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2003-06-16 23:35:59 Re: [HACKERS] Our FLOAT(p) precision does not conform to spec
Previous Message Tom Lane 2003-06-16 22:15:46 Our FLOAT(p) precision does not conform to spec