Re: Passing an argument to a trigger function using tg_argv

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, April 1st, 2021 at 06:10, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wednesday, March 31, 2021, Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> wrote:
>

> > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> >

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

> You should read the “arguments” description under the create trigger syntax.   It explains why when you wrote the column name blog_user_id is tried to interpret that as a bigint (since that is the parameter type for the trigger function).
>

> David J.

Sorry if I am misunderstanding. I'm still pretty new to PostgreSQL but the column actually is a bigint (well technically a bigserial) which is why I am confused.

Simon.