Re: [GENERAL] HELP NEEDED: Recreating DROP columns - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] HELP NEEDED: Recreating DROP columns
Date
Msg-id 15170.1044378842@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] HELP NEEDED: Recreating DROP columns  ("Damjan Pipan" <damjan.pipan@siol.net>)
Responses Re: [GENERAL] HELP NEEDED: Recreating DROP columns  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List 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 ;-)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: POSIX regex performance bug in 7.3 Vs. 7.2
Next
From: greg@turnstep.com
Date:
Subject: Re: PGP signing releases