Re: ERROR: "foo_type" is a composite type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR: "foo_type" is a composite type
Date: 2003-09-30 00:51:58
Message-ID: 13885.1064883118@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> CREATE TYPE foo_type AS (a INTEGER);

> DECLARE
> my_var foo_type%rowtype;

> ERROR: "foo_type" is a composite type
> CONTEXT: compile of PL/pgSQL function "foo" near line 2

Hmm, that was an unintended side-effect of another change.
I can't see any strong reason to forbid this programming
pattern, so I'll fix it. Thanks for the report.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2003-09-30 00:55:05 Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Previous Message Tom Lane 2003-09-30 00:48:25 Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)