Thanks for your comments,
the problem has disappeared on the 2nd restore,
but I'll keep you suggestions in mind!
On Thu, Oct 6, 2011 at 10:00 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
>> template1=# \df
>> List of functions
>> Schema | Name | Result data type | Argument data types | Type
>> --------+------+------------------+---------------------+------
>> (0 rows)
>
> That should be \dfS
>
> That the functions are in template1 is just a theory - the fact
> is that they were already defined in the database where you
> restored the dump.
>
> What is you drop and recreate the database, then run
> \dfS in a superuser psql session to make sure there is nothing there,
> then restore.