Re: about partitioning - Mailing list pgsql-general

From Joao Ferreira gmail
Subject Re: about partitioning
Date
Msg-id 1221518929.7104.5.camel@jmf-ubuntu
Whole thread Raw
In response to Re: about partitioning  (Robert Treat <robert@omniti.com>)
Responses Re: about partitioning
Re: about partitioning
List pgsql-general
Hi Robert and all,


I've been trying to follow the examples on the pg docs, section 5.9,
with your presentation as aditional guide.

I've bumped into the UPDATES. I'm getting this:

----------------------------------------------------------
CREATE RULE measurement_update_y2004m02 AS ON UPDATE TO measurement
WHERE ( logdate >= DATE '2004-02-01' AND logdate < DATE '2004-03-01' )
DO INSTEAD UPDATE INTO measurement_y2004m02 VALUES (NEW.city_id,
NEW.logdate, NEW.peaktemp, NEW.unitsales);
ERROR:  syntax error at or near "INTO"
LINE 1: ...D logdate < DATE '2004-03-01' ) DO INSTEAD UPDATE INTO
measu...
-------------------------------------------------

it doesn't like the INTO part.

can you help me?

thanks
joao



On Sat, 2008-09-13 at 16:48 -0400, Robert Treat wrote:
> On Thursday 11 September 2008 07:47:00 Joao Ferreira gmail wrote:



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of memory on SELECT (from sort?) in 8.3
Next
From: kevin kempter
Date:
Subject: Re: about partitioning