insert trigger

From: "Roberto Benitez" <RBENITEZ(at)houston(dot)rr(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: insert trigger
Date: 2002-11-05 03:05:17
Message-ID: 000801c28478$2c97e810$6401a8c0@SUZIE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have the following situation:

when a new record is inserted in to a psql table, i want to be able to update certain fields. the way i'm doing it right now..to find the last record inserted...is by sorting the primary key (serial) in descending order and taking the first item in the list...the one at the top should be the one i just entered...and of course, i then procede to update the fieldsd i need to update..
So, basically would like to know if this will always work. will the one at the top (the one w/ the highest primary key [serial type]) always be the one i just entered. AND does psql ALWAYS execute the trigger(s) after EVERY single record that is inerted. what would happen if [ n ] different users try to insert records simultaniously? will psql insert one-execute the trigger, insert the next-execute the trigger..and so on? or will it insert ALL [n] records AND THEN execute the trigger?

i would appreciate any advice--if this would work, or if there is a better way.

thanks
rbenitez22(at)yahoo(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sonia Sánchez Díaz 2002-11-05 03:54:50 About lower and uppercase
Previous Message Stephan Szabo 2002-11-05 01:33:29 Re: Can't connect to PGSQL