| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Damjan Pipan" <damjan(dot)pipan(at)siol(dot)net> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] HELP NEEDED: Recreating DROP columns |
| Date: | 2003-02-05 01:38:30 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOOEGCCFAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> "Damjan Pipan" <damjan(dot)pipan(at)siol(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2003-02-05 01:40:57 | Re: PGP signing releases |
| Previous Message | Greg Copeland | 2003-02-05 00:43:55 | Re: PGP signing releases |