Re: [GENERAL] Temporary table visibility

2006-01-26 Thread Patrick TJ McPhee
In article <[EMAIL PROTECTED]>, James Croft <[EMAIL PROTECTED]> wrote: [given a bunch of temporary tables called session_data] % How can I determine if one of the above relations is a temporary % table in the current session (one of them, the first in ns 2200, is a % normal permanent table)?

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Jaime Casanova
On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: > Jaime Casanova <[EMAIL PROTECTED]> writes: > > On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote: > >> How can I determine if one of the above relations is a temporary > >> table in the current session (one of them, the first in ns 2200, is a > >> n

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Tom Lane
Jaime Casanova <[EMAIL PROTECTED]> writes: > On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote: >> How can I determine if one of the above relations is a temporary >> table in the current session (one of them, the first in ns 2200, is a >> normal permanent table)? > SELECT n.nspname as "Schema", c

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Jaime Casanova
On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote: > > On 25 Jan 2006, at 14:17, Jaime Casanova wrote: > > >> How can I determine what temporary tables exist in my session, > >> bearing in mind that other sessions contain temp tables using the > >> same names? > >> > > > > just the ones you have cr

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread James Croft
On 25 Jan 2006, at 14:17, Jaime Casanova wrote: How can I determine what temporary tables exist in my session, bearing in mind that other sessions contain temp tables using the same names? just the ones you have created in your session, temporary tables in other sessions are invisible to you

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Jaime Casanova
> How can I determine what temporary tables exist in my session, > bearing in mind that other sessions contain temp tables using the > same names? > just the ones you have created in your session, temporary tables in other sessions are invisible to you... -- regards, Jaime Casanova (DBA: DataBase