| From: | Marc Spitzer <marc(at)oscar(dot)eng(dot)cv(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: should this be a trigger or a rule? |
| Date: | 2001-12-16 02:25:51 |
| Message-ID: | 20011215212551.A61980@oscar.eng.cv.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sat, Dec 15, 2001 at 09:04:20PM -0500, Tom Lane wrote:
> marc(at)oscar(dot)eng(dot)cv(dot)net (Marc Spitzer) writes:
> > I have 3 tables: pings, curr_state, ping_log and here is what I want
> > to happen:
> > when I insert a row into pings it checks to see if the ping was
> > sucessful or not.
>
> Anything that's most naturally described as driven by insert (or update
> or delete) of individual rows is best done as a trigger, IMHO.
>
> regards, tom lane
Thanks,
One last question, I am using Xemacs to auto format the code
for me, I have discovered the sql-postgres but that is only
in the postgres(psql) window not in the where I edit my code
window. I get this in lisp by using M-x load-library then ilisp
ams perl,tcl, C take care of them selves.
Thanks again,
marc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terrence Brannon | 2001-12-16 11:56:20 | Numbering Rows (SEQUENCE, OID) questions |
| Previous Message | Tom Lane | 2001-12-16 02:04:20 | Re: should this be a trigger or a rule? |