[mythtv-users] Which tables to alter to remove deadlock?
Jay R. Ashworth
jra at baylink.com
Wed Sep 1 10:27:58 EDT 2004
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
More information about the mythtv-users
mailing list