Hi all,
I'm having problems restoring a dump. I get this:
You are now connected as new user chriskl.
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and
internal. Additional languages may be installed using 'createlang'.
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and
internal. Additional languages may be installed using 'createlang'.
I've done a "createlang plpgsql template1" before starting my restore, but I
just cannot get it to recognise the language.
The dump format is the complete one that first tries to drop each database
and then recreates it from scratch, so each of my databases is being dropped
and then totally recreated.
How do I get this to work?
Chris