[mythtv-users] Which tables to alter to remove deadlock?

[Jay R. Ashworth]

On Wed, Sep 01, 2004 at 10:08:05AM -0400, David George wrote:
> As for the starttime being updated it is probably because starttime used 
> to be a timestamp.  This means that whenever the record is updated and a 
> value isn't specified for starttime it will be set to the current time.  
> This is why you will see sql statements like this:
> 
> update recorded set commflagged = 1, starttime=starttime where 
> commflagged = 0;
> 
> This is no longer necessary in the CVS version.

Aha!  *That's* why that happened.  

Thanks, David.  :-)

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

	"You know: I'm a fan of photosynthesis as much as the next guy,
	but if God merely wanted us to smell the flowers, he wouldn't 
	have invented a 3GHz microprocessor and a 3D graphics board."
					-- Luke Girardi