| From: | darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain) |
|---|---|
| To: | datactrl <quals(at)bigfoot(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, roelof(dot)sondaar(at)scania(dot)com |
| Subject: | Re: how do I check if a temporary table exists? |
| Date: | 2001-03-24 12:42:15 |
| Message-ID: | 20010324124215.A94771A61@druid.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at){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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2001-03-24 12:57:50 | Re: Serials. |
| Previous Message | Richard Huxton | 2001-03-24 11:34:09 | Re: Serials. |