URGENT: temporary table not recognized?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: URGENT: temporary table not recognized?
Date: 2012-01-06 16:41:08
Message-ID: CAFWfU=ugpVJ4SrPVMBamuzv6E7iM1fR4j_zRKZ5ZpT2jhDkvgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-06 16:46:23 Re: URGENT: temporary table not recognized?
Previous Message David Johnston 2012-01-06 16:33:10 Re: function return update count