Re: [GENERAL] Can't delete Null value from a not null field

2000-05-23 Thread Tom Lane
"Bryan White" <[EMAIL PROTECTED]> writes: > I get the output: > ERROR: ExecutePlan: (junk) `ctid' is NULL! > I get the same error if I try to update the null row. > At this point I figured I would outsmart it and use the oid. However it > appears the oid is null as well. Wow, that's bizarre

[GENERAL] Can't delete Null value from a not null field

2000-05-23 Thread Bryan White
I have a very simple table defined as CREATE TABLE custlist ( listid int4 NOT NULL, custid int4 NOT NULL); Somehow a record has gotten into the table with both values null. When I try to delete using delete from custlist where custid is null; or delete from custlist where