Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..." - Mailing list pgsql-hackers

From Ryan Murphy
Subject Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..."
Date
Msg-id CAHeEsBcAeOFjpxdNRQ9aB+e0nTEFBJfRUW-ctKXCw=06Kirx=g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Adding type info etc for inheritance errmsg: "child table is missing column ..."  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..."  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers

No, and TBH I would vote strongly against including that much detail in
this error message anyway.  That info could be indefinitely long, and it's
not especially relevant to the stated error condition --- for example, the
presence of a default is *not* relevant to whether the column matches the
parent.  I'm okay with shoehorning column type into this message, but not
much more than that.

                        regards, tom lane

Ok, that makes sense.  How about things like NOT NULL? you get an error if your column doesn't have that.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Adding type info etc for inheritance errmsg: "child table is missing column ..."
Next
From: Vik Fearing
Date:
Subject: Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..."