BUG #12690: EXECUTE statement fails with dynamic column name on record variable

From: patrick(at)vanlaake(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12690: EXECUTE statement fails with dynamic column name on record variable
Date: 2015-01-28 10:18:39
Message-ID: 20150128101839.2585.73885@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12690
Logged by: Patrick
Email address: patrick(at)vanlaake(dot)net
PostgreSQL version: 9.3.5
Operating system: Ubuntu server 12.04
Description:

A recent question on StackOverflow was answered with a PL/PgSQL function
that includes a dynamic statement built from a row-typed record variable
(http://stackoverflow.com/questions/28164457/how-to-use-pl-pgsql-to-transform-an-original-table-to-desired-two-tables-in-post/28166069#28166069)
When running the function, the statement:

EXECUTE 'SELECT th.' || quote_ident(period) INTO times;

generates the run-time error:

ERROR: missing FROM-clause entry for table "th"
LINE 1: SELECT th."1996-04"
^
QUERY: SELECT th."1996-04"
CONTEXT: PL/pgSQL function normalize_things_happened() line 22 at EXECUTE
statement
********** Error **********

ERROR: missing FROM-clause entry for table "th"
SQL state: 42P01
Context: PL/pgSQL function normalize_things_happened() line 22 at EXECUTE
statement

where the local variable th is a row-typed record, period is a string
representing a column name and times is an integer.

When converting the statement to the non-dynamic corresponding version
SELECT th."1996-04" INTO times; the statement executes without an error.

In this specific context the parser seems to not support or disallow the use
of a record variable. Is this a bug ?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-01-28 15:23:25 Re: BUG #12670: Can't create postgis extension in single-user mode
Previous Message David Gould 2015-01-28 10:09:54 Re: Infinite loop in GetMultiXactIdMembers() on 9.3.5 (involves pg_upgrade)