From: | "Oleg" <serovov(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5314: Error in nested composite types in plpgsql. |
Date: | 2010-02-04 16:13:34 |
Message-ID: | 201002041613.o14GDYZQ051230@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: 5314
Logged by: Oleg
Email address: serovov(at)gmail(dot)com
PostgreSQL version: 8.3/8.4
Operating system: any
Description: Error in nested composite types in plpgsql.
Details:
Here is it reproduce code:
It works only, when procedure is plpgsql, with sql works fine.
ROLLBACK;
BEGIN;
CREATE TABLE bug_level_tree(
field BIGINT
);
CREATE TABLE bug_level_two(
field bug_level_tree
);
CREATE TABLE bug_level_one(
id BIGINT,
field bug_level_two
);
CREATE FUNCTION bug_procedure(in_row bug_level_one) RETURNS text AS $$
BEGIN
-- void
SELECT 1/0;
END;
$$ LANGUAGE plpgsql;
-- All okey
SELECT '(1,)'::bug_level_one;
-- Throws error
SELECT bug_procedure('(1,)');
-- ERROR: cannot assign non-composite value to a row variable
CONTEXT: PL/pgSQL function "bug_procedure" while storing call arguments
into local variables
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2010-02-04 16:31:21 | Re: BUG #5304: psql using conninfo fails in connecting to the server |
Previous Message | Alvaro Herrera | 2010-02-04 15:55:20 | Re: BUG #5312: I NEED HELP |