pg_restore issue..
От | Chris Bowlby |
---|---|
Тема | pg_restore issue.. |
Дата | |
Msg-id | 20021004111926.N69567-100000@wired.hub.org обсуждение исходный текст |
Ответы |
Re: pg_restore issue..
|
Список | pgsql-general |
Hi Guy's, I've noticed a glitch (or alteast it looks like a glitch) with pg_restore when trying to loadup a tarred pgdump file. There are a few functions that have been defined that are recursive, the function call's itself until a case point is reached which will cause it to call the "non-recursive" function and exit out normally. If I take this function and cut/paste it into a console I can get it to work fine, meaning the function will be created. BUT if I use a pg_restore (even if I'm re-ordering the functions) it will error out claiming that the function in question is not there (because it's calling itself). I've attempted to restore just the function, but the pg_restore "cleans" itself due to the dump that was made so it removes the function before it tries to re-create it. I can call pg_restore -P function name, and as long as I have it's own pre-requesite functions (other then itself) in place it will work fine.. so it's very inconsistant :(.. Anyone else run into this problem? and is there an easy solution to it? Chris Bowlby, ----------------------------------------------------- Manager of Information and Technology. excalibur@hub.org www.hub.org 1-902-542-3657 -----------------------------------------------------
В списке pgsql-general по дате отправления: