Skip site navigation (1) Skip section navigation (2)

Temp tables and functions

From: <mark(dot)dingee(at)cox(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Temp tables and functions
Date: 2006-10-10 19:21:36
Message-ID: 398587.1160508096610.JavaMail.root@eastrmwml06.mgt.cox.net (view raw or flat)
Thread:
Lists: pgsql-sql
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. 

Thanks in advance
Mark

Responses

pgsql-sql by date

Next:From: Aaron BonoDate: 2006-10-10 20:45:30
Subject: Re: optimal insert
Previous:From: Andrew SullivanDate: 2006-10-10 18:30:01
Subject: Re: i have table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group