| 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: | Whole Thread | Raw Message | 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
| 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 |