Re: Reliably finding temporary table

Help! I have a similar problem. Does anybody know how to solve a problem

2005/6/8, Ian Burrell <ianburrell(at)gmail(dot)com>:
>
> We have some functions which need to dynamically create a temporary
> table if it does not already exist. We use the following function:
>
> CREATE OR REPLACE FUNCTION test_date_time_exists() RETURNS BOOLEAN AS '
> BEGIN
> RETURN EXISTS (
> SELECT * FROM pg_class
> WHERE relname = ''test_date_time''
> AND pg_table_is_visible(oid)
> );
> END;
> ' LANGUAGE 'plpgsql' STABLE
>
> However, this has been failing occassionally with errors like
>
> ERROR: cache lookup failed for relation 3454264547
>
> From looking in the list archives, I found a description of
> pg_table_is_visible failing because it has different snapshot
> semantics than the SELECT. Is there a solution for this problem? Is
> there another function I can use? What is a better way to detect temp
> tables visible to the session?
>
> - Ian
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Verba volent, scripta manent
My ISP - http://www.netbynet.ru