Re: More DROP COLUMN - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: More DROP COLUMN
Date
Msg-id GNELIHDDFBOCMGBFGEFOIECFCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: More DROP COLUMN  (Hannu Krosing <hannu@tm.ee>)
Responses Re: More DROP COLUMN  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
> > etc.  I put that extra number after dropped and not at the end
> so prevent it
> > being off the end of a 32 character name.
> >
> > > Alternatively, we could invest a lot of work to make it possible for
> > > attname to be NULL, but I don't see the payoff...
> >
> > Yeah, I think a weird name should be good enough...
>
> perhaps starting it with spaces instead of _ would make it even harder
> to write by accident, so tha name could be
>    "         dropped 0000000001"
>
> or to make it even more self documenting store the drop time,
> " col001 dropped@020715.101427"
> --------------------------------

Well, are there characters that are illegal in column names that I could
use?  I did a quick check and couldn't find any!

Chris



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: More DROP COLUMN
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: More DROP COLUMN