Re: Inconsistent compilation error

[Melvin Davidson <melvin6925@xxxxxxxxx>]

> I'm unsure why you're considering
>'blah_history.original_id' not to be an argument here.

On Wed, Apr 18, 2018 at 9:50 PM, David Rowley <david.rowley@xxxxxxxxxxxxxxx> wrote:

On 19 April 2018 at 13:28, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
> It is not fine. You have specifed TWO percent signs (%) which requires TWO
> argumenrts,
> but you have only provided ONE -> r.

I'm confused about this statement.

Did you perhaps overlook the fact that there are in fact two
arguments? I'm unsure why you're considering
'blah_history.original_id' not to be an argument here.


--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

There are two possibilities here.

1`. The compiler might be expecting a variable and not accepting a text literal.

Normally, literals are inside the first quotes. IE: raise notice ' blah_history.original_id' %', r;

OR

2. since this is in a loop, r might be NULL

--

Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!