Thanks, Jim. I'll give it a try. On Tue, 2006-10-10 at 21:11 -0500, Jim C. Nasby wrote: > On Tue, Oct 10, 2006 at 03:21:36PM -0400, [EMAIL PROTECTED] wrote: > > Everyone, > > > > I've written a function (language = sql) which uses a temporary table to > > simplify the process; however, when I go to load the function I get: > > > > /var/lib/pgsql$cat thm.sql | psql test > > ERROR: relation "lost_bus" does not exist > > > > where "lost_bus" is the name of my temp table. The function is just for a > > report that is run monthly, so I can create a permanent table if necessary, > > but I'd rather not. > > Create the temp table in your script that creates the function. You > don't need to populate it or anything, you just need it to exist > (prefferably with the correct definition).
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend