Huy Do wrote:
> I always do a session.clear() after I do my stored procs/triggers.
Which just reminded me of PostgreSQL notifications. Maybe watching for
those and reload the objects specified by the trigger in the
notification message (or just invalidate part of the cache) would be a
nice idea.
Notifications are inherently not transaction-safe, besides being pg-specific. Not worth it IMO.
--
Jonathan Ellis
http://spyced.blogspot.com
