Re: Passing an argument to a trigger function using tg_argv

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
Cc: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: Passing an argument to a trigger function using tg_argv
Date: 2021-04-01 05:10:57
Message-ID: CAKFQuwbkVKnvB56gw=s45k0FBs0NbWys56LFNRFtqXJzby=A6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Connah 2021-04-01 05:16:15 Re: Passing an argument to a trigger function using tg_argv
Previous Message Simon Connah 2021-04-01 04:03:44 Re: Passing an argument to a trigger function using tg_argv