Re: Partitioning documentation example

On Fri, 2008-01-04 at 10:27 -0500, Bruce Momjian wrote:

> It seems to me it would be much clearer if we added a second example
> that used to_char() to create the INSERT statement dynamically based on
> NEW.logdate:
>
>     CREATE OR REPLACE FUNCTION measurement_insert_trigger()
>     RETURNS TRIGGER AS $$
>     BEGIN
>        EXECUTE 'INSERT INTO measurement_y' || to_char(NEW.logdate,'YYYY_mMM') || ' VALUES (NEW.*)';
>     END;
>     $$
>     LANGUAGE plpgsql;
>
> It will of course fail if the table does not exist, which I think is
> what we want.  This trigger function would not have to be modified when
> new tables are added.

I like your new trigger better than the old, but I am still
uncomfortable with recommending we use triggers with COPY for
performance reasons and we should add a caveat.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com