Thanks so much. That's what I needed to know. I'm going to have to
make some modifications to my script so that it reports what databases
it's loading, and take steps to change the data types or, at least,
hold them out.
Carol
On Mar 13, 2009, at 11:13 AM, Alvaro Herrera wrote:
> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin