Re: BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: smatiz(at)hotmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table
Date: 2013-01-04 06:54:53
Message-ID: 11363.1357282493@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

smatiz(at)hotmail(dot)com writes:
> RAISE NOTICE 'valores.iva (%)', valores.iva;

I see a UTF8 byte order mark (BOM) in front of "valores.iva" there,
which plpgsql is interpreting as part of the record name, so it doesn't
find any matching variable. I'd be the first to agree that the error
message isn't too helpful. But your text editor and your mailer didn't
do you any favors either, if they hid that BOM from you.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2013-01-04 11:39:36 Re: BUG #7781: pgagent incorrect installation
Previous Message David Johnston 2013-01-04 01:30:21 Re: BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table