Deleting a template and (re-)creating one with the same name fails #2152
Description
Steps to reproduce:
coder templates create docker -d ~/src/coder/examples/templates/dockercoder templates delete docker- Repeat 1.
Step 3 fails with the following error:
> Confirm create? (yes/no)
POST http://127.0.0.1:4000/api/v2/organizations/90193c29-7f21-4cce-9213-796b088ae170/templates: unexpected status code 500: Internal error inserting template.
Error: execute transaction: insert template: pq: duplicate key value violates unique constraint "templates_organization_id_name_key"