Rodríguez Rodríguez, Pere wrote:
I'm agree but pgAdmin3 could allow modify it when there aren't any rows, or if there are some row then pgAdmin3 could allow modify and then validate the new data type and the data in the table. I supouse that the second option is dificult, but is the first option possible?
Too much stuff that actually the database should do. It's not a good idea to try to simulate server side constraints on the client. It's much effort for less effect, while we still have many high-priority stuff to do.
BTW, 7.5 *does* alter column types now by sql.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
