Re: 7.1 (current) unwanted NOT NULL constraint inserted

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 7.1 (current) unwanted NOT NULL constraint inserted
Date: 2000-12-15 20:41:54
Message-ID: 13536.976912914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I can't reproduce this --- I get

Constraints: ((ptype >= 0) AND (ptype <= 8))
((((structure = 'L'::bpchar) OR (structure = 'C'::bpchar)) OR (structure = 'U'::bpchar)) OR (structure = 'O'::bpchar))
(((department ISNULL) AND (parent_id ISNULL)) OR ((department > ''::text) AND (parent_id > ''::bpchar)))
(((ptype >= 2) AND (ptype <= 4)) OR (ptype = 8))

However, I had to guess about the referenced tables, and possibly I
guessed wrong. Could you supply their declarations too?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2000-12-15 20:57:39 Re: RPM changes for 7.1.
Previous Message Mikheev, Vadim 2000-12-15 20:21:03 RE: Idea for reducing planning time