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