Skip site navigation (1) Skip section navigation (2)

Re: Domain Check Constraints

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Domain Check Constraints
Date: 2002-11-14 03:53:15
Message-ID: 1037245996.19543.30.camel@jester (view raw or flat)
Thread:
Lists: pgsql-patches
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

Attachment: domain_pgdump.patch
Description: application/octet-stream (0 bytes)

In response to

Responses

pgsql-patches by date

Next:From: Rod TaylorDate: 2002-11-14 03:59:59
Subject: Re: Domain Check Constraints
Previous:From: Neil ConwayDate: 2002-11-14 01:25:53
Subject: Re: minor SGML fix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group