Version: 7.0.2
There seems to be a problem with creating a unique constraint, like this:
bray=# CREATE TABLE supplier ( terms CHAR(2) ,ac_code CHAR(5)
UNIQUE) INHERITS (organisation);
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'supplier_ac_code_key'
for table 'supplier'
ERROR: RelationClearRelation: relation 2951924 modified while in use
but without UNIQUE:
bray=# create table supplier (terms char(2), acs_code char(5)) inherits
(organisation);
CREATE
bray=# \d organisation Table "organisation"Attribute | Type | Modifier
------------+----------+--------------------ptype | smallint | id | char(10) | not nullname | text
| not nulladdress | integer | salutation | text | default 'Dear Sir'envelope | text | email | text
| www | text | contact | char(10) | structure | char(1) | department | text | parent_id |
char(10)|
Constraints: (((department ISNULL) AND (parent_id ISNULL)) OR ((department >
''::text) AND (parent_id > ''::bpchar))) ((((structure = 'L'::bpchar) OR (structure = 'C'::bpchar)) OR
(structure = 'U'::bpchar)) OR (structure = 'O'::bpchar))
Rules: organisation_type_ins_rule, organisation_type_upd_rule
Triggers: RI_ConstraintTrigger_2950794, RI_ConstraintTrigger_2950240
bray=#
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
======================================== "The Spirit of the Lord is upon me, because he hath anointed me to
preachthe gospel to the poor; he hath sent me to heal the brokenhearted, to preach deliverance to the
captives,and recovering of sight to the blind, to set at liberty them that are bruised..." Luke 4:18