Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.1 (current) unwanted NOT NULL constraint inserted - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.1 (current) unwanted NOT NULL constraint inserted
Date
Msg-id 13536.976912914@sss.pgh.pa.us
Whole thread Raw
In response to 7.1 (current) unwanted NOT NULL constraint inserted  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Idea for reducing planning time
Next
From: Tom Lane
Date:
Subject: Cleaning up backend-exit cleanup