The following bug has been logged online: Bug reference: 1759 Logged by: Boris Sukholitko Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])