[OT] why not keeping the original column name in catalog after a drop?

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема [OT] why not keeping the original column name in catalog after a drop?
Дата
Msg-id CAKoxK+48=7tLkc=hFOWZ6U6JCS2iR6x-92ggM06rxpYc1qkmgg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [OT] why not keeping the original column name in catalog after a drop?  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Re: [OT] why not keeping the original column name in catalog after a drop?  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Hi all,
when you drop a column on a table the pg_attribute is updated and the
name of the column is changed with an almost fixed identifier that
reports only the original column position:

/** Change the column name to something that isn't likely to conflict*/       snprintf(newattname, sizeof(newattname),
             "........pg.dropped.%d........", attnum);       namestrcpy(&(attStruct->attname), newattname);
 

I'm wondering what is the problem in placing the old/original name
after the "pg.dropped" prefix. I know that the tuple in pg_attribute
is temporary, but what are the possible conflicts the comment talks
about?

Thanks,
Luca



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH] pgbench various mods for high volume testing
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: [OT] why not keeping the original column name in catalog after a drop?