470,647 Members | 1,056 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

function restore order

I am running 7.2.4

I have 2 functions:
get_deficiency_days_old()
and
get_deficiency_days_old_sub()

The former basically is just a wrapper for the latter.

The problem is that when I restored from a pg_dump script, the former was
recreated first, and so the function create command failed because the sub
was not created yet:
CREATE FUNCTION "get_deficiency_days_old" (integer) RETURNS integer
<snip...>
ERROR: Function 'get_deficiency_days_old_sub(date, timestamp, bpchar)' does
not
exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

Is there a way to set dependencies or order for the function backups when
using pg_dump?

Thanks
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
te***@greatgulfhomes.com
Fax: (416) 441-9085
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #1
0 1089

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by FoxRunner | last post: by
5 posts views Thread by chow.justy | last post: by
1 post views Thread by nikb | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.