"Oliver Elphick" wrote: >In the creation below, the column parent_id has ended up with a NOT NULL >constraint that I
didn'task 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 Oliver.Elphick@lfix.co.uk
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
