[GENERAL] Can we use dblink for insert and update of dynamic values

[Jenish Vyas]

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