Re: How to add column in pg_class

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: smoken0(at)gmail(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to add column in pg_class
Date: 2005-09-06 15:00:22
Message-ID: 17860.1126018822@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rafaqat Ali <smoken0(at)gmail(dot)com> writes:
> Is there any other file in which I have to make change ?????

Fooling with any of the bootstrapped catalogs is pretty messy.
You might grab this patch from the CVS server for comparison:

2005-03-29 14:44 tgl

* doc/src/sgml/bki.sgml, doc/src/sgml/catalogs.sgml,
src/backend/bootstrap/bootstrap.c, src/backend/catalog/pg_proc.c,
src/include/catalog/catversion.h,
src/include/catalog/pg_attribute.h, src/include/catalog/pg_class.h,
src/include/catalog/pg_proc.h: Add proallargtypes and proargmodes
columns to pg_proc, as per my earlier proposal for OUT parameter
support. The columns don't actually *do* anything yet, they are
just left NULLs. But I thought I'd commit this part separately as
a fairly pure example of the tasks needed when adding a column to
pg_proc or one of the other core system tables.

Whatever you're doing in heapam.c is probably wrong, too. There is no
reason for that file to be involved in a system catalog extension ---
it operates at too low a level.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2005-09-06 15:37:26 Re: dbt-4 (tpc-app) kit
Previous Message mark 2005-09-06 14:49:30 Re: uuid type for postgres