Re: how to add a new column in pg_proc table

Поиск
Список
Период
Сортировка
От noman naeem
Тема Re: how to add a new column in pg_proc table
Дата
Msg-id 20050126132051.7772.qmail@web41526.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: how to add a new column in pg_proc table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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@sss.pgh.pa.us> wrote:

> noman naeem <doublevision_17@yahoo.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 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: WAL: O_DIRECT and multipage-writer
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: [ODBC] RQ: Prepared statements used by multiple connections