| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Jie Liang <jie(at)stbernard(dot)com> |
| Cc: | '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-06-28 19:39:02 |
| Message-ID: | 3D1CBB56.1E86357E@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Jie Liang wrote:
>
> I use
> pg_dump -Fc mydb > dbf
> then I create another db by:
> createdb mydb2
> I use
> pg_restore -P myfunction -d mydb2 dbf
>
> cannot restore myfunction into mydb2
>
> why??????
Good question. Is there any error message in the postmaster log?
If the function is written in a procedural language, is that language
enabled in the target database? If the function is written in the SQL
language, do all underlying objects like tables and views exist? If it's
a C language function, does the shared object containing the function
exist at the expected location?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albrecht Berger | 2002-06-28 19:51:15 | something similar to "on delete cascade" ? |
| Previous Message | Josh Berkus | 2002-06-28 19:18:18 | Re: graphical interface - admin |