#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    1
    Rep Power
    0

    Restore pg_dump errors


    I am getting the following errors while trying to restore a dump -
    ERROR: function echo_update_to_ser() does not exist
    ERROR: function echo_insert_to_ser() does not exist
    The strange part is that I see the function being created prior to the trigger calling the function -
    CREATE FUNCTION echo_insert_to_ser() RETURNS "trigger"
    AS E'
    -----
    CREATE TRIGGER echo_insert_bank_to_ser
    AFTER INSERT ON tb_bank
    FOR EACH ROW
    EXECUTE PROCEDURE echo_insert_to_ser();

    The pg_dump was taken from pgsql version 8.1, OS - Linux. And I attempted to restore on pgsql version 8.4, OS - Linux.

    Any help would be appreciated. I am quite the beginner when it comes to postgres.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2005
    Posts
    3
    Rep Power
    0
    if you did a dump with --clean or -c it trys to drop the obejects or functions prior to creation. if it is not there you will get the error and then the object will get created.

IMN logo majestic logo threadwatch logo seochat tools logo