BUG #4790: ENUM word not recognized! - Mailing list pgsql-bugs

From Piergiorgio Buongiovanni
Subject BUG #4790: ENUM word not recognized!
Date
Msg-id 200905041558.n44FwsB9041601@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4790: ENUM word not recognized!  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4790
Logged by:          Piergiorgio Buongiovanni
Email address:      p.buongiovanni@net-international.com
PostgreSQL version: 8.3
Operating system:   Server Linux and client Windows
Description:        ENUM word not recognized!
Details:

I'm using Query Tool of pgAdmin III and trying to execute this:

CREATE TYPE business.EuropeanCEFLevel AS ENUM
('A1','A2','B1','B2','C1','C2');

but the following error is raised:

ERROR:  syntax error at or near "ENUM"
LINE 1: CREATE TYPE "business.EuropeanCEFLevel" AS ENUM ('A1','A2','...
                                                   ^
********** Errore **********

ERROR: syntax error at or near "ENUM"
Stato SQL: 42601
Carattere: 44

What's the problem?
Regards

pgsql-bugs by date:

Previous
From: "Marshall, Steve"
Date:
Subject: Re: sorting problem
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #4790: ENUM word not recognized!