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

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
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 13:08:41
Message-ID: 759f49e1-9650-4029-8c19-6ff4b63430a3@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ydolgikh 2015-12-03 16:06:44 BUG #13792: Weird querry planner behavior
Previous Message Michael Paquier 2015-12-03 12:34:22 Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement.