Chris Hoover <[EMAIL PROTECTED]> 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
Chris Hoover <[EMAIL PROTECTED]> writes:
> Ok, here is a bit more information, When I declare the function as
> function(view_name, view_name) an try to update my view. I am getting
> the following errors:
> ERROR: record type has not been registered
This is an internal bug. Are you running 8.
Chris Hoover <[EMAIL PROTECTED]> writes:
> I tried to define the function as function_name(new_rec view_name,
> old_rec view_name), but it abends on the call.
> function_name(new_rec view_name%rowtype, old_rec view_name%rowtype)
> will not compile.
> Can someone please provide some guidance on ho
Ok, here is a bit more information, When I declare the function as
function(view_name, view_name) an try to update my view. I am getting
the following errors:
ERROR: record type has not been registered
CONTEXT: PL/pgSQL function "clmhdr_view_update" while storing call
arguments into local varia
I need some help with how to define a function. I am trying to create
a function that I pass two records into. However, I can not seem to
get the syntax correct in the definition.
Exactly what I'm doing is having a rule on one of my views call a
function and pass the new.* and old.* records to t
On Thu, Jun 09, 2005 at 06:17:24PM +, Chris Hoover wrote:
> I am trying to write a very generic function to be used for table auditing.
> I am kind of stuck on how to make the function use the column names I pull
> from the db. Is there anyway to do what I have below? My main concern is
>
I am trying to write a very generic function to be used for table auditing. I
am kind of stuck on how to make the function use the column names I pull from
the db. Is there anyway to do what I have below? My main concern is this
segment:
if (new.columnName != old.columnName or
(old.c
