Re: More DROP COLUMN

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: More DROP COLUMN
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961E20@m0114.s-mxs.net
обсуждение исходный текст
Ответ на More DROP COLUMN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: More DROP COLUMN  (Curt Sampson <cjs@cynic.net>)
Список 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@2002-07-17.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: More DROP COLUMN
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: More DROP COLUMN