Question on 'create domain'

Started by Denis Grannellabout 23 years ago3 messagesgeneral
Jump to latest
#1Denis Grannell
dgrannell@web.de

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

#2Doug McNaught
doug@mcnaught.org
In reply to: Denis Grannell (#1)
Re: Question on 'create domain'

"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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Denis Grannell (#1)
Re: Question on 'create domain'

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