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