Problem with domains

Sent for user who is having trouble posting to bugs list:

---------------------------------------------------------------------------

> > Robert Creager wrote:
> > > Sorry to send this to you directly, but I seem to be having a problem
> > > posting to bugs, and I received no response from either Mark F. nor
> > > majordomo-owner.
> > >
> > > I've sent the following mail twice to postgresql-bugs(at)postgresql(dot)org, and
> > > both times, it's neither showed up nor have I received any mail indicating
> > > it's been held for moderation, and I am subscribed to the list.
> > >
> > > Thoughts?
> > > Rob
> > >
> > > The problem:
> > >
> > > Using 7.4b2 from tar file, not cvs.
> > >
> > > PostgreSQL 7.4beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
> > > (Mandrake Linux 9.1 3.2.2-3mdk)
> > >
> > > While figuring out how to use DOMAIN's, I ran across this:
> > >
> > > 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
> > >
> > > Forgot to name the constraint in the first form. The second form works fine
> > > on it's own.
> > >
> > > Cheers,
> > > Rob
> > >
> > > --
> > > 17:37:47 up 44 days, 10:13, 4 users, load average: 2.13, 2.04, 2.04
> > >
> > >
> > >
> > -- End of PGP section, PGP failed!
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> >
>
>
> --
> 21:08:35 up 54 days, 13:40, 4 users, load average: 2.07, 2.03, 1.96
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073