| From: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> |
|---|---|
| To: | "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 04:03:44 |
| Message-ID: | 68AZ7pgx35OWNFYJc31b3uyNpi3L0aUrJufmmqOko8cHTduDF-g5WzPDBot0Wd0DptaMpKHwg1OHbDwRQMEVlHOOXJNjfLg4RelWWKGm67o=@protonmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Wednesday, March 31st, 2021 at 10:55, Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)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 doing wrong. 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 trigger and 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2021-04-01 05:10:57 | Re: Passing an argument to a trigger function using tg_argv |
| Previous Message | Simon Connah | 2021-03-31 09:55:26 | Passing an argument to a trigger function using tg_argv |