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: (view raw, whole thread or download thread mbox)
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:

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

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
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-2017 The PostgreSQL Global Development Group