Hello On 29/12/2007, Marcin Krawczyk <[EMAIL PROTECTED]> wrote: > Hi all. Is there a way to determine the existence of a TEMP TABLE? I need to > check i it exists before I create it. > Doing simple check on pg_class or pg_tables is > not enough because there may be other such tables created in other sessions. > Or maybe anyone knows the identification (apart from 'others') of error to > trap it with EXCEPTION clause? >
http://www.pgsql.cz/index.php/Automatic_execution_plan_caching_in_PL/pgSQL Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster