Re: More DROP COLUMN

On Mon, 2002-07-15 at 09:20, Christopher Kings-Lynne wrote:
> > > 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!

I guess that \0 would be unusable (not sure if its illegal)

\r \n and \t (and others < 0x20) are probably quite unlikely too.

--------------
Hannu