KaiGai Kohei wrote:
Andrew Dunstan wrote:


KaiGai Kohei wrote:

One melancholic thing is adding a member into pg_proc.
It defines more than 2000 of entries which I have to modify correctly. :(
Is there any script to help it?



Last time I added a column to a large catalog, I used a perl script to help me, IIRC, but I haven't kept it. Could be a useful tool if somebody could generalize such a thing.

My preference is sed & awk. :)

OK, I'll also do it by myself.

FYI:

* revision 1468
 $ diffstat sepostgresql-sepgsql-8.4devel-3-r1467.patch
     :
 110 files changed, 9813 insertions(+), 16 deletions(-), 924 modifications(!)


* current revision
 $ diffstat sepostgresql-sepgsql-8.4devel-3-r1492.patch
     :
 src/include/catalog/pg_attribute.h            |  507 !!!
 src/include/catalog/pg_class.h                |   28
 src/include/catalog/pg_database.h             |   10
 src/include/catalog/pg_proc.h                 | 4234 !!!!!!!!!!!!!!!!!!!!!!!!!!
     :
 68 files changed, 5302 insertions(+), 2 deletions(-), 4910 modifications(!)

Don't say patch too large. :D

--
KaiGai Kohei <kai...@kaigai.gr.jp>

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to