Re: [GENERAL] suggestion for backup (pg_dump)

2012-05-20 Thread c k
Yes, It is useful. But situation is different. Most of the times objects are first created, tested and only after finalization can go in the extension update file. Also it can be difficult not to get the object definitions from an extension in the backup from pg_dump. A customer could have to execu

Re: [GENERAL] suggestion for backup

2012-05-20 Thread Gabriele Bartolini
Hi, Il 19/05/12 19:09, c k ha scritto: similar tasks and already using it. This problem arises when I have to issue an update script to the client having only function mostly. And as most of the functions are dependent on others and having more than 1100 functions it becomes hard to write a li

[GENERAL] suggestion for backup

2012-05-19 Thread c k
Hi, In day to day work I need to dump objects of only specific types like functions, types, view etc from a schema. I know that it will be better to use separate schemas for similar tasks and already using it. This problem arises when I have to issue an update script to the client having only func