BUG #4790: ENUM word not recognized!

From: "Piergiorgio Buongiovanni" <p(dot)buongiovanni(at)net-international(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4790: ENUM word not recognized!
Date: 2009-05-04 15:58:54
Message-ID: 200905041558.n44FwsB9041601@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4790
Logged by: Piergiorgio Buongiovanni
Email address: p(dot)buongiovanni(at)net-international(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2009-05-04 16:59:05 Re: BUG #4790: ENUM word not recognized!
Previous Message Marshall, Steve 2009-05-04 12:02:43 Re: sorting problem