On Thu, Sep 28, 2006 at 01:27:24PM +0300, Adnan DURSUN wrote: > Hi all > > I wanna know what is going on while a DML command works. For example > ; > Which commands are executed by the core when we send an "UPDATE tab > SET col = val1..." > in case there is a foreing key or an unique constraint on table > "tab". > > How can i see that ?
Didn't someone just ask this yesterday? I believe you can get that info by increasing client_min_messages. What you specifically have to set it to I don't know; my guess would be log or debug1. -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
