Re: Passing an argument to a trigger function using tg_argv - Mailing list pgsql-novice

From Simon Connah
Subject Re: Passing an argument to a trigger function using tg_argv
Date
Msg-id 68AZ7pgx35OWNFYJc31b3uyNpi3L0aUrJufmmqOko8cHTduDF-g5WzPDBot0Wd0DptaMpKHwg1OHbDwRQMEVlHOOXJNjfLg4RelWWKGm67o=@protonmail.com
Whole thread Raw
In response to Passing an argument to a trigger function using tg_argv  (Simon Connah <simon.n.connah@protonmail.com>)
Responses Re: Passing an argument to a trigger function using tg_argv  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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.
Attachment

pgsql-novice by date:

Previous
From: Simon Connah
Date:
Subject: Passing an argument to a trigger function using tg_argv
Next
From: "David G. Johnston"
Date:
Subject: Re: Passing an argument to a trigger function using tg_argv