Re: Problem with domains

Once upon a time (Wed, 24 Sep 2003 21:10:53 -0700 (PDT))
Stephan Szabo <sszabo@megazone.bigpanda.com> uttered something amazingly similar
to:

>
> On Wed, 24 Sep 2003, Bruce Momjian wrote:
>
> > Sent for user who is having trouble posting to bugs list:
>
> Seems like the correct behavior to me. When CONSTRAINT is given, the
> name is not optional AFAICS.

True, but the second CREATE DOMAIN, which is a valid form, fails when preceded
by the invalid form.  This was the error I was referring to.  Not the fact that
I didn't know how to use domains ;-)  If the transaction is bad after the first
invalid CREATE DOMAIN, the error should say so, rather than waiting for a
second valid statement to come along, shouldn't it?

> > > > > begin;
> > > > > create domain test as integer constraint check( value > 0 );
> > > > > -- ERROR:  syntax error at or near "check" at character 42
> > > > > create domain test as integer check( value > 0 );
> > > > > -- ERROR:  current transaction is aborted, queries ignored until end
> > > > > of transaction block
> > > > >

Cheers,
Rob
--
 22:50:13 up 54 days, 15:22,  5 users,  load average: 2.36, 2.37, 2.17