From: Jim C. Nasby <jim@nasby.net>
To: mark.dingee@cox.net
Cc: pgsql-sql@postgresql.org
Subject: Re: Temp tables and functions
Date: Tue, 10 Oct 2006 21:11:51 -0500
Message-ID: <20061011021151.GI72517@nasby.net> (raw)
In-Reply-To: <398587.1160508096610.JavaMail.root@eastrmwml06.mgt.cox.net>
References: <398587.1160508096610.JavaMail.root@eastrmwml06.mgt.cox.net>
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 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).
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jim@nasby.net, mark.dingee@cox.net
Subject: Re: Temp tables and functions
In-Reply-To: <20061011021151.GI72517@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox