[Slashcode-development] Sql caching issue with perl/mysql?

[Gaulin, M. <mg...@gl...>]

Hi
I added a new table to slash (to allow emails to go to non-registered
users) and when the "daily" task ran last night it seemed to not see the
latest table contents.  I'm using the mysql "rename table" command to
swap a new copy of the table in and rotate an old copy out, and it sent
the emails to the people in the "old" table.  Is it possible that
renaming a table would allow an existing process (slashd) that had
already connected to the older copy of the table to not see it?  (I can
imagine a sql client library caching table ids or query plans or
something like that, but I certainly wasn't expecting it.)

Can anyone confirm this kind of problem, or am I just losing my mind?

Thanks
	Mark