| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Create temporary function |
| Date: | 2008-04-23 18:20:36 |
| Message-ID: | 480F7DF4.1000106@pinpointresearch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have recently run across situations that might benefit from the
ability to create a temporary function.
One situation is where periodic processing would benefit from
server-side functions but the processing is run rarely (say monthly or
annually) and the requirements for the function may change. This is
relatively easily handled by a CREATE OR REPLACE..run..DROP FUNCTION but
CREATE TEMPORARY FUNCTION would be cleaner.
The other is where it would be nice for a client to see an isolated
individual copy of a function.
For me both of the above are minor nice-to-haves. I have no idea how
difficult this would be to implement but in the spirit of brainstorming,
I thought I'd throw it out to see if anyone else thinks it is a useful
concept.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-23 18:33:52 | Re: Create temporary function |
| Previous Message | Simon Riggs | 2008-04-23 18:15:52 | Re: Need to update all my 60 million rows at once without transactional integrity |