Thus spake datactrl
> How do I check if a temporary table exists? Searching pg_tables with a
> temporary table name we chose always fails.
What do you mean? You know that it exists because you just created it
and the create succeeded. Can you describe a situation where you need
to know about a temp table and don't already know?
It can't go into the pg_tables table because then it would be visible
to other processes. Are you perhaps misunderstanding temp tables? You
cannot see them except from the process that created them.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
