Re: trigger failed to identify the partions - Mailing list pgsql-sql

From Richard Huxton
Subject Re: trigger failed to identify the partions
Date
Msg-id 4AA7BD37.7020407@archonet.com
Whole thread Raw
In response to Re: trigger failed to identify the partions  ("Sridhar Reddy Ratna" <sridhar.ratna@cmcltd.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Little, Douglas"
Date:
Subject: how to: refer to select list calculations other places in the calculations.
Next
From: Jasen Betts
Date:
Subject: Re: Differences between bit string constant sintax