Re: PL/pgSQL examples NOT involving functions

Aasmund,

> envisity=# DROP TABLE temp ;
> DROP
> envisity=# create table temp (tempid integer);
> CREATE
> envisity=# INSERT INTO temp VALUES(3);
> INSERT 150371 1
> envisity=# select test3();
> ERROR:  Relation 150348 does not exist
> envisity=# 

That's a new one on me.  I've dropped and re-created dozens of tables,
and while I have to re-build the views, I've never had to touch the
functions for that reason.  Either in PL/pgSQL or in SQL.

What version are we talking about?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco