Vincenzo Romano <vincenzo.romano@notorand.it> writes:
> 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
Works for me:
$ psql ...
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
...
regression=# create table table1(f1 int, f2 text);
CREATE TABLE
regression=# create or replace function foo() returns void as $$
declare var1 table1;
begin
select * into var1 from table1;
insert into table1 select var1.*;
end$$ language plpgsql;
CREATE FUNCTION
regression=# insert into table1 values(1,'one');
INSERT 0 1
regression=# select foo();
foo
-----
(1 row)
regression=# select * from table1;
f1 | f2
----+-----
1 | one
1 | one
(2 rows)
If that's not what you did, then let's see exactly what you did do.
regards, tom lane
