| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Problem with restoring a 7.1 dump |
| Date: | 2002-05-01 09:08:54 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOCEGFCCAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Witney | 2002-05-01 10:38:26 | Failed compile on Sun |
| Previous Message | Edward Pilipczuk | 2002-05-01 05:25:55 | Re: Bug #640: ECPG: inserting float numbers |