Re: how to add a new column in pg_proc table

Hello Tom,

Now I have been able to generate valid bki file and
have been able to avoid all the errors thanks to
you,but still have not been able to add that
column.Now at initdb the database fails to initialize
itself.And the error it gives is.

duplicate key violates unique constraint
"pg_attribute_relid_attnum_index"

I am very sure it is due to pg_attribute.h file in
which I have inserted the entry for "protempsrc"
column.

The main thing is I am unable to understand this
insert statement structure.Please guide,I am in an
urgency.

It would be great if you can describe what it does and
means.

DATA(insert ( 1255 protempsrc 26 -1 -1 -1 0 -1 -1 f x
i f f f t 0));

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> noman naeem <doublevision_17(at)yahoo(dot)com> writes:
> > They came at the time of frmgrtab.h file
> creation,they
> > are
>
> > fmgrtab.c:25: error: syntax error before '-' token
> > fmgrtab.c:2168: error: syntax error before '}'
> token
>
> > there are loads and loads of such errors.
>
> I suppose you forgot to update the Gen_fmgrtab.sh
> script
> to account for new column numbering in pg_proc.
>
> > Could you tell me from where I can have the last
> patch
>
> See our CVS server --- a checkout and then "cvs
> diff" around
> the time point I identified for you should do the
> trick.
>
> regards, tom lane
>

__________________________________
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
http://my.yahoo.com