Thread: Not a real bug, but an error

Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community.
I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases to a
file in plain text form and then trend to restore using 'psql -f'.
But there was an error: a function needed in a constraint of a table was
placed after the table definition! So it was impossible to create the
table!
It was just a matter to edit the file and cut and copy the function
definition in the right place, drop the database and run the file again,
but it could be a good idea to find a workaround. Actually, I had to dump
the schema and data separately, as one file was to big to manage, but it
was just a matter of confort.
Thank for the great work.
Postgresql is really a wonderfull thing.
Andrea from Italy

Christopher Kings-Lynne has made pg_dump and pg_dumpall much more
reliable in this respect for 8.0.

=D0=92 =D0=A7=D1=82=D0=B2, 28.10.2004, =D0=B2 16:46, Andrea D. =D0=BF=D0=B8=
=D1=88=D0=B5=D1=82:
> Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community.
> I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases t=
o a
> file in plain text form and then trend to restore using 'psql -f'.
> But there was an error: a function needed in a constraint of a table was
> placed after the table definition! So it was impossible to create the
> table!
> It was just a matter to edit the file and cut and copy the function
> definition in the right place, drop the database and run the file again,
> but it could be a good idea to find a workaround. Actually, I had to dump
> the schema and data separately, as one file was to big to manage, but it
> was just a matter of confort.
> Thank for the great work.
> Postgresql is really a wonderfull thing.
> Andrea from Italy
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--=20
Markus Bertheau <twanger@bluetwanger.de>

Andrea D. wrote:
> Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community.
> I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases to a
> file in plain text form and then trend to restore using 'psql -f'.
> But there was an error: a function needed in a constraint of a table was
> placed after the table definition! So it was impossible to create the
> table!
> It was just a matter to edit the file and cut and copy the function
> definition in the right place, drop the database and run the file again,
> but it could be a good idea to find a workaround. Actually, I had to dump
> the schema and data separately, as one file was to big to manage, but it
> was just a matter of confort.
> Thank for the great work.
> Postgresql is really a wonderfull thing.
> Andrea from Italy

pg_dump 8.0 will work better. However is not a good idea dump the schema and
the data in separate files, for example you'll miss the FK creation delayed after the
data load.



Regards
Gaetano Mendola