| From: | "Mark R(dot) Dingee" <mark(dot)dingee(at)cox(dot)net> |
|---|---|
| To: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Temp tables and functions |
| Date: | 2006-10-11 11:02:47 |
| Message-ID: | 1160564567.12626.54.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)dingee(at)cox(dot)net 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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-10-11 12:31:57 | Re: optimal insert |
| Previous Message | Jim C. Nasby | 2006-10-11 02:11:51 | Re: Temp tables and functions |