Re: Simplifying identification of temporary tables - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Simplifying identification of temporary tables
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3415C2DA8@Herge.rcsinc.local
Whole thread Raw
In response to Simplifying identification of temporary tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> That would respond to the abstraction concern in a more complete
> fashion.  I thought about that one too, but felt that the ability to
> look at the whole pg_class row (and not only check existence) had some
> value.  Also, I've seen people doing things like
>     ... where relname LIKE 'pattern' and ...
> which still works with the namespace OID function but would not work
> with a does_temp_table_exist() function.  I wouldn't object to doing
> both this and the OID function, though.  Do you have a proposal for
> the exact spelling of the exists() function?

I guess pg_temp_table_exists(text) is the most straightforward.

Merlin


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Toward pg_upgrade
Next
From: Simon Riggs
Date:
Subject: Re: [Bizgres-general] A Guide to Constraint Exclusion