Problem with domains - Mailing list pgsql-bugs

From Bruce Momjian
Subject Problem with domains
Date
Msg-id 200309250313.h8P3DrQ03966@candle.pha.pa.us
Whole thread Raw
Responses Re: Problem with domains  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
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@postgresql.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@candle.pha.pa.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: create temporary sequence and ecpg
Next
From: Stephan Szabo
Date:
Subject: Re: Problem with domains