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

Re: Strange error related to temporary tables

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange error related to temporary tables
Date: 2006-08-31 15:50:32
Message-ID: 44F70548.1010307@magproductions.nl (view raw or flat)
Thread:
Lists: pgsql-general
Csaba Nagy wrote:
> In any case, the error message is strange in itself, as if I try to
> create the temporary table when it exists, the error I get in manual
> trial is:
> 
> ERROR:  relation "test_temp_table" already exists
>         ^^^^^^^^
> 
> compared to the error from the OP which I cite here for reference:
> 
> ERROR: type "temp_report" already exists
>        ^^^^

That's strange indeed.

Some googling revealed this thread:
http://archives.postgresql.org/pgsql-general/2005-09/msg01100.php

Seems like around this time last year someone had the same problem. 
Unfortunately, the cause and it's possible solutions aren't mentioned 
(the OP found a workaround though). They may have never been found...

I suppose if you'd check pg_type there is a record containing 'temp_report'?

-- 
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2006-08-31 15:52:34
Subject: Re: Strange error related to temporary tables
Previous:From: Stefan KaltenbrunnerDate: 2006-08-31 15:44:41
Subject: Re: Cutting the Gborg throat

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