Error or bug?

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Error or bug?
Date: 2007-06-20 15:05:28
Message-ID: 200706201705.28620.Vincenzo.Romano@notorand.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

Under PGSQL v8.2.4, in a PL/PgSQL function whenver I try to run this
statement:

INSERT INTO table1 SELECT var1.*;

I get his message:

ERROR: record type has not been registered
CONTEXT: SQL statement "INSERT INTO table1 select $1 .*"

Of course var1 has been declared as table1 type.

I suspect this could be a bug. But cannot be sure.
Any hint?

--
Vincenzo Romano -= NotOrAnd.IT Information Technologies =-
tel +39 0823 454163 | cel +39 339 8083886 | fax +39 02 700506964
<Smooth seas never make experienced sailormen>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nhrcommu 2007-06-20 15:08:28 Re: Re: [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage
Previous Message Bill Moran 2007-06-20 15:00:46 Re: Re: [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage