Re: [GENERAL] HELP NEEDED: Recreating DROP columns

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [GENERAL] HELP NEEDED: Recreating DROP columns
Дата
Msg-id GNELIHDDFBOCMGBFGEFOOEGCCFAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [GENERAL] HELP NEEDED: Recreating DROP columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> "Damjan Pipan" <damjan.pipan@siol.net> writes:
> > I have dropped some columns and have quite some problems now
> with RECTYPE
> > variables types.
> > My question: Can I RECREATE dropped columns?
> > I checked the pg_attribute table and there I can change values
> of attname,
> > attstattarget and attisdropped
> > for my column. Will this work? Is there any side affect?
>
> You should be able to get away with that --- but I'd recommend
> experimenting in a scratch database ;-)

I also don't see any problem with it.

This is another hint that we should fix RECTYPE tho - Tom, where do I begin
looking?

Chris



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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: PGP signing releases
Следующее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: PGP signing releases