Thread: pg_dumapp does not save objects added in pg_catalog
Hi all, I'm novice to postgresql and in this list. I hope this is the good place to put my question. In my project I have added some plpgsql functions in pg_catalog. But when I save the cluster with pg_dumpall I do not find my function definitions in the output file. Is this normal ? Have I to redefine theses functions in my new data base ? Thanks a lot Best Regards Ali
hello ali. why did you add functions to pg_catalog? Just add them to your database. ali.pouya@free.fr rašė: > Hi all, > I'm novice to postgresql and in this list. > I hope this is the good place to put my question. > > In my project I have added some plpgsql functions in pg_catalog. > But when I save the cluster with pg_dumpall I do not find my function definitions in the output file. > > Is this normal ? > Have I to redefine theses functions in my new data base ? > > Thanks a lot > Best Regards > Ali > > -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050
Attachment
ali.pouya@free.fr writes: > In my project I have added some plpgsql functions in pg_catalog. > But when I save the cluster with pg_dumpall I do not find my function definitions in the output file. > Is this normal ? Yes. Anything in pg_catalog is presumed to be part of the core system. regards, tom lane