> "Damjan Pipan" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html