NULL value errors at migrating from Postgres 8.2.5 to 8.3.3

Classic Servoy
1

Hi

When reading back a postgresql.dump file from a PostgreSQL 8.2.5 version into a newly created PostgreSQL 8.3.3 database, I get errors about NULL values (“\N” seen in data file) I have not seen before.

The cmd I use:
/usr/local/pgsql/bin/psql -U trackit -d TrackIT -f /Users/admin/Desktop/postgresql.dump

The error as in the attachement psql error.png and data in the postgresql.dump data.png.

Has anyone made the same experience with Version 8.3.3?

Best regards, Robert

postgresql.dump data.png
postgresql.dump data.png786×323 25.4 KB

psql error.png
psql error.png1065×783 58.3 KB

2

Hi Robert,

I have migrated 8.2.x schema and data to 8.3.x like that before and haven’t seen those errors.
Are you sure the column(s) for those null values do in fact allow null values ?
Seems that the tables were already there (looking at the previous errors).

3

Hi Robert

Thanks for the feedback, I did not resolve it up to now, but may be it has something to do with the PostGIS part. The tables are already there as they are generated by the model (EOModel or Entity Modeler, which I’m still trying to install into Servoy Eclipse). Do you know of a way to supress the cretion of tables when reading back in a dump file with psql? That would be nice.

Thanks and regards, Robert

ROCLASI:
Hi Robert,

I have migrated 8.2.x schema and data to 8.3.x like that before and haven’t seen those errors.
Are you sure the column(s) for those null values do in fact allow null values ?
Seems that the tables were already there (looking at the previous errors).