"Oliver Elphick" wrote: >In the creation below, the column parent_id has ended up with a NOT NULL >constraint that I didn't ask for and don't want. If I change the order of the columns, the NOT NULL constraint always ends up on the last column. This is not the only table to be affected. Every table that is affected has the last column incorrectly set to NOT NULL. Every such table is inherited; however, not every inherited table is affected. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "The fear of the LORD is the instruction of wisdom, and before honour is humility." Proverbs 15:33
