Thread: [GENERAL] HELP NEEDED: Recreating DROP columns

Hello!

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?

Thanks,
Damjan

"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