Re: [GENERAL] partitioned table insert triggers

On Mon, 2008-06-23 at 10:18 +0900, ITAGAKI Takahiro wrote:

You need to do so in 8.3:
    EXECUTE 'INSERT INTO ' || ctable ||
            ' VALUES( (' || quote_literal(new) || '::' || ptable || ').*)';

In 8.4, the next release, you will be able to use a better way:
    EXECUTE 'INSERT INTO ' || ctable || ' VALUES( ($1).* )' USING new;

Domo arigato, Itagaki-san. (I think I got that right.)

The 8.3 method works like a charm.

-Reece

-- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0