Re: [ADMIN] Strange locking behaviour

2002-02-22 Thread Tom Lane
Brian McCane <[EMAIL PROTECTED]> writes: > BEGIN WORK ; > SELECT stockid FROM stocks WHERE ticker = 'M$FT' FOR UPDATE ; > UPDATE stocks SET nextupdate = NOW + INTERVAL '1 DAY' ; > Insert 7 years of stock data > UPDATE stocks SET nextupdate = NOW() ; > COMMIT WORK ; What exactly does the "

[ADMIN] Strange locking behaviour

2002-02-22 Thread Brian McCane
I am running 7.2 on FreeBSD-current. I have an web page that I have been playing with for tracking stocks online. It has a table which contains all of my calculations. Once a day I pull down a report from MarketWatch of all stocks that meet a criterion I have defined. Once every 5 minutes I do