Re: Domain Check Constraints

Sorry Bruce, seems I've missed a bit.

pg_dump for domain constraints.


On Tue, 2002-11-12 at 21:40, Bruce Momjian wrote:
>
> Your patch has been added to the PostgreSQL unapplied patches list at:
>
>     http://momjian.postgresql.org/cgi-bin/pgpatches
>
> I will try to apply it within the next 48 hours.
>
> ---------------------------------------------------------------------------
>
>
> Rod Taylor wrote:
> > Regress:
> >     test geometry             ... FAILED
> >
> > But I'm using FreeBSD 4.7 RELEASE (PostgreSQL 7.4-devel)
> >
> >
> > psql needs some additions to display the constraints, though I'm not
> > sure what at the moment.
> >
> >
> > Anyway, below is a sample:
> >
> > a=# create domain i as integer not null check (value > 15 or value = 5)
> > check(value < 18);
> > CREATE DOMAIN
> > a=# select 7::i;
> > ERROR:  Domain $1 constraint i failed
> > a=# select 5::i;
> >  i
> > ---
> >  5
> > (1 row)
> >
> > a=# select 15::i;
> > ERROR:  Domain $1 constraint i failed
> > a=# select 20::i;
> > ERROR:  Domain $2 constraint i failed
> > a=# select 17::i;
> >  i
> > ----
> >  17
> > (1 row)
> >
> > a=#
> >
> > --
> >   Rod Taylor
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> --
>   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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
  Rod Taylor