Postgres Pro
Downloads
Home   >   mailing lists

Can we use dblink for insert and update of dynamic values - Mailing list pgsql-general

From Jenish Vyas
Subject Can we use dblink for insert and update of dynamic values
Date
Msg-id CANqFkjGstCe-vArzn+c2X8ghRaZG1=ERwO2cHspXr9hJ1O10wQ@mail.gmail.com
Whole thread Raw
Responses Re: Can we use dblink for insert and update of dynamic values  (Ireneusz Pluta <ipluta@wp.pl>)
List pgsql-general
Tree view
Hi All,

Can we user dblink for insert and update of dynamic values??


Sample function : 

CREATE OR REPLACE FUNCTION dblink_test()
  RETURNS boolean AS
$BODY$
DECLARE
v1 numeric;
v2 character varying(50);
BEGIN
 v1 := 123;  v2 := 'asdasdasd';
 select dblink_exec('dbname=testing_db_link_1'::text, 'insert into abc values(v1,v2);'::text);
 select dblink_exec('dbname=testing_db_link_1'::text, 'update abc set b = '' testing '' where a = v1;'::text);
RETURN FALSE;
END;
$BODY$
  LANGUAGE plpgsql STABLE
  COST 100;

When I am running this function it is giving me following error..

ERROR: column "v1" does not exist
SQL state: 42703
Context: Error occurred on dblink connection named "unnamed": could not execute command.
SQL statement "select dblink_exec('dbname=testing_db_link_1'::text, 'insert into abc values(v1,v2);'::text)"
PL/pgSQL function "aaa" line 9 at SQL statement

Plz. guide me.

Thanks & regards,
JENISH VYAS


pgsql-general by date:

Previous
From: "Nicholson, Brad (Toronto, ON, CA)"
Date:
Subject: Re: max_stack_depth error, need suggestion
Next
From: Ireneusz Pluta
Date:
Subject: Re: Can we use dblink for insert and update of dynamic values