Re: Upgrade function problem - c language - Mailing list pgsql-general

[postgres@twebspec webspectest]$ dropdb -U postgres webspectest

DROP DATABASE

[postgres@twebspec webspectest]$ createdb -T template0 -U postgres

webspectest

CREATE DATABASE

[postgres@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