pg_dump problem

Started by Olivier PRENANTalmost 25 years ago2 messages
#1Olivier PRENANT
ohp@pyrenet.fr

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)

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Olivier PRENANT (#1)
Re: pg_dump problem

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