The following bug has been logged online:

Bug reference:      6289
Logged by:          mohsen
Email address:      momenimoh...@gmail.com
PostgreSQL version: 8.1
Operating system:   centos
Description:        help us
Details: 

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

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

Reply via email to