work!
I believe that the man page of pg_restore should be improved.
Thanks.
Jie Liang
-Original Message-
From: Jan Wieck [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 11:14 AM
To: Jie Liang
Cc: 'Bruce Momjian'; '[EMAIL PROTECTED]'; '[EMAIL PROTE
02 12:52 AM
To: Jie Liang
Cc: 'Jan Wieck'; 'Bruce Momjian'; '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'
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)
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 Mantzio
Wieck [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 11:14 AM
To: Jie Liang
Cc: 'Bruce Momjian'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Re: [SQL] pg_restore cannot restore function
Jie Liang wrote:
>
> Oops,my OS is FreeBSD4.3 PostgreSQL7.2
Sent: Friday, June 28, 2002 1:46 PM
> To: 'Jan Wieck'
> Cc: 'Bruce Momjian'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> Subject: RE: [SQL] pg_restore cannot restore function
>
> No any error msg in the logfile, I didn't see any create funct
I use
pg_dump -Fc mydb > dbf
then I create anpther db by:
createdb mydb2
I use
pg_restore -P myfunction -d mydb2 dbf
cannot restore myfunction into mydb2
why??
Jie Liang
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
