Carol Walter wrote: > I'm moving from PostgreSQL 8.2.4 to PostgreSQL 8.3.6. When I restore > the databases from the old instance to the new one, I get a lot of > errors where the data types in keys don't match, e.g. the data type is > integer in the base file but defined as numeric in the file that it is > linked to. These are running databases so this situation must have been > negotiated by 8.2 but not my 8.3. Is this something relatively new that > I'm encountering, or is there a parameter someplace that I have set too > tightly. It's new -- some casts changed from implicit to explicit in 8.3. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
