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

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Is this the exact, unaltered session transcript? Because:

On 12/3/15 11:52 AM, otheus uibk wrote:

nuxeotest1-> alter table info add column testxxx numeric ;

The prompt here suggests you were in the middle of another command while
running this. If you did *any* changes to the transcript, it's
impossible to even guess what exactly happened. As written, the
transcript seems sketchy.

Do you log DDL statements? That would probably be the easiest way to
figure out the exact series of commands.

.m

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

otheus uibk wrote:

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

testxxx is added
textxxx fails to be removed.

That's not the same identifier. So isn't that just a typo?

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs