| From: | Israel Brewster <israel(at)ravnalaska(dot)net> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Stored procedure workflow question |
| Date: | 2014-12-11 00:53:00 |
| Message-ID: | 81FBBB06-860E-42D6-82B3-3784389D4C2B@ravnalaska.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Currently, when I need to create/edit a stored procedure in Postgresql, my workflow goes like the following:
- Create/edit the desired function in my "DB Commands" text file
- Copy and paste function into my development database
- Test
- repeat above until it works as desired
- Copy and paste function into my production DB.
To edit an existing function, the workflow is basically the same as above, but I first have to find the function in my file.
This whole workflow just feels kludgy to me. Is there a better way? Or is that essentially the recommended procedure? Thanks.
-----------------------------------------------
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-----------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2014-12-11 01:03:35 | Re: Stored procedure workflow question |
| Previous Message | vicky | 2014-12-10 23:32:48 | Re: Integrating C++ singletons into postgresql extensions??? |