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



Tue, 4 Feb 2003 17:00:16 +0100
"Damjan Pipan" <damjan.pipan@siol.net>
[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

Tue, 04 Feb 2003 12:14:02 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [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 ;-)

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


Wed, 5 Feb 2003 09:38:30 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: [GENERAL] HELP NEEDED: Recreating DROP columns 