Hi!
> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
Tim> On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>>
mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
Peter> ERROR 1192: Can't execute the given command because you have active locked
Peter> table
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>
> mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
> Peter> ERROR 1192: Can't execute the given command because you have active locked
> Peter> tables or an active transaction
>
> I bet this happens when you
Hi!
> "Cal" == Cal Evans <[EMAIL PROTECTED]> writes:
Cal> Gotta ask. Is this a problem or just a really bad idea? Part of me can see
Cal> why this is barfing. ON the same line you rename a table twice. If it's
Cal> threading these requests then one thread might not be finished with the
Ca
Gotta ask. Is this a problem or just a really bad idea? Part of me can see
why this is barfing. ON the same line you rename a table twice. If it's
threading these requests then one thread might not be finished with the
table formally known as table1 before you try and move it again.
If you abso
