Skip site navigation (1) Skip section navigation (2)

BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

From: "lindebg" <lindebg(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions
Date: 2011-11-17 20:54:15
Message-ID: 201111172054.pAHKsFc7052692@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6299
Logged by:          lindebg
Email address:      lindebg(at)gmail(dot)com
PostgreSQL version: 9.0, 9.1
Operating system:   Linux, Windows
Description:        pg_dump, pg_dumpall - Problem with the order of backup
functions
Details: 

1. create database test and functions fn2, fn1:

$ psql -c "create database test"

$ psql test
test=# create function fn2()
returns int as
$$ select 1 $$
language sql immutable;

create function fn1(param1 int default fn2())
returns int as
$$ select $1 $$
language sql immutable;
\q



2. backup:

pg_dump -F c > test.backup



3. clear database:

psql -c "drop database test"
psql -c "create database test"



4. restore database:

pg_restore -d test test.backup


Errors:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 221; 1255 21043 FUNCTION
fn1(integer) postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  function fn2()
does not exist
LINE 1: CREATE FUNCTION fn1(param1 integer DEFAULT fn2()) RETURNS in...
                                                   ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
    Command was: CREATE FUNCTION fn1(param1 integer DEFAULT fn2()) RETURNS
integer
    LANGUAGE sql IMMUTABLE
    AS $_$ select $1 $_$;



pg_restore: [archiver (db)] could not execute query: ERROR:  function
public.fn1(integer) does not exist
    Command was: ALTER FUNCTION public.fn1(param1 integer) OWNER TO
postgres;


WARNING: errors ignored on restore: 2

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-11-18 00:42:18
Subject: Re: BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions
Previous:From: Flávio Alves GranatoDate: 2011-11-17 20:31:42
Subject: Re: CREATE ROLE jdbc vs pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group