Skip site navigation (1) Skip section navigation (2)

Re: BUG #5314: Error in nested composite types in plpgsql.

From: Oleg Serov <serovov(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5314: Error in nested composite types in plpgsql.
Date: 2010-02-10 13:40:23
Message-ID: cec7c6df1002100540s56a28146ia3d3d5f18a655556@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Somebody will fix this bug or not?

On Thu, Feb 4, 2010 at 7:13 PM, Oleg <serovov(at)gmail(dot)com> wrote:

>
> 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
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



-- 
С уважением

Олег Серов

In response to

Responses

pgsql-bugs by date

Next:From: Eric PailleauDate: 2010-02-10 13:56:00
Subject: BUG #5322: Time to perform vacuums
Previous:From: Fujii MasaoDate: 2010-02-10 00:30:32
Subject: Re: unable to fail over to warm standby server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group