Domain Check Constraints

Started by Rod Taylorover 23 years ago9 messagespatches

Jump to latest

Rod Taylor

rbt@rbt.ca

over 23 years ago

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

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Rod Taylor (#1)

Re: Domain Check Constraints

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

Rod Taylor

rbt@rbt.ca

over 23 years ago

In reply to: Bruce Momjian (#2)

Re: Domain Check Constraints

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

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Rod Taylor (#1)

Re: Domain Check Constraints

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

Rod Taylor

rbt@rbt.ca

over 23 years ago

In reply to: Bruce Momjian (#4)

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

Rod Taylor

rbt@rbt.ca

over 23 years ago

In reply to: Rod Taylor (#5)

Re: Domain Check Constraints

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

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Rod Taylor (#6)

Re: Domain Check Constraints

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

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Rod Taylor (#1)

Re: Domain Check Constraints

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

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Rod Taylor (#6)

Re: Domain Check Constraints

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

Domain Check Constraints

Attachments:

Attachments:

Attachments: