Cannot drop column

Поиск
Список
Период
Сортировка
Искать
От
Rich Shepard
Тема
Cannot drop column
Дата
Msg-id
bd67f1ba-7a58-36f8-a081-1dc6cac4e278@appl-ecosys.com
Список
Дерево обсуждения
Cannot drop column Rich Shepard <rshepard@appl-ecosys.com>
Re: Cannot drop column Viral Shah <viralshah009@gmail.com>
Re: Cannot drop column Rich Shepard <rshepard@appl-ecosys.com>
Re: Cannot drop column Adrian Klaver <adrian.klaver@aklaver.com>
Re: Cannot drop column Rich Shepard <rshepard@appl-ecosys.com>
Re: Cannot drop column "David G. Johnston" <david.g.johnston@gmail.com>
Re: Cannot drop column "David G. Johnston" <david.g.johnston@gmail.com>
Re: Cannot drop column Rich Shepard <rshepard@appl-ecosys.com>
Re: Cannot drop column Ron Johnson <ronljohnsonjr@gmail.com> 
I'm not seeing why postgres won't drop a table's column:

bustrac=# select * from statustypes order by stat_name;
      stat_name 
--------------------
  Client
  Lead
  No further contact
  Opportunity
  Proposal submitted
  Prospect
  Qualified
  Referral
  Suspect
(9 rows)

bustrac=# alter table statustypes drop column Suspect;
ERROR:  column "suspect" of relation "statustypes" does not exist
bustrac=#

What have I done incorrectly?

TIA,

Rich
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: David G. Johnston
Дата:
Сообщение: Re: Cannot drop column
FAQ