Search Postgresql Archives

Error or bug?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux