"Andrew Nykolyn" <[EMAIL PROTECTED]> writes: > When running a stored procedure that loads data into a temporary table, the > following error occurs when returning the result set through a composite > data type. > Could not open relation with OID 443748
It looks to me like you're running into the same issue described here: http://archives.postgresql.org/pgsql-general/2006-02/msg00172.php namely that a toasted datum is still in memory after the owning table has been dropped, and so subsequent attempts to expand the datum fail. I'm not sure there is any really nice fix for that --- the easy fix of forcibly detoasting everything before plpgsql stores it anyplace would have very unpleasant performance implications. Needs more thought. Curious that this behavior has been there unremarked since 7.1 or so and now two different people stumble across it within a couple of weeks of each other. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
