On 23/09/11 10:43, Gavin Flower wrote:
> On a LInux 64 biut system:
> $ psql
> psql (9.1.0)
> Type "help" for help.
> gavin=> DROP TYPE raindow;
> ERROR: type "raindow" does not exist
> gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow',
> 'green', 'blue', 'purple');
> ERROR: type "rainbow" already exists
As soon as I saw this published, I saw my obvious mistake..
DROP TYPE raindow;
CREATE TYPE rainbow AS ENUM ...
Sory, but my eyesight is very bad, so I did not see the mistake
In response to
pgsql-bugs by date
|Next:||From: John R Pierce||Date: 2011-09-23 04:32:05|
|Subject: Re: drop enum problem|
|Previous:||From: Gavin Flower||Date: 2011-09-22 22:43:45|
|Subject: drop enum problem|