Re: pg_restore error on function

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 11/3/22 09:28, Post Gresql wrote:
> Hello
>       
>       
>       I first successfully ran
>       
>       
>       pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n
>       my_schema --no-owner -v my_db
>       
>       
>       but then
>       
>       
>       pg_restore --single-transaction -v -U postgres -O -e -d
>       my_other_db my_dump
>       
>       
>       failed with
>       
>       
>       pg_restore: connecting to database for restore
>       
>       pg_restore: creating FUNCTION "my_schema.update_b()"
>       
>       pg_restore: [archiver (db)] Error while PROCESSING TOC:
>       
>       pg_restore: [archiver (db)] Error from TOC entry 7142; 1255
>       8618854 FUNCTION update_b() previous_owner
>       
>       pg_restore: [archiver (db)] could not execute query: ERROR: 
>       schema my_schema" does not exist
>       
>           Command was: CREATE FUNCTION "my_schema".update_b() RETURNS
>       void
>       
>           LANGUAGE plpgsql
>       
>           AS $$
>       
>                   BEGIN
>       
>                   PERFORM pg_advisory_xact_lock(1);
>       
>       
>                   INSERT INTO ...;
>       
>                   END;
>       
>                   $$;
>       
>       
>       
>       This is PG version 10.19
>       
>       
>       Is there a solution for this (apart from upgrading to a newer PG
>       version)?
>       
>     
    
    What was the complete pg_dump command?

--
Angular momentum makes the world go 'round.