Temp tables are curious creatures....

From: Rod Taylor <rbt(at)zort(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Temp tables are curious creatures....
Date: 2002-04-30 00:32:23
Message-ID: 1020126745.38874.3.camel@knight.zort.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Appears psql needs to know how to differentiate between it's own temp
tables and those of another connection. On the plus side, this takes
care of a TODO item to add temp table listings to psql.

Connection 1:

template1=# create temp table junk(col1 int4);
CREATE
template1=# select * from junk;
col1
------
(0 rows)

Connection 2:
template1=# \d
List of relations
Name | Type | Owner
------+-------+-------
junk | table | rbt
(1 row)

template1=# select * from junk;
ERROR: Relation "junk" does not exist

template1=# create temp table junk (col4 text);
CREATE

List of relations
Name | Type | Owner
------+-------+-------
junk | table | rbt
junk | table | rbt

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-30 01:35:04 Re: Temp tables are curious creatures....
Previous Message Lamar Owen 2002-04-29 23:25:30 Re: Civility of core/hackers group