Re: Help with function - Mailing list pgsql-admin

From Tom Lane
Subject Re: Help with function
Date
Msg-id 7165.1124231040@sss.pgh.pa.us
Whole thread Raw
In response to Help with function  (Chris Hoover <revoohc@gmail.com>)
List pgsql-admin
Chris Hoover <revoohc@gmail.com> writes:
> If I try to do an insert into the mytable_view, everything is happy.
> If i try to do an update or delete, I get the error:ERROR:  record
> type has not been registered
> CONTEXT:  PL/pgSQL function "mytable_view_update" while storing call
> arguments into local variables

Well, the good news is this was fixed some time ago in CVS tip ... the
bad news is that back-porting the fix to 8.0 doesn't look real
practical :-(.  In 8.0 it'll only work if you're not using inheritance.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SQL Help - Obtaining ID of record INSERTED
Next
From: Ben Kim
Date:
Subject: Re: SQL Help - Obtaining ID of record INSERTED