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
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 |