Thread: Question on 'create domain'

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 |
|_________________________________________________________|

"Denis Grannell" <dgrannell@web.de> writes:

> 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:

I bet you're reading the 7.3 docs--I don't think domains are available
in 7.2.X.

-Doug

Denis Grannell writes:

> I'm using postgres  7.2.3 on Solaris and I can't create
> domains.

That's because there are no domains in 7.2.  You need 7.3.

--
Peter Eisentraut   peter_e@gmx.net