[ADMIN] pg_dumapp does not save objects added in pg_catalog

2009-09-28 Thread ali . pouya
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 r

Re: [ADMIN] pg_dumapp does not save objects added in pg_catalog

2009-09-28 Thread Julius Tuskenis
hello ali. why did you add functions to pg_catalog? Just add them to your database. ali.po...@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

Re: [ADMIN] pg_dumapp does not save objects added in pg_catalog

2009-09-28 Thread Tom Lane
ali.po...@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.

[ADMIN] Data problem - error "invalid attribute number # for "

2009-09-28 Thread Sebastien Boisvert
We've received a client's database which was giving errors and refusing to be backed up; at this point we do not know what's happened to the database to corrupt it (likely a hardware or power failure, etc.) The error that is being given when trying to do selects on the affected table or doing a

Re: [ADMIN] Data problem - error "invalid attribute number # for "

2009-09-28 Thread Tom Lane
Sebastien Boisvert writes: > We've received a client's database which was giving errors and refusing to be > backed up; at this point we do not know what's happened to the database to > corrupt it (likely a hardware or power failure, etc.) > The error that is being given when trying to do select