Date: Wed, 5 Jan 2005 05:29:29 -0800 (PST)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: "=?iso-8859-2?Q?BARTKO,_Zolt=E1n?=" <bartko.zoltan@pobox.sk>
Cc: pgsql-sql@postgresql.org
Subject: Re: foreign key problems
In-Reply-To: <200501050930.j059U27s019437@www7.pobox.sk>
Message-ID: <20050105052001.T60967@megazone.bigpanda.com>
References: <200501050930.j059U27s019437@www7.pobox.sk>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=iso-8859-2
Content-Transfer-Encoding: QUOTED-PRINTABLE


On Wed, 5 Jan 2005, [iso-8859-2] BARTKO, Zolt=E1n wrote:

> Ok, so I made some changes (manual "inheritance" of PK and FK
> constraints), but nevertheless I get still the same dumb error. I made
> a dump of the DB via pg_dump, it is available at
>
> http://de.geocities.com/bartkozo/dump.tgz
>
> DRecord was dropped, the columns moved into DObject. I still have no
> idea why foreign keys work on other tables and do not on this one.
>
> I have three users, superaspiramus, aspiramus and aspiramusadmin. The
> first is the owner of the db.
>
> After loading, the contents of the DObject table are:
>
> aspiramus=3D> select * from DObject;

Do select * from ONLY DObject.

The constraint currently only goes to DObject, records that are actually
in DObject and not any tables derived from it. This is one of the
deficiencies I was trying to refer to in the previous message. As a note,
your primary keys will also not work to prevent duplicates of objectid
between subclasses of DObject currently, and I'm not sure whether that
matters to you:

insert into dmessage (who, privilege, objectid, objecttype, status,
aname,sender,receiver) values (-2,-2,33,13,301,'name',-2,-2);

select objectid from dobject;
 objectid
----------
       34
       35
       33
       33
(4 rows)

Inheritance needs alot of work. :(