| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> | 
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org | 
| Subject: | Recent RI changes have broken something | 
| Date: | 2000-01-31 22:18:19 | 
| Message-ID: | 200001312218.WAA32035@linda.lfix.co.uk | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Does anyone know what is happening here?  There is no other user; the
CREATE TABLE is part of a much larger script that was working OK last
Thursday.  The script drops and recreates an entire database.
bray=# \d country
        Table "country"
 Attribute |  Type   | Modifier 
-----------+---------+----------
 id        | char(2) | not null
 name      | text    | not null
 region    | text    | 
 telcode   | text    | 
Index: country_pkey
Constraint: (id ~ '[A-Z]{2}'::text)
bray=# create table country_ccy
(
   country     char(2)     references country (id) match full,
   ccy      char(3)     references currency (symbol) match full,
   primary key (country, ccy)
)
;
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'country_ccy_pkey'
for table 'country_ccy'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  RelationClearRelation: relation 21645 modified while in use
bray=# select relname from pg_class where oid = 21645;
 relname 
---------
 country
(1 row)
country was referenced in a previous table's foreign key.  In view of
the notes on RelationClearRelation, I am wondering if refcount wasn't 
decremented after that table was created.
-- 
Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "My son, if sinners entice thee, consent thou not."    
                            Proverbs 1:10 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Timothy Dyck | 2000-01-31 22:29:05 | request for tuning suggestions from PC Week Labs | 
| Previous Message | The Hermit Hacker | 2000-01-31 21:41:35 | PClabs Survey, Part I: Administration (resend) |