Re: [pgadmin-support] Inserting data from one database to another using stored functions

2011-01-06 Thread Guillaume Lelarge
Hi, Le 06/01/2011 07:01, Benjie Buluran a écrit : > [...] > 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_seri

[pgadmin-support] Inserting data from one database to another using stored functions

2011-01-06 Thread Benjie Buluran
Hi pgAdmin Support! 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, pAc