BUG #4911: Cannot assign a value to a member of a nested composite type. - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4911
Logged by:          Brian Ceccarelli
Email address:      ceccareb@talussoftware.com
PostgreSQL version: 8.4
Operating system:   Windows, Linux
Description:        Cannot assign a value to a member of a nested composite
type.
Details:

In PL/pgsql, I cannot do:

   a.b.id := 1;

Where a and b are composite type variables.

Example.   Run the following:

---------------------------------------------
drop type if exists type_sp_status cascade;
create type type_sp_status as
(
   number_of_errors                int4
);


drop type if exists type_sp_all cascade;
create type type_sp_all as
(
   status                          type_sp_status
);



CREATE OR REPLACE FUNCTION f_test()
  RETURNS int4 AS
$BODY$
declare
   a                       type_sp_all;

begin

   a.status.number_of_errors := 1;

   raise notice 'number of errors  = %', a.status.number_of_errors;

   return 0;
end;
$BODY$
  LANGUAGE 'plpgsql' STABLE;

---------------------------------------------