Re: [HACKERS] how to add a new column in pg_proc table

2005-01-26 Thread noman naeem
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_attrib

Re: [HACKERS] how to add a new column in pg_proc table

2005-01-25 Thread Tom Lane
noman naeem <[EMAIL PROTECTED]> 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_fm

Re: [HACKERS] how to add a new column in pg_proc table

2005-01-25 Thread noman naeem
Tom, Thanks for the reply I rechanged the pg_proc.h,pg_attribute.h and pg_class.h but still facing errors,rather this time there were two different errors. 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 e

Re: [HACKERS] how to add a new column in pg_proc table

2005-01-25 Thread Tom Lane
noman naeem <[EMAIL PROTECTED]> writes: > I keep on getting errors.It be very helpful if some > one can guide me regarding the basic steps for adding > a column in the pg_proc table... The odds are that you didn't correctly update either pg_proc.h itself, the preset pg_attribute rows for it in pg_

Re: [HACKERS] how to add a new column in pg_proc table

2005-01-25 Thread Alvaro Herrera
On Tue, Jan 25, 2005 at 07:44:18AM -0800, noman naeem wrote: Hi, > I need to add a column of text type in pg_proc table > which is the part of the system catalog.I need to have > it so that I can proceed with my project. > [snip] > > I keep on getting errors.It be very helpful if some > one can

[HACKERS] how to add a new column in pg_proc table

2005-01-25 Thread noman naeem
Hello Every one, I am a student and working on my final year project, I chose postgres as my development database,because of its flexable architecture and extensibility. I need to add a column of text type in pg_proc table which is the part of the system catalog.I need to have it so that I can pr