Skip site navigation (1) Skip section navigation (2)

HElp

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 (view raw or flat)
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

Responses

  • Re: HElp at 2011-11-11 00:23:22 from Craig Ringer

pgsql-bugs by date

Next:From: Robert YoungDate: 2011-11-10 13:56:53
Subject: Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"
Previous:From: Maksym BogukDate: 2011-11-10 11:09:31
Subject: BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group