| Lists: | pgsql-bugs |
|---|
| From: | "Vernon Smith" <vwu98034(at)lycos(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | failed to lookup type 0 |
| Date: | 2003-11-29 16:34:01 |
| Message-ID: | LFHEPIKMLAAHHEAA@mailcity.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
When I try to delete data from one table, I get this error:
ERROR: get_typdefault: failed to lookup type 0
I can't find any reasons other than a bug. The PG version is 7.3.4
____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | vwu98034(at)lycos(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: failed to lookup type 0 |
| Date: | 2003-11-29 17:13:50 |
| Message-ID: | 3FC8D3CE.9010307@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Vernon Smith wrote:
> When I try to delete data from one table, I get this error:
>
> ERROR: get_typdefault: failed to lookup type 0
>
> I can't find any reasons other than a bug. The PG version is 7.3.4
And neither can we without some details.
Please post the results of
\d tablename
, the definitions of any trigger functions (particularly any "on delete"
triggers), and if possible a complete reproducible example.
Joe
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | vwu98034(at)lycos(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: failed to lookup type 0 |
| Date: | 2003-11-29 17:20:32 |
| Message-ID: | 7681.1070126432@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Vernon Smith" <vwu98034(at)lycos(dot)com> writes:
> When I try to delete data from one table, I get this error:
> ERROR: get_typdefault: failed to lookup type 0
> I can't find any reasons other than a bug. The PG version is 7.3.4
You'll need to provide a self-contained test case.
We've seen bugs with similar symptoms associated with dropped columns,
but AFAIK they are all fixed in 7.3.4.
regards, tom lane