> On Apr 11, 2017, at 8:47 PM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Tuesday, April 11, 2017, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
> I’m really just bumping into the annoyance of manually dropping the temp table as I work this up (though real collision in production would is possible, it would be unlikely) and thought to try to rework the function without the temp table - that’s the SQL question - and presumed the specifics of the function would come in useful.
>
>
> I'm not positive what you are thinking here but the names of temporary tables are session-unique. They are not prone to concurrent use namespace collisions and not do not interfere with permanent tables either. They are placed into a temporary schema that is only visible to the current session.
>
> David J.
Of course ‘on commit drop’ works like a charm.
Thanks a ton.
rjs