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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: otheus uibk <otheus(dot)uibk(at)gmail(dot)com>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Date: 2015-12-03 12:07:32
Message-ID: CAB7nPqR5zdzBdWeR19oBJimHKOt+=oLwnYJXRrkBaMbiCEDq_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Dec 3, 2015 at 7:52 PM, otheus uibk <otheus(dot)uibk(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Marko Tiikkaja 2015-12-03 12:20:04 Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Previous Message otheus uibk 2015-12-03 10:52:30 Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does