Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Passing an argument to a trigger function using tg_argv
Date
Msg-id CAKFQuwbkVKnvB56gw=s45k0FBs0NbWys56LFNRFtqXJzby=A6g@mail.gmail.com
Whole thread Raw
In response to Re: 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  (Simon Connah <simon.n.connah@protonmail.com>)
List pgsql-novice
Tree view
On Wednesday, March 31, 2021, Simon Connah <simon.n.connah@protonmail.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.

pgsql-novice by date:

Previous
From: Simon Connah
Date:
Subject: Re: Passing an argument to a trigger function using tg_argv
Next
From: Simon Connah
Date:
Subject: Re: Passing an argument to a trigger function using tg_argv