Re: failed to lookup type 0

Thanks both for your response. Here is a screen shot with the table definition and reproducible example:

mm=# \d signon
Table "public.signon"
Column | Type | Modifiers
---------+-----------------------+-----------
name | character varying(25) | not null
user_id | bigint | not null
passwd | character varying(30) | not null
Indexes: signon_pkey primary key btree (user_id),
signon_name_key unique btree (name)

mm=# insert into signon values ('dump',3434343,'wdp');
INSERT 256495 1
mm=# delete from signon where user_id='3434343';
ERROR: get_typdefault: failed to lookup type 0
mm=#

The version information is the following:

Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

on cygwin with Window 2000.

Tom Lane wrote

>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.

Joe Conway wrote
>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.

____________________________________________________________
Free Poetry Contest. Win $10,000. Submit your poem @ Poetry.com!
http://ad.doubleclick.net/clk;6750922;3807821;l?http://www.poetry.com/contest/contest.asp?Suite=A59101