On Wed, Feb 07, 2007 at 02:13:48PM +0100, Peter Eisentraut wrote: > What is the practical purpose of the notices emitted by DROP > SOMETHING IF EXISTS when the object in fact does not exist?
DROP ... IF EXISTS is guaranteed not to throw an error. This lets people write idempotent scripts which run in a transaction :) Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(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