URGENT: temporary table not recognized?

[Phoenix Kiula <phoenix.kiula@xxxxxxxxx>]

Hi. I'm using Postgresql 9.0.5, and the connection is made via pgbouncer.

I create a temporary table, and then want to import data into this
table via a COPY command. Yet, this just created table is not being
recognized. What's up?

>From my terminal:



mydb=#
mydb=# create temporary table vl (
          alias varchar(35)
          ,dates timestamp without time zone
          ,referers text null
        );
CREATE TABLE
Time: 1.871 ms

mydb=# copy vl from '/backup/data.txt' WITH DELIMITER AS '|';
ERROR:  relation "vl" does not exist

mydb=#



Weird! Welcome any thoughts.

Thanks

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general