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

From Marko Tiikkaja
Subject Re: Possible bug: ALTER TABLE x DROP COLUMN y "column ... does not exist" then it does
Date
Msg-id 56603374.9070303@joh.to
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
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

pgsql-bugs by date:

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