Thread: HElp

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

Messages with the subject "Help" usually don't get much response. Also,
this is not a bug report. If you have questions or need help, try the
pgsql-general or pgsql-novice mailing lists (as the bug report form
advised you to do) or ask on the EnterpriseDB forums.

Please do not reply to this message. If you want more help, use one of
the places mentioned above.

When you ask for more help in an appropriate place, rather than just
saying "it doesn't work" please copy and paste the ERROR MESSAGES you
get when you run it. See:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

PostgreSQL 8.1 is obsolete and unmaintained. You should update.

"CREATE IF NOT EXISTS AGGREGATE" is invalid and does not exist, so you
cannot use it. See the help:

---------------------------------
db=> \h create aggregate
Command:     CREATE AGGREGATE
Description: define a new aggregate function
Syntax:
CREATE AGGREGATE name ( input_data_type [ , ... ] ) (
     SFUNC = sfunc,
     STYPE = state_data_type
     [ , FINALFUNC = ffunc ]
     [ , INITCOND = initial_condition ]
     [ , SORTOP = sort_operator ]
)

or the old syntax

CREATE AGGREGATE name (
     BASETYPE = base_type,
     SFUNC = sfunc,
     STYPE = state_data_type
     [ , FINALFUNC = ffunc ]
     [ , INITCOND = initial_condition ]
     [ , SORTOP = sort_operator ]
)
---------------------------------

--
Craig Ringer