Обсуждение: pg_dump problem

Поиск
Список
Период
Сортировка

pg_dump problem

От
Olivier PRENANT
Дата:
Hi all,

I've read pg_dump threads with great interest as I plan to upgrade from
703 to 71 on next monday if 71 final is out.

Although I did'nt have any of the ploblems listed in threads durin my
tests from 7.0.3 to 7.1betas and 7.1RCs.

I have noticed that pg_dump     and pg_dumpall could'nt generate correctly
CREATE FUNCTION when function has been created using the form

CREATE FUNCTION foo(x) RETURNS type AS 'xxxx/foo.so','foo2' LANGUAGE C;

pg_dumps "forgets" the 'foo2' part: that being a pain in the a... when
reloading...

Regards,

-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)



Re: pg_dump problem

От
Tom Lane
Дата:
Olivier PRENANT <ohp@pyrenet.fr> writes:
> I have noticed that pg_dump     and pg_dumpall could'nt generate correctly
> CREATE FUNCTION when function has been created using the form
> CREATE FUNCTION foo(x) RETURNS type AS 'xxxx/foo.so','foo2' LANGUAGE C;
> pg_dumps "forgets" the 'foo2' part: that being a pain in the a... when
> reloading...

This is fixed in 7.1 ... not a lot we can do about 7.0 at this point ...
        regards, tom lane