Re: triggers and execute... - Mailing list pgsql-general

From Scott Marlowe
Subject Re: triggers and execute...
Date
Msg-id dcc563d10904271437j18517354j56e72c8021fb6e8f@mail.gmail.com
Whole thread Raw
In response to Re: triggers and execute...  (Richard Broersma <richard.broersma@gmail.com>)
Responses Re: triggers and execute...
List pgsql-general
On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Mon, Apr 27, 2009 at 1:32 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> OK, I'm hitting a wall here.  I've written this trigger for partitioning:
>>
>> create or replace function page_access_insert_trigger ()
>> returns trigger as $$
>> DECLARE
>>        part text;
>>        q text;
>> BEGIN
>>        part = to_char(new."timestamp",'YYYYMMDD');
>>        q = 'insert into page_access_'||part||' values (new.*)';
>> ...
>>
>> When I create it and try to use it I get this error:
>> ERROR:  NEW used in query that is not in a rule
>> CONTEXT:  SQL statement "insert into page_access_20090427 values (new.*)"
>
> At this point I don't think that there is a way for this function to
> know the correct table type of new.* since page_access_... is still
> only a concatenated string.  There there a way to cast new.* to the
> correct table type as part of this insert statement?

I tried casting the new.*::page_access and that didn't work.  For now
I'll carry on with the complete listing of everything.

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: Query organization question
Next
From: Tom Lane
Date:
Subject: Re: how do you get there from here?