Postgres Pro
Downloads
Home   >   mailing lists

SELECT does not find table created by itself - Mailing list pgsql-general

From Andrus
Subject SELECT does not find table created by itself
Date
Msg-id A05BDAC1FE144657AD49F567BFE81FE7@andrusnotebook
Whole thread Raw
Responses Re: SELECT does not find table created by itself  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Re: set-level update fails with unique constraint violation
Next
From: "Andrus"
Date:
Subject: FM format modifier does not remove leading zero from year