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

On Sun, Feb 16, 2003 at 18:24:08 +0100,
  Denis Grannell <dgrannell@web.de> wrote:
> 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:

Domain support was added in 7.3. Check constraints on domains aren't
supported in 7.3, but are in CVS (which will become 7.4).

Hi Doug and Bruno,

Yes you're right, I was reading the docs over
the web and they, of course are for 7.3.
Thank you for the quick responses.

regards,
Denis Grannell

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