Re: Upgrade function problem - c language

I am trying to upgrade from postgres 7.3.2 to 7.4.1
I use backups created by 7.3.2 pg_dump.
When I run pg_restore (v. 7.4.1) as a superuser and it throws "ERROR:
permission denied for language c"
Below is the installation trace.

Thanks.

Oleg

TRACE:
[postgres(at)twebspec webspectest]$ dropdb -U postgres webspectest

DROP DATABASE

[postgres(at)twebspec webspectest]$ createdb -T template0 -U postgres

webspectest

CREATE DATABASE

[postgres(at)twebspec webspectest]$ pg_restore -v -o -F c -U postgres -d
webspectest
/home/postgres/dbs/backup/02_04/webspec_cron_2004-02-09.bac.tar

pg_restore: connecting to database for restore

pg_restore: executing <Init> Max OID

pg_restore: creating FUNCTION char (integer)

pg_restore: creating FUNCTION concat (text, text)

pg_restore: creating FUNCTION insert (text, integer, integer, text)

pg_restore: creating FUNCTION lcase (text)

pg_restore: creating FUNCTION left (text, integer)

pg_restore: creating FUNCTION locate (text, text)

pg_restore: creating FUNCTION locate (text, text, integer)

pg_restore: creating FUNCTION right (text, integer)

pg_restore: creating FUNCTION space (integer)

pg_restore: creating FUNCTION ucase (text)

pg_restore: creating FUNCTION ceiling (numeric)

pg_restore: creating FUNCTION log10 (double precision)

pg_restore: creating FUNCTION log10 (numeric)

pg_restore: creating FUNCTION power (double precision, double precision)

pg_restore: creating FUNCTION power (numeric, numeric)

pg_restore: creating FUNCTION rand ()

pg_restore: creating FUNCTION rand (double precision)

pg_restore: creating FUNCTION truncate (numeric, integer)

pg_restore: creating FUNCTION curdate ()

pg_restore: creating FUNCTION curtime ()

pg_restore: creating FUNCTION odbc_timestamp ()

pg_restore: creating FUNCTION dayname (timestamp without time zone)

pg_restore: creating FUNCTION dayofmonth (timestamp without time zone)

pg_restore: creating FUNCTION dayofweek (timestamp without time zone)

pg_restore: creating FUNCTION dayofyear (timestamp without time zone)

pg_restore: creating FUNCTION hour (timestamp without time zone)

pg_restore: creating FUNCTION minute (timestamp without time zone)

pg_restore: creating FUNCTION month (timestamp without time zone)

pg_restore: creating FUNCTION monthname (timestamp without time zone)

pg_restore: creating FUNCTION quarter (timestamp without time zone)

pg_restore: creating FUNCTION second (timestamp without time zone)

pg_restore: creating FUNCTION week (timestamp without time zone)

pg_restore: creating FUNCTION year (timestamp without time zone)

pg_restore: creating FUNCTION odbc_user ()

pg_restore: creating FUNCTION odbc_current_user ()

pg_restore: creating FUNCTION odbc_session_user ()

pg_restore: creating SCHEMA temp

pg_restore: creating FUNCTION plpgsql_call_handler ()

pg_restore: [archiver (db)] could not execute query: ERROR: permission
denied for language c

pg_restore: *** aborted because of error

*************************************
This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.
*************************************