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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
