The following bug has been logged online:

Bug reference: 1404
Logged by: T.Russell
Email address: tirny@mail.ru
PostgreSQL version: 7.4.6
Operating system: FreeBSD 5.3
Description: pg_dump: dump order/dependence for a UDF
Details:

for example, there is the table:
CREATE TABLE test(
testfield VARCHAR(5)
);

in the process of life it was made (for example):
CREATE OR REPLACE FUNCTION chtest()
RETURNS bpchar AS
'
DECLARE
BEGIN
RETURN \'qwerty\';
END;
'
LANGUAGE 'plpgsql' VOLATILE;

and further:
ALTER TABLE test ALTER COLUMN testfield
SET DEFAULT chtest();

$pg_dump -U user -f file.dump dbname
$dropdb -U user dbname
$createdb -U user -E ... -O ... -T ... dbname
$psql -U user -d dbname < file.dump

error: function chtest dos't exist!

But in the dump it is present, only it is "below" the declaration of the
creation of table. As I understand work of pg_dump: in the dump are
discarded the objects, sort out of the date of creation, without taking
dependences.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

On Sun, Jan 16, 2005 at 03:43:38PM +0000, T.Russell wrote:

> As I understand work of pg_dump: in the dump are discarded the
> objects, sort out of the date of creation, without taking dependences.

That's right. 8.0's pg_dump does the right thing.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Amanece. (Ignacio Reyes)
El Cerro San Cristóbal me mira, cínicamente, con ojos de virgen"

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html