Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does - Mailing list pgsql-bugs

From Daniel Verite
Subject Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Date
Msg-id 759f49e1-9650-4029-8c19-6ff4b63430a3@mm
Whole thread Raw
In response to Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does  (otheus uibk <otheus.uibk@gmail.com>)
List pgsql-bugs
otheus uibk wrote:

>      nuxeotest1-> alter table info add column testxxx numeric ;
>       ALTER TABLE
>       nuxeotest1=3D> alter table info drop column textxxx ;
>       ERROR:  column "textxxx" of relation "info" does not exist
>       nuxeotest1=3D> alter table info drop column testxxx ;
>       ALTER TABLE
>       nuxeotest1=3D>

testxxx is added
textxxx fails to be removed.

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

Best regards,
--=20
Daniel V=E9rit=E9
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement.
Next
From: tomek@pipebreaker.pl
Date:
Subject: BUG #13793: Please implement IP_FREEBIND option