Re: Inserting Data - Mailing list pgsql-general

From Tom Lane
Subject Re: Inserting Data
Date
Msg-id 25216.1156372276@sss.pgh.pa.us
Whole thread Raw
In response to Re: Inserting Data  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
Bob Pawley <rjpawley@shaw.ca> writes:
> I thought the NEW qualified the select.

Not at all; that would rather cripple the ability to write interesting
triggers.  I think what you are really wanting to do here is just

    insert into p_id.loops (monitor) values (new.devices_id);

            regards, tom lane

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: Inserting Data
Next
From: "Silvela, Jaime \(Exchange\)"
Date:
Subject: Re: CASCADING could not open relation with OID