Re: More DROP COLUMN

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: More DROP COLUMN
Date: 2002-07-15 09:10:03
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4961E20@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> However, I'm not happy with the way dropped columns are renamed. I want to
> give them a name that no-one would ever want to use as a legit column name.
> I don't like this behaviour:

Yes, how about prepending a character that would usually need to be escaped.

I like Hannu's proposal with the blanks " col1 dropped(at)2002-07-17(dot)10:30:00",
the underscores are too commonly used.
Maybe add two characters, one special and a backspace after the first blank.
So it would print nicely, but be very unlikely.

I would prefer a simple but highly predictable rule, where you can say "Don't
name your columns starting with " \353\010" (blank, greek d, BS) over some random
algo that stays out of the way by means of low probability.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-07-15 10:17:11 Re: More DROP COLUMN
Previous Message Hannu Krosing 2002-07-15 08:17:52 Re: More DROP COLUMN