Re: Rules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Rules
Date: 2004-06-09 14:03:25
Message-ID: 20556.1086789805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr> writes:
> CREATE RULE child_ins AS ON INSERT TO test.child
> DO INSTEAD SELECT test.testfi(NEW);

> INSERT INTO test.child(id,id_data,opis,podaci) VALUES (1,1,'Opis','podaci');

> (-403)ERROR: cannot handle whole-row reference

It works in CVS tip ;-). No chance in 7.4 or earlier, however.
You'll have to pass the components of the row as separate arguments
to the function.

regards, tom lane

In response to

  • Rules at 2004-06-09 11:50:25 from Darko Prenosil

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-09 14:10:19 Re: Improving postgresql.conf
Previous Message Tom Lane 2004-06-09 13:56:18 Re: Question regarding dynamic_library_path