Re: [HACKERS] Problem with restoring a 7.1 dump

2002-05-01 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > 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 templa

Re: [HACKERS] Problem with restoring a 7.1 dump

2002-05-01 Thread Magnus Naeslund(f)
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: [snap] > How do I get this to work? > > Chris I think i did this: CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' H