I have an admin script that drops a schema and then recreates it (quick way to refresh from backup). However, if the schema doesn't exist, the drop errors, as you would expect. The next SQL command, the schema create, is never executed.

I do not have ON_ERROR_STOP set so why is this happening? I don't want to split down to two calls of psql if possible, which is the present work-around. Would prefer to solve the problem.

Thanks,

Brad


---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Reply via email to