Re: Passing an argument to a trigger function using tg_argv

Поиск
Список
Период
Сортировка
От Simon Connah
Тема Re: Passing an argument to a trigger function using tg_argv
Дата
Msg-id 68AZ7pgx35OWNFYJc31b3uyNpi3L0aUrJufmmqOko8cHTduDF-g5WzPDBot0Wd0DptaMpKHwg1OHbDwRQMEVlHOOXJNjfLg4RelWWKGm67o=@protonmail.com
обсуждение исходный текст
Ответ на Passing an argument to a trigger function using tg_argv  (Simon Connah <simon.n.connah@protonmail.com>)
Ответы Re: Passing an argument to a trigger function using tg_argv  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-novice
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Wednesday, March 31st, 2021 at 10:55, Simon Connah <simon.n.connah@protonmail.com> wrote:

> Hi,
>

> I'm having an issue which is saying I can't pass the variable to the trigger function but I'm not sure what I am
doingwrong. You can see my source code here: 
>

> https://gist.github.com/simonconnah/9ddd257198d799230a1689aa855d08d5
>

> I really don't have a clue about what I am doing wrong.
>

> Simon.

There seems to be a weird bug with my code which I can't figure out. I get the following error message since adding the
triggerand the trigger function. 

error: invalid input syntax for type bigint: "blog_user_id"

but I am unsure how to go about diagnosing the problem. If anyone could offer some help I would really appreciate it.

Simon.
Вложения

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

Предыдущее
От: Simon Connah
Дата:
Сообщение: Passing an argument to a trigger function using tg_argv
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Passing an argument to a trigger function using tg_argv