From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org, 347548-forwarded(at)bugs(dot)debian(dot)org |
Subject: | Re: Bug#347548: DOMAIN CHECK constraint bypassed |
Date: | 2006-01-30 22:40:44 |
Message-ID: | 1138660844.8835.11.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Sat, 2006-01-28 at 20:17 +0100, Peter Eisentraut wrote:
> This bug was reported to Debian. Comments?
AFAICS I fixed this a few weeks ago (post-8.1.2):
http://archives.postgresql.org/pgsql-committers/2006-01/msg00209.php
http://archives.postgresql.org/pgsql-patches/2006-01/msg00139.php
I get the following results with the test script on REL8_1_STABLE:
Insert string was allowed, OK
DBD::Pg::db do failed: ERROR: value for domain absdirpath violates
check constraint "absdirpath_check"
Insert empty string was disallowed, OK
DBD::Pg::st execute failed: ERROR: value for domain absdirpath violates
check constraint "absdirpath_check"
Insert empty string via bind was disallowed, OK
DBD::Pg::st execute failed: ERROR: null value in column "basedir"
violates not-null constraint
Insert NULL via bind was disallowed, OK
(FWIW I certainly agree with Tom that the domain implementation needs a
fair bit of work.)
-Neil
From | Date | Subject | |
---|---|---|---|
Next Message | Doug Scott | 2006-01-30 23:32:54 | BUG #2226: Can't delete elements from Enterprise Architect diagram when using PostgreSQL ANSI ODBC driver |
Previous Message | David Fetter | 2006-01-30 18:15:57 | Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ... |