Re: Execute ignoring cursor?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Execute ignoring cursor?
Дата
Msg-id CAFj8pRCnv_LWCsnBmEx1k4N5smsVUwxZD9fWwNkXmZAAD2dBsg@mail.gmail.com
обсуждение исходный текст
Ответ на Re[2]: [HACKERS] Execute ignoring cursor?  (nummervet nummervet <nummervet@mail.ru>)
Ответы Re[4]: [HACKERS] Execute ignoring cursor?  (nummervet nummervet <nummervet@mail.ru>)
Список pgsql-hackers


2016-04-08 16:46 GMT+02:00 nummervet nummervet <nummervet@mail.ru>:
That didn't work for me:

ERROR:  syntax error at or near "$"
LINE 1: ...ibute_id, set_id ) (select $."151", '...

should be $1

Regards

Pavel
 


Пятница, 8 апреля 2016, 17:25 +03:00 от Pavel Stehule <pavel.stehule@gmail.com>:


Hi

2016-04-08 16:17 GMT+02:00 nummervet nummervet <nummervet@mail.ru>:
Hello. Didn't find dedicated plpgsql list, so decided to post question here.
I am trying to create a  function that will pick up some values from cursor and execute them as a dynamic query.
However, once i use EXECUTE, its seems to be ignoring the existence of cursor and try to pick up values from table.
Basically:

insert into mytable ( value, attribute_id, set_id ) (select rec."151", '201', '1')

works, but

execute 'insert into mytable ( value, attribute_id, set_id ) (select rec."151", ''201'', ''1'')'

Dynamic queries are executed in own space and there are not direct access to plpgsql variables.

please, try: execute 'insert into mytable ( value, attribute_id, set_id ) (select $1."151", ''201'', ''1'')' using rec;

Regards

Pavel Stehule
 

fails with

ERROR:  missing FROM-clause entry for table "rec"
LINE 1: ...ibute_id, set_id ) (select rec."151",...

Is there any way around it? Or should i just give up and do it some other way?




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Choosing parallel_degree
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Speed up Clog Access by increasing CLOG buffers