Thread: BUG #6289: help us

The following bug has been logged online:

Bug reference:      6289
Logged by:          mohsen
Email address:      momenimohsen@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

"mohsen" <momenimohsen@gmail.com> wrote:

> PostgreSQL version: 8.1

That's no longer a supported version.  8.2 goes out of support next
month.  Please upgrade to something more recent.

> 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

> 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;

> i useaggre gate in pgsql 8 and for test use this not have
>
> CREATE if exist  AGGREGATE

It's not at all clear what you want help with, but nothing above
sounds remotely like a bug.  Please read this page and post to a
more appropriate list (like pgsql-general) with more information.
If you have multiple issues, it would be best to start a separate
thread for each one, with a subject line appropriate to the topic.
"help us" doesn't give any clue what the topic is.

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

-Kevin

Read this please:

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

On 11/10/2011 09:59 PM, mohsen wrote:
> PostgreSQL version: 8.1
8.1.**WHAT** ?

There are lots of bug fix releases in the 8.1 series and nobody here has
psychic powers that let them tell which one you're using. When you
report a bug, that's kinda important.
> Operating system:   centos
"CentOS" isn't very informative. CentOS ***WHAT***? Try, eg:

    CentOS 5 running 2.6.28-2-i686 as a Xen domU guest

> Description:        help us

If you want help, that's about the least useful subject line to use.
Most people will ignore uninformative subject lines like "Help" or "help
me, urgent".

Didn't you just post a similar "bug report" earlier, anyway?

Try asking in the appropriate place:

http://archives.postgresql.org/pgsql-novice/
http://archives.postgresql.org/pgsql-general/
<http://archives.postgresql.org/pgsql-novice/>
http://forums.enterprisedb.com/forums/list.page

... after reading this:

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

--
Craig Ringer