| From: | Jenish Vyas <jenishvyas(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Can we use dblink for insert and update of dynamic values |
| Date: | 2011-08-18 14:26:38 |
| Message-ID: | CANqFkjGstCe-vArzn+c2X8ghRaZG1=ERwO2cHspXr9hJ1O10wQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ireneusz Pluta | 2011-08-18 15:16:51 | Re: Can we use dblink for insert and update of dynamic values |
| Previous Message | Nicholson, Brad (Toronto, ON, CA) | 2011-08-18 14:08:44 | Re: max_stack_depth error, need suggestion |