On 10/16/05, Dave Johnson <[EMAIL PROTECTED]> wrote: > > Here's my theory. We changed the weblog entry pubtime into a date field > rather than a timestamp and I bet we didn't test against PostgreSQL (I > know I didn't). > > According to the docs below, we need to do the temp table trick if we > want to change a column type in PostgreSQL: > > http://techdocs.postgresql.org/techdocs/updatingcolumns.php
This was against a fresh database. Assuming the above means the migration scripts. I'll test converting a 1.3 database to 2.0 in postgres. > Then, we may have data type issues. I hope PostgreSQL has a compatible > DATETIME field. Will see what I can find out. Hen
