[BUG] Flaky test in contrib/gorm.io/gorm.v1

[ahmed-mez]

Describe what happened:

Example failure https://github.com/DataDog/dd-trace-go/actions/runs/6666970921/job/18119550075

=== Failed
=== FAIL: contrib/gorm.io/gorm.v1 TestCallbacks (unknown)

2023/10/27 12:14:42 /home/runner/work/dd-trace-go/dd-trace-go/contrib/gorm.io/gorm.v1/gorm_test.go:175 ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index" (SQLSTATE 23505)
[1.269ms] [rows:0] CREATE TABLE "products" ("id" bigserial,"created_at" timestamptz,"updated_at" timestamptz,"deleted_at" timestamptz,"code" text,"price" bigint,PRIMARY KEY ("id"))
2023/10/27 12:14:42 ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index" (SQLSTATE 23505)