Josef Karthauser wrote:
> On Sun, Nov 12, 2006 at 05:47:49PM -0500, Len Jaffe wrote:
>> At the DBI level, you use the RaiseError option at connect time to determine
>> whether DBI should raise
>> an exception. It has a sister option PrintError, which determines whether
>> the error message ($DBI::errstr)
>> is printed to SDTERR.
>>
>
> Ok, I'm now connecting to the database as follows:
>
> my $schema = __PACKAGE__->connect($DSN, $username, $password,
> { PrintError => 0, RaiseError => 0 } );
>
> However I'm still getting errored out when I try and delete this row:
>
> DBIx::Class::Relationship::CascadeActions::delete(): Error executing
> 'DELETE FROM contact WHERE ( contactid = ? AND owner = ? )': Cannot
> delete or update a parent row: a foreign key constraint fails at
> test3.pl line 21
>
> I've added cascade_delete => 0 to all the has_many() declarations.
> Shouldn't that switch this off?
>
> JoeIt should, but to be honest, I've never had good luck with those two flags. Somewhere along the line, it gets lost in DBI and only some strange incantations of local have ever fixed it for me. What version of DBI are you using? -=Chris
signature.asc
Description: OpenPGP digital signature
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
