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/
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 |