From: | MOHSEN MOMENI <momenimohsen(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | HElp |
Date: | 2011-11-10 13:39:49 |
Message-ID: | CA++=0QKZ=LKuvGLJnbhoETkCkK3Tvu-OYTfEHLWsE7570CP1Cw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I use this command for create TEMPORARY TABLE
now affter use this temporary i want DROP this Table but NOT WORk IF EXIST
TEMPORARY TABLE in PGsql 8.1
for this please help me
SELECT connection_log_details.connection_log_id,
textcat_all(connection_log_details.value || '|')
INTO TEMPORARY log
FROM connection_log_details
GROUP BY connection_log_details.connection_log_id limit 2010;
select * from log;
DROP TABLE log;
and
i useaggre gate in pgsql 8 and for test use this not have
CREATE if exist AGGREGATE
please help me
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Young | 2011-11-10 13:56:53 | Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost" |
Previous Message | Maksym Boguk | 2011-11-10 11:09:31 | BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1? |