Re: trigger failed to identify the partions

Sridhar Reddy Ratna wrote:
> 
>       cmd := 'INSERT INTO ' || dateTable  ||

>       EXECUTE cmd;

>       RETURN NEW;

> If I changed the RETURN NEW to RETURN NULL its inserting only one row.

Yes. RETURN NEW allows the insert to procede normally so you end up with
the two rows.

> But to work with hibernate I need the return NEW statement.

Hmm - not sure I can see a way around this. Maybe someone else who knows
Hibernate can help.

--  Richard Huxton Archonet Ltd