V-233576: If not exists

[karikarshivani]

Error:

expected "\nNOTICE:  role \"bob\" does not exist, skipping\nERROR:  relation \"test\" already exists\n" to match /CREATE TABLE/
Diff:
@@ -1,2 +1,4 @@
-/CREATE TABLE/
+
+NOTICE:  role "bob" does not exist, skipping
+ERROR:  relation "test" already exists

'DROP ROLE IF EXISTS bob; CREATE ROLE bob; CREATE TABLE test(id INT);'

should be modified to:

'DROP ROLE IF EXISTS bob; CREATE ROLE bob; DROP TABLE IF EXISTS test; CREATE TABLE test(id INT);'

---

Note: Try using IF NOT EXISTS to be less destructive. Consider using long and specific values for user names and table names - for example: inspec_postgres_test_user, inspec_postgres_test_table