Am Dienstag, 27. Februar 2007 20:37 schrieb Andreas Kretschmer:
> Markus Schulz <[EMAIL PROTECTED]> schrieb:
> > > You can use pg_restore with -l to generate a listfile for all
> > > objects in the database. Then you can reorder this ($EDITOR) and
> > > then use -L to use this ordered listfile to e
Markus Schulz <[EMAIL PROTECTED]> schrieb:
> > You can use pg_restore with -l to generate a listfile for all objects
> > in the database. Then you can reorder this ($EDITOR) and then use -L
> > to use this ordered listfile to enforce the right order of objects. I
> > hope this helps you.
>
> thank
Am Dienstag, 27. Februar 2007 18:28 schrieb A. Kretschmer:
> am Tue, dem 27.02.2007, um 17:44:06 +0100 mailte Markus Schulz
folgendes:
> > Hello,
> >
> > i have some trouble with dumping and restoring a database with
> > postgresql 7.4.7-6sarge4 (debian sarge).
>
> Is the new database also 7.4? W
Markus Schulz <[EMAIL PROTECTED]> writes:
> i have some trouble with dumping and restoring a database with
> postgresql 7.4.7-6sarge4 (debian sarge).
> ...
> What can i do to enforce the order of plpgsql functions prior to all
> table structures?
Update to PG 8.x --- IIRC 8.0 was the first relea
am Tue, dem 27.02.2007, um 17:44:06 +0100 mailte Markus Schulz folgendes:
> Hello,
>
> i have some trouble with dumping and restoring a database with
> postgresql 7.4.7-6sarge4 (debian sarge).
Is the new database also 7.4? Why not 8.1 oder 8.2?
>
> Some tables have plpgsql-functions as DEFAUL
I think I see the problem, there were errors reported on the
restore. Something about a bad timestamp representation (or something
like that). You might want to look through the dump to see what
is in the dump, and if you have time try to replicate it with
new data so you can send that (assumin
