Hello,
I'm trying to use table partitionning on a table called JOB.
Each month a new table is created to contain the rows created on that month.
ex : JOB_2011_11 for rows created during november 2011.
To do that I followed this advices on that page :
http://www.postgresql.org/docs/9.1/static/ddl-p
es (NEW.*)
Is there a way to solve this?
Isn't it a bug (in how EXECUTE works)?
On Wed, Nov 9, 2011 at 1:35 AM, Josh Kupershmidt wrote:
> On Tue, Nov 8, 2011 at 11:04 AM, Sylvain Mougenot
> wrote:
> > EXECUTE 'INSERT INTO '|| currentTableName || ' values
(NEW.*)*;
So it looks like a trouble with EXECUTE to me!
On Wed, Nov 9, 2011 at 8:25 PM, Josh Kupershmidt wrote:
> On Wed, Nov 9, 2011 at 6:57 AM, Sylvain Mougenot
> wrote:
>
> > Even if the query below is fine (the exact content I try to build as a
> > String to us
Hello,
I'm trying to use table partitionning on a table called JOB.
Each month a new table is created to contain the rows created on that month.
ex : JOB_2011_11 for rows created during november 2011.
To do that I followed this advices on that page :
http://www.postgresql.org/docs/9.1/static/ddl-p
From: Jasen Betts
> To: pgsql-sql@postgresql.org
> Date: 12 Nov 2011 09:56:02 GMT
> Subject: Re: Partitionning + Trigger and Execute not working as expected
> On 2011-11-08, Sylvain Mougenot wrote:
> > --f46d043c7fbad4a6b104b1357041
> > Content-Type: text/plain; charset=I
but could solve the problem temporarily.
I could even be turned on by some driver settings.
--
Sylvain Mougenot
re than 3 years old!
And still : The driver doesn't implement it.
So,
Does anyone know if there is a plan to implement this feature?
On Wed, Dec 14, 2011 at 3:01 PM, Craig Ringer wrote:
> On 14/12/2011 9:29 PM, Sylvain Mougenot wrote:
>
>> Even if the behaviour is not implemen
