[GENERAL] HELP NEEDED: Recreating DROP columns

"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 ;-)

regards, tom lane

"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