Re: insert trigger
От | |
---|---|
Тема | Re: insert trigger |
Дата | |
Msg-id | 1101.203.145.130.142.1036685325.squirrel@mail.trade-india.com обсуждение исходный текст |
Ответ на | insert trigger ("Roberto Benitez" <RBENITEZ@houston.rr.com>) |
Список | pgsql-admin |
Yes Roberto , Trigger are very relaible and are fired in intutive manner. (trigger is fired for every insert ) read documentation of create trigger regds mallah. regds mallah. > 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@yahoo.com ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
В списке pgsql-admin по дате отправления: