Re: [PATCHES] Demo patch for DROP COLUMN

On Tue, 2002-07-23 at 20:42, Tom Lane wrote:
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> >> But you *didn't* make sure it would never be a problem.
> 
> > Wasn't I looping until I found a unique name?
> 
> My point was that there could still be a conflict against a user column
> that the user tries to create *later*.  So it's illusory to think that
> making the name of a dropped column less predictable will improve
> matters.

The simple (to describe, perhaps not to implement ;) way to resolve it
would be for the ADD COLUMN (or CREATE TABLE INHERITS) rename the
offending deleted column once more.

--------------
Hannu