| From: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(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 10:12:20 |
| Message-ID: | TOdB6vHa8r6oKU93K-P9OXsUasMhBk9iEbOaupTFjBETkPvSD4jn3Qy7ZVG73VLpcMUKu6NHUUHqFekcLC7bykpFdtZN9-XXo4BkKqL2lw8=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, April 1st, 2021 at 06:25, 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 ‐‐‐‐‐‐
> >
> > 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:
https://gist.github.com/simonconnah/9e2af8ac3b442d5a317b353d69c602b0
Thank you for your help!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Wright | 2021-04-02 19:24:16 | Restricting certain users from accessing PUBLIC resources |
| Previous Message | David G. Johnston | 2021-04-01 05:25:22 | Re: Passing an argument to a trigger function using tg_argv |