Thread: question on "create domain"

question on "create domain"

From
"Denis Grannell"
Date:
Hi,

Sorry if this is a known problem or a faq, but I couldn't
find anything about it:

I'm using postgres  7.2.3 on Solaris and I can't create
domains. The syntax I'm using is lifted directly from the
postgres documentation:

CREATE DOMAIN country_code char(2) NOT NULL;

This throws up the following error:

pubs=# CREATE DOMAIN country_code char(2) NOT NULL;
ERROR:  parser: parse error at or near "domain"

thanks for any tips,

Denis Grannell

 _________________________________________________________
| Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
| Tel: +49 89 2013672                 Fax: +49 89 2022875 |
|_________________________________________________________|