[GENERAL] Inserting data from one database to another using stored functions

2011-01-06 Thread Benjie Buluran
Hi pgSQL peeps! I'm stumped on this question for over 3 days now. I need to run a stored function in Database A ("sf DBa") which calls a stored function in Database B ("sf DBb"). Here's "sf DBa": CREATE OR REPLACE FUNCTION sp_update_serialnumber(pserialnumber character varying, pActivi

Re: [GENERAL] Inserting data from one database to another using stored functions

2011-01-07 Thread Benjie Buluran
com] Sent: Friday, January 07, 2011 4:03 PM To: Benjie Buluran Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Inserting data from one database to another using stored functions On Thu, Jan 6, 2011 at 6:56 PM, Benjie Buluran wrote: Hi pgSQL peeps! I'm stumped on this question