Re: Domain Check Constraints

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Domain Check Constraints
Date: 2002-11-15 02:52:18
Message-ID: 200211150252.gAF2qIV23700@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Patch applied. Thanks.

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

Rod Taylor wrote:
> Ugh.. A non-empty file this time.
>
>
> On Wed, 2002-11-13 at 22:53, Rod Taylor wrote:
> > 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(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
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> > --
> > Rod Taylor
> > ----
> >
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> --
> Rod Taylor

[ Attachment, skipping... ]

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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-11-15 02:54:56 Re: pgcrypto/openssl fix
Previous Message Bruce Momjian 2002-11-15 02:49:30 Re: Domain Check Constraints