SELECT does not find table created by itself

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: SELECT does not find table created by itself
Date: 2010-01-02 16:46:40
Message-ID: A05BDAC1FE144657AD49F567BFE81FE7@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select * FROM (select 1 as a) t2
left join t2 t3 ON TRUE

causes error

ERROR: relation "t2" does not exist

How to fix so that table t2 is created only once ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2010-01-02 18:14:07 FM format modifier does not remove leading zero from year
Previous Message Andrus 2010-01-02 16:40:11 Using autogenerated primary key in transaction