Jan, > > How do I drop a temporary table ( or for that matter a sequence) only > > if it exists or create them if they donot exist ? I want to do this > > to avoid any errors > > I wonder what type of application cannot remember if it created a temp > object or not during the lifetime of it's database connection.
A real one, Jan. This sort of test is particularly necessary for Exception handling routines. One wants the exception handler to drop all temporary obejcts for a clean slate, but since an exception has occurred, one cannot be sure which objects were created successfully. I've personally written several such routines. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
