Re: Inserting Data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inserting Data
Date: 2006-08-23 22:31:16
Message-ID: 25216.1156372276@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bob Pawley <rjpawley(at)shaw(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Silvela, Jaime (Exchange) 2006-08-23 22:36:09 Re: CASCADING could not open relation with OID
Previous Message Bob Pawley 2006-08-23 22:27:25 Re: Inserting Data