[EMAIL PROTECTED] 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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
