Re: ERROR 1442 (HY000) when delete inside trigger statement

2010-02-18 Thread Jesper Wisborg Krogh
--- Original Message --- > From: viraj > To: mysql@lists.mysql.com > Sent: 19/2/10, 05:48:41 > Subject: ERROR 1442 (HY000) when delete > inside trigger statement > issue: ERROR 1442 (HY000): Can't update table 'T1' in stored > function/trigger because it is already used by > statement wh

MySQL Community Server 5.1.44 has been released

2010-02-18 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.1.44, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.44 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysq

ERROR 1442 (HY000) when delete inside trigger statement

2010-02-18 Thread viraj
i have two table, T1, T2. and 1 trigger. trigger is before update on T1 and it updates some values in T2. once it's done, the trigger tries to delete the subject row of T1 (delete from T1 where id = new.id) i tried with second trigger on T2 (after/before update) and with a procedure inside this t

RE: auto_increment weirdness

2010-02-18 Thread Gavin Towey
Reproduced in 5.1.43. Could not reproduce it in 5.0.66 -Original Message- From: Yang Zhang [mailto:yanghates...@gmail.com] Sent: Wednesday, February 17, 2010 6:05 PM To: mysql@lists.mysql.com Subject: auto_increment weirdness Hi, for some reason, I have an auto_increment field that's ma

Re: how things get messed up

2010-02-18 Thread Johan De Meersman
*cough*partitioning*cough* On Thu, Feb 18, 2010 at 5:24 PM, Jerry Schwartz wrote: > From: Vikram A [mailto:vikkiatb...@yahoo.in] > Sent: Wednesday, February 17, 2010 11:41 PM > To: Jerry Schwartz > Cc: MY SQL Mailing list > Subject: Re: how things get messed up > > > > Dear Jerry Schwartz > > We

RE: how things get messed up

2010-02-18 Thread Jerry Schwartz
From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Wednesday, February 17, 2010 11:41 PM To: Jerry Schwartz Cc: MY SQL Mailing list Subject: Re: how things get messed up Dear Jerry Schwartz We have applications for colleges in India. The same idea of having single table for manipulating stud

Re: how things get messed up

2010-02-18 Thread Martijn Tonies
We have applications for colleges in India. The same idea of having single table for manipulating students records. but we are not following archiving >concept. Ex stupersonal. and stuclass these tables are playing wide role in our application. After 7 years now there are 9000 records[postgres