| From: | otheus uibk <otheus(dot)uibk(at)gmail(dot)com> |
|---|---|
| To: | Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does |
| Date: | 2015-12-03 10:52:30 |
| Message-ID: | CALbQNd2ZDi2fNHUOKB_ppfLL6XQa3AEN_=dvfvHUqSYS+g7r2g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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?
--
Otheus
otheus(dot)uibk(at)gmail(dot)com
otheus(dot)shelling(at)uibk(dot)ac(dot)at
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2015-12-03 12:07:32 | Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does |
| Previous Message | Dean Rasheed | 2015-12-03 08:19:58 | Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement. |