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