BUG #1759: domain check constraint ignored in prepared statement - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1759
Logged by:          Boris Sukholitko
Email address:      bobatonhu@yahoo.co.uk
PostgreSQL version: 7.4.8
Operating system:   Linux
Description:        domain check constraint ignored in prepared statement
Details:

Hi,

It seems that the domain check constraint does not trigger
an error when using prepared statement in perl's DBD::Pg 1.42.

It seemed to work in earlier versions of DBD::Pg module.

The following code snippet manifests the problem:
#!/usr/bin/perl -w
use strict;
use DBI;
use DBD::Pg;

my $dbh = DBI->connect("dbi:Pg:dbname=testdb");
$dbh->do(<<ENDS);
create domain display_text_d text
        constraint display_text_d_non_empty_chk check (VALUE ~
'[a-zA-z0-9]');
create table domain_test (d display_text_d not null);
ENDS

my $s = $dbh->prepare("insert into domain_test (d) values (?)");

# This execute will succeed leaving invalid value
# in the database
$s->execute(' ');

# This statement fails due to the check constraint
# as expected
$dbh->do("insert into domain_test (d) values (?)", undef, ' ');

Thanks,
Boris.