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 |
10src/include/catalog/pg_proc.h | 4234 !!!!!!!!!!!!!!!!!!!!!!!!!! : 68 files changed, 5302
insertions(+),2 deletions(-), 4910 modifications(!)
Don't say patch too large. :D
--
KaiGai Kohei <kaigai@kaigai.gr.jp>