Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Дата
Msg-id CAB7nPqR5zdzBdWeR19oBJimHKOt+=oLwnYJXRrkBaMbiCEDq_g@mail.gmail.com
обсуждение исходный текст
Ответ на Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does  (otheus uibk <otheus.uibk@gmail.com>)
Список pgsql-bugs
On Thu, Dec 3, 2015 at 7:52 PM, otheus uibk <otheus.uibk@gmail.com> wrote:
> I have found a potential bug in 9.1.8 with no corresponding CHANGELOG entry
> through 9.1.19.
>
>       nuxeotest1-> alter table info add column testxxx numeric ;
>       ALTER TABLE
>       nuxeotest1=> alter table info drop column textxxx ;
>       ERROR:  column "textxxx" of relation "info" does not exist
>       nuxeotest1=> alter table info drop column testxxx ;
>       ALTER TABLE
>       nuxeotest1=>
>
> Originally, the point of this exercise was to test permissions.
>
> After logging off and back in again, I could not reproduce the problem.
> I could not reproduce the problem on 9.2.10.
>
> Is this a known glitch?

Do you see an error on 9.1.19? That's what would be interesting. If
you think there is indeed a bug, could you provide a self-contained
test-case?
--
Michael

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

Предыдущее
От: otheus uibk
Дата:
Сообщение: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does