John Wells wrote:
I've noticed some oddities. The script connects to template1, drops the target database, creates the target database, and the rebuilds the tables. However, two specific tables and sequences are not dropped, although the drop command completes successfully.
Anyone know what might be happening? I'm at a loss.
Sounds like those two tables were created in the template database at some point.
HTH, Joe