Re: Temp tables and functions - Mailing list pgsql-sql

From Mark R. Dingee
Subject Re: Temp tables and functions
Date
Msg-id 1160564567.12626.54.camel@localhost.localdomain
Whole thread Raw
In response to Re: Temp tables and functions  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-sql
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, mark.dingee@cox.net wrote:
> > Everyone,
> > 
> > I've written a function (language = sql) which uses a temporary table to simplify the process; however, when I go
toload 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
createa 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).



pgsql-sql by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Temp tables and functions
Next
From: Markus Schaber
Date:
Subject: Re: optimal insert