Thread: Domain Check Constraints

Domain Check Constraints

From

Rod Taylor

Date:

08 November 2002, 17:53:55

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

domain.patch

Re: Domain Check Constraints

From

Bruce Momjian

Date:

13 November 2002, 00:23:32

Rod, do you want this added to the patches queue?

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

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

Re: Domain Check Constraints

From

Rod Taylor

Date:

13 November 2002, 00:34:32

On Tue, 2002-11-12 at 21:23, Bruce Momjian wrote:
>
> Rod, do you want this added to the patches queue?

Please do.

> > Anyway, below is a sample:
> >
> > a=# create domain i as integer not null check (value > 15 or value = 5)

--
  Rod Taylor

Re: Domain Check Constraints

From

Bruce Momjian

Date:

13 November 2002, 00:40:51

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

Re: Domain Check Constraints

From

Rod Taylor

Date:

14 November 2002, 01:52:35

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

Re: Domain Check Constraints

From

Rod Taylor

Date:

14 November 2002, 01:59:21

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

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
  Rod Taylor

Attachment

domain_pgdump.patch

Re: Domain Check Constraints

From

Bruce Momjian

Date:

14 November 2002, 02:57:22

Replaces older patch.

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:
> 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@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
> > ----
> >
>
> >
> > ---------------------------(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@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

Re: Domain Check Constraints

From

Bruce Momjian

Date:

15 November 2002, 00:49:50

Patch applied.  Thanks.

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


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

Re: Domain Check Constraints

From

Bruce Momjian

Date:

15 November 2002, 00:52:28

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