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

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: otheus uibk <otheus(dot)uibk(at)gmail(dot)com>, 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 12:20:04
Message-ID: 56603374.9070303@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-12-03 12:34:22 Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement.
Previous 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