> -Original Message-
> From: Jared Williams [mailto:jared.willi...@ntlworld.com]
> Sent: 31 March 2010 16:25
> To: 'Ralph Schindler'; 'Guillaume ORIOL'
> Cc: fw-general@lists.zend.com
> Subject: RE: [fw-general] recurse on cascade dele
Btw, I made some tests with "on delete cascade" in mysql and
discovered an issue: the cascade delete doesn't fire a trigger defined
on the deleted row. Even this dB engine (innodb) doesn't implement the
cascade delete in a consistent way.
--
Guillaume
Envoyé de mon iPhone
Le 31 mars 2010
On Mar 31, 2010, at 8:24 AM, Jared Williams wrote:
I don't think it is possible to implement a robust cascading delete in
an application without transaction support. (eg MyISAM)
You need a transaction to ensure either all the delete statements run,
or none of them.
Yes, this is correct -- bu
> -Original Message-
> From: Ralph Schindler [mailto:ralph.schind...@zend.com]
> Sent: 30 March 2010 06:00
> To: Guillaume ORIOL
> Cc: fw-general@lists.zend.com
> Subject: Re: [fw-general] recurse on cascade delete
>
>
>
> Guillaume ORIOL wrote:
Guillaume ORIOL wrote:
Thank you for your advice.
I am using MySQL 5 with InnoDB engine which implements cascade deletes
as well as triggers.
I have to confess I am not very comfortable with triggers. And the logic
behind the cascade delete is fairly complex in my application. Therefore
I t
e: [fw-general] recurse on cascade delete
I regret implementing the cascading delete in Zend_Db_Table
even for one level. It was hard to do, required a lot of
code, and still doesn't work. Even fixing ZF-1103 won't be
enough. It's not possible to ensure data consistency when
cascading
s.zend.com
Subject: Re: [fw-general] recurse on cascade delete
I regret implementing the cascading delete in Zend_Db_Table
even for one level. It was hard to do, required a lot of
code, and still doesn't work. Even fixing ZF-1103 won't be
enough. It's not possible to ensure data c
s.zend.com
Subject: Re: [fw-general] recurse on cascade delete
I regret implementing the cascading delete in Zend_Db_Table
even for one level. It was hard to do, required a lot of
code, and still doesn't work. Even fixing ZF-1103 won't be
enough. It's not possible to ensure data c
Sqlite 3.6.19 and later have RI,
http://www.sqlite.org/foreignkeys.html .
Jared
> -Original Message-
> From: Bill Karwin [mailto:b...@karwin.com]
> Sent: 29 March 2010 17:03
> To: fw-general@lists.zend.com
> Subject: Re: [fw-general] recurse on cascade delete
>
>
I regret implementing the cascading delete in Zend_Db_Table even for
one level. It was hard to do, required a lot of code, and still
doesn't work. Even fixing ZF-1103 won't be enough. It's not possible
to ensure data consistency when cascading operations are implemented
in PHP code.
Yo
Hi,
I was working on an application that uses cascade delete and discovered a bug that was already known
and reported.
I was wondering why the corresponding issue
http://zendframework.com/issues/browse/ZF-1103
had not been closed and included in a previous ZF release,
as a patch was provided a
11 matches
Mail list logo