Re: [HACKERS] strange behavior on locks

2006-01-22 Thread Alfranio Correia Junior
Perhaps you are using SELECT FOR UPDATE? I am not using SELECT FOR UPDATES... Could it have another cause ? ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] strange behavior on locks

2006-01-22 Thread Alfranio Correia Junior
I am executing some stored procedures written in pl/pgsql But wouldn't PostgreSQL show information per statement executed by the functions ? or SELECT func_with_side_effects() ? -Mike ---(end of broadcast)--- TIP 5: don't forget to

Re: [HACKERS] strange behavior on locks

2006-01-22 Thread Tom Lane
Alfranio Correia Junior [EMAIL PROTECTED] writes: I am executing some stored procedures written in pl/pgsql But wouldn't PostgreSQL show information per statement executed by the functions ? No. The command shown in the process status is always just the outermost operation.