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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not.



Plpgsql procedure:

 

BEGIN

Drop table if exits temptable cascade ;

 

Create temp table temptable …..

 

Create temp view tempview as select … from temptable…..

 

Select …. from tempview  …..

END

 

The first time I run this after I create the procedure it works perfectly.

The second time I get notices that the drop is cascading to the view (this was expected and OK)

But then the select fails

ERROR: could not open relation …. No such file or directory

 

 



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group