Re: [HACKERS] Problem with foreign keys and inheritance

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-hackers(at)postgreSQL(dot)org, olly(at)linda(dot)lfix(dot)co(dot)uk
Subject: Re: [HACKERS] Problem with foreign keys and inheritance
Date: 2000-01-15 21:44:42
Message-ID: 200001152144.VAA06452@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Oliver Elphick" wrote:
>When I create a table that inherits from another table that uses foreign
>keys, I get something like this:
>
> ERROR: cache lookup of attribute 10 in relation 124171 failed
>
>This is happening in get_attribute_name() of backend/utils/adt/ruleutils.c

I'm still trying to track this down; it seems to be happening when the
backend is trying to fetch details of the ancestor class, in
deparse_expression().

However, I cannot find relation 124171; is there any way to find out
where a relation is, given only its oid?

--
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
========================================
"For I know that my redeemer liveth, and that he shall
stand at the latter day upon the earth"
Job 19:25

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Mascari 2000-01-15 22:17:21 INDEX_MAX_KEYS and pg_dump
Previous Message Don Baccus 2000-01-15 19:55:00 Re: [HACKERS] TODO list