Re: pg_restore error: function plpgsql_call_handler already exists with same argument types

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_restore error: function plpgsql_call_handler already exists with same argument types
Date: 2002-12-02 19:49:45
Message-ID: NEBBLAAHGLEEPCGOBHDGCEHJGEAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> You could check this by running pg_restore with query logging
> turned on, to see what commands it's actually issuing -- or just do
> "pg_restore -s" into a text file and eyeball the generated script.

I did this, and there is a view created before the table it refers to.

> There are a lot of situations where pg_dump fails to pick a safe reload
> order at the moment (that's why pg_restore has that wild and woolly set
> of options for manual adjustment of the reload order).

So... it looks like my best option at this point is to use the -l switch to
create an archive list, reorder the list as needed, and then invoke
pg_restore with the -L switch.

The DB is pretty stable, so this wouldn't be too painful, but it seems like
given this limitation, a person with room to spare might want to do both an
older style test dump of the whole DB and an archive format dump to cover
both wholesale and piecemeal recovery scenarios in a convenient way.

Is this considered a bug, or a generally accepted limitation?

-NF

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-12-02 21:27:36 Re: [SQL] CURRENT_TIMSTAMP
Previous Message yudha 2002-12-02 19:47:15 Unable to automaticly load Postmaster.