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

2011-01-07 Thread Richard Huxton
On 07/01/11 01:56, Benjie Buluran wrote: Hi pgSQL peeps! I’m stumped on this question for over 3 days now. PERFORM dblink_exec('SELECT sp_insert_detailtable('|| pActivityId ||', '|| pserialnumber ||')'); I’m using the DEBUG function in pgAdmin, and I keep getting the “*statement returning

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

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

2011-01-07 Thread Eric McKeeth
On Thu, Jan 6, 2011 at 6:56 PM, Benjie Buluran < benjie.bulu...@igentechnologies.com> wrote: > 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”). > > >