Re: [SQL] calling a function within a view causes problems doing a pg_dumpall

2001-05-07 Thread Josh Berkus
Juerg, > I need to transfer a db form one to another server. I wanted to do > this > with pg_dumpall and psql -e Have you tried just using pg_dump instead of pg_dumpall? I understand that there were a few bugs in pg_dumpall, and pg_dump will mean less data to transfer. > CREATE FUNCTION

[SQL] calling a function within a view causes problems doing a pg_dumpall

2001-05-07 Thread juerg . rietmann
Hello I need to transfer a db form one to another server. I wanted to do this with pg_dumpall and psql -e I isolated the problem in a view. When I call a self defined function (buildstring) the problem occurs and when I remove this call pg_dumpall works. Calling the view with select * from