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

From Christopher Kings-Lynne
Subject Re: [GENERAL] HELP NEEDED: Recreating DROP columns
Date
Msg-id GNELIHDDFBOCMGBFGEFOOEGCCFAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: [GENERAL] HELP NEEDED: Recreating DROP columns  (Tom Lane <tgl@sss.pgh.pa.us>)
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 ;-)

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 by date:

Previous
From: Curt Sampson
Date:
Subject: Re: PGP signing releases
Next
From: "Andrew Dunstan"
Date:
Subject: Re: PGP signing releases