L.S. I was afraid something like this would happen ;) Just to be clear on the matter, the wrong post was just part of a conversation between the OP and I. We are not exactly strangers and there was no intentional nor accidential bad advice intended ;) For the record I'll repeat on the list that the OP should also note the mailinglist archive on the matter (both the column position in a select as well as fiddling with attnum), since the original discussion has been one that repeated periodically. > Just to avoid anyone getting strange ideas: editting the catalog > manually has a 100% certainty of trashing any data in the table. Well, a good chance, anyway ;) > Also various things like indexes and foreign keys may use the attnum also > and become non-functional Absolutely true. > It's entirely possible that on an empty table with nothing attached that > changing attnum manually might work, but I wouldn't bet on it. Me neither, since I haven't tried that in a while too (the OP was already aware of this). Anyway, it's just a good thing people are paying attention around here ;) -- Best, Frank.
