Relation not gfound in view Error - Mailing list pgsql-general

From Michael Black
Subject Relation not gfound in view Error
Date
Msg-id BAY115-W20897E5CE2157FC43F2126FA930@phx.gbl
Whole thread Raw
List pgsql-general
I created two tables populated both with valid data including forgien key values.
I create a view that uses both of these tables in a view that.  When I select from the view, I get this error
 
ERROR: relation "vwsinglelevellist" does not exist
SQL state: 42P01

But when I run the defination as a simple select statement, I do not get an error.
 
Any ideas?
 
TIA
Michael
 
 

pgsql-general by date:

Previous
From: "Wm. Stewart"
Date:
Subject: Wiki: FreeOpenSourceSoftware.org
Next
From: "Alejandro D. Burne"
Date:
Subject: Users functions library