Re: pg_restore cannot restore function

From: Jie Liang <jie(at)stbernard(dot)com>
To: 'Achilleus Mantzios' <achill(at)matrix(dot)gatewaynet(dot)com>, Jie Liang <jie(at)stbernard(dot)com>
Cc: 'Jan Wieck' <JanWieck(at)Yahoo(dot)com>, 'Bruce Momjian' <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'admin(at)postgresql(dot)org'" <admin(at)postgresql(dot)org>, "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: pg_restore cannot restore function
Date: 2002-07-03 15:25:17
Message-ID: 7C760DAA511DC74B99E7D22189F786F101BF210C@MAIL01.stbernard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

This is not the case, because those db on a same server, it's
I dump data from one db and try restore one of it function into
another db.

Thanks for your response anyway.

Jie Liang

-----Original Message-----
From: Achilleus Mantzios [mailto:achill(at)matrix(dot)gatewaynet(dot)com]
Sent: Wednesday, July 03, 2002 12:52 AM
To: Jie Liang
Cc: 'Jan Wieck'; 'Bruce Momjian'; 'admin(at)postgresql(dot)org';
'pgsql-sql(at)postgresql(dot)org'
Subject: Re: [SQL] pg_restore cannot restore function

In the case that you moved your backup to another system
where possibly the shared library (.so) where the function exists is on a
different location then thats the problem, in which case you only need
to recreate the function (with the same isstrict,iscachable attributes).

--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-07-03 16:28:01 Re: Localization
Previous Message GRIMOIS Eric 2002-07-03 14:48:24 Localization