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@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
