Re: Cant find temp tables

hi all,
i am struggling with temp tables. i have a statement like CREATE TEMP
TABLE test (a BIGINT);
it executes successfully, hence i know that the table has been created.
but i cant see the table within the DB using PGADMIN. if i do SELECT *
FROM test; it returns 0 records, but it still tells me that the table
exists with no data inside it. if i do a DROP TABLE test; it deletes
the table too. so everything is pointing to the fact that the table is
created, contains no data, but i cant see it. there is only one schema
(public) too.
can somebody please help me out.
thanks.

sconeek(at)gmail(dot)com wrote:
> hi all,
> i am struggling with temp tables. i have a statement like CREATE TEMP
> TABLE test (a BIGINT);
> it executes successfully, hence i know that the table has been created.
> but i cant see the table within the DB using PGADMIN. if i do SELECT *
> FROM test; it returns 0 records, but it still tells me that the table
> exists with no data inside it. if i do a DROP TABLE test; it deletes
> the table too. so everything is pointing to the fact that the table is
> created, contains no data, but i cant see it. there is only one schema
> (public) too.
> can somebody please help me out.

Sounds like a bug in pgadmin.

Might be better asking that list though:

http://www.pgadmin.org/support/

--
Postgresql & php tutorials
http://www.designmagick.com/

could be. i will have a look at the pgadmin site and see if i can find
anything. but the pgadmin guys couldnt have missed this problem, seems
to be pretty important functionality. thanks.