Can we use dblink for insert and update of dynamic values
| От | Jenish Vyas | 
|---|---|
| Тема | Can we use dblink for insert and update of dynamic values | 
| Дата | |
| Msg-id | CANqFkjGstCe-vArzn+c2X8ghRaZG1=ERwO2cHspXr9hJ1O10wQ@mail.gmail.com обсуждение исходный текст | 
| Ответы | Re: Can we use dblink for insert and update of dynamic
 values | 
| Список | pgsql-general | 
		
			Hi All,
Thanks & regards,
JENISH VYAS
		
	
	
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.
JENISH VYAS
В списке pgsql-general по дате отправления: