Postgres Pro
Downloads
Home   >   mailing lists

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 TOdB6vHa8r6oKU93K-P9OXsUasMhBk9iEbOaupTFjBETkPvSD4jn3Qy7ZVG73VLpcMUKu6NHUUHqFekcLC7bykpFdtZN9-XXo4BkKqL2lw8=@protonmail.com
Whole thread Raw
In response to Re: Passing an argument to a trigger function using tg_argv  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view

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

On Wednesday, March 31, 2021, Simon Connah <simon.n.connah@protonmail.com> wrote:
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐

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.




‘The arguments are literal string constants.“ 

A column reference is simply not possible since arguments can only be “literal string constants”.

David J.

Ah, I see. Anyway I managed to fix it with this code:


Thank you for your help!
Attachment

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Passing an argument to a trigger function using tg_argv
Next
From: Peter Wright
Date:
Subject: Restricting certain users from accessing PUBLIC resources