Re: [GENERAL] HELP NEEDED: Recreating DROP columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "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-04 17:14:02
Message-ID: 15170.1044378842@sss.pgh.pa.us
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 ;-)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message greg 2003-02-04 17:15:06 Re: PGP signing releases
Previous Message Tom Lane 2003-02-04 16:59:18 Re: POSIX regex performance bug in 7.3 Vs. 7.2