Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rajni Bobal <rajnibobal(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vik Fearing <vik(at)postgresfriends(dot)org>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4
Date: 2025-01-23 14:24:47
Message-ID: CAKFQuwaY94qzgEEgDjFEN0Abcd9f9RC6hfF6XAE_CHXpELFyyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thursday, January 23, 2025, Rajni Bobal <rajnibobal(at)gmail(dot)com> wrote:

> Hello SIr,
> Please clarify about why $1 is not been replaced by 'colname' in delete_from_table2
> function.
>

It has been replace with the string literal value ‘colname’, not a column
reference identifier “colname”. You cannot use positional parameters to
supply identifiers. Structure must be known at parse time.

David J.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rajni Bobal 2025-01-23 14:54:36 Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4
Previous Message Richard Guo 2025-01-23 09:11:44 ERROR: tuple to be updated was already modified by an operation triggered by the current command