If you do set it to NOT NULL when there are NULL values present, the only sane choice would be to immediate populate those NULL values. Again, if you use triggers, sequences, or rules, see the important note below. When we rename this table, the sequence won't be renamed with it. Triggers, rules, and views T hese are more of a problem. If you're really paranoid, you can diff the two files to see if they are the same.
Additional submissions are welcome.
The more detail the better. Whilst this information is accurate to the best of my knowledge, some things may work differently for you and neither I nor any member of the PostgreSQL community can be held responsible for any losses or damage which may occur.