BUG #5757: PL/PGSQL composite variable field error reporting

From: "Andrey Galkin" <andvgal(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5757: PL/PGSQL composite variable field error reporting
Date: 2010-11-18 16:49:09
Message-ID: 201011181649.oAIGn9AP060902@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5757
Logged by: Andrey Galkin
Email address: andvgal(at)gmail(dot)com
PostgreSQL version: 9.0.1
Operating system: Debian unstable
Description: PL/PGSQL composite variable field error reporting
Details:

1. Create a variable of composite type in PL/PGSQL function
2. Try to reference not existing field of the variable in some statement,
like IF
3. Get "missing FROM-clause entry for table" error at runtime

The error is not very helpful. If it's possible please detect the
incorrectly referenced field at parsing/statement preparing time.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-11-18 17:53:29 Re: BUG #5757: PL/PGSQL composite variable field error reporting
Previous Message Jon Nelson 2010-11-18 15:28:26 Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"