Postgres Pro
Downloads
Home   >   mailing lists

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

From otheus uibk
Subject Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Date
Msg-id CALbQNd2ZDi2fNHUOKB_ppfLL6XQa3AEN_=dvfvHUqSYS+g7r2g@mail.gmail.com
Whole thread Raw
Responses Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does  (Michael Paquier <michael.paquier@gmail.com>)
Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does  (Marko Tiikkaja <marko@joh.to>)
Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-bugs
Tree view 
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.uibk@gmail.com
otheus.shelling@uibk.ac.at

pgsql-bugs by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement.
Next
From: Michael Paquier
Date:
Subject: Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does