reference to inherited column in parent

From: "Rumi Szabolcs" <szrumi(at)matavnet(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: reference to inherited column in parent
Date: 2001-10-27 06:08:13
Message-ID: 200110270808130680.00D629F6@mail.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello!

i experienced the following problem with postgresql:

---8<-------------------------------------

=# create table parent (a integer unique not null);
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'parent_a_key' for table 'parent'
CREATE
=# create table child (b integer) inherits (parent);
CREATE
=# create table other (c integer references parent (a));
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE
=# insert into child values (1, 2);
INSERT 53863 1
=# insert into other values (1);
ERROR: <unnamed> referential integrity violation - key referenced from other not found in parent
=# select * from parent;
a
---
1
(1 row)

---8<-------------------------------------

i am really far from having a clue about pgsql, but this doesn't
seem to be the correct behaviour to me, i don't know whether
this is accidental or not...

Regards,

Szabolcs Rumi

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-10-27 07:05:34 Bug #492: corrupt pg_language_oid_index, (how to fix?)
Previous Message Marcelo (AdSolutions) 2001-10-26 18:34:12 Problems when inserting a very large sequence of records