CREATE ... IF NOT EXISTS ...

[sroussey]

Describe the bug

I just started using this lib, so sorry if i am doing something obviously wrong...

Very first thing I try to do is create the table:

CREATE TABLE IF NOT EXISTS ....

Below is a smaller example with CREATE TYPE IF NOT EXISTS

PostgresError: QueryError: 💔 Your query failed to parse.
This is most likely due to a SQL syntax error. However, you might also have hit a bug, or an unimplemented feature of pg-mem.
If this is the case, please file an issue at https://github.com/oguimbal/pg-mem along with a query that reproduces this syntax error.

👉 Failed query:

    
    CREATE TYPE IF NOT EXISTS job_status AS ENUM ('NEW', 'PROCESSING', 'COMPLETED', 'FAILED', 'ABORTING');
    ;

💀 Syntax error at line 2 col 20:

1  
2      CREATE TYPE IF NOT EXISTS job_status AS ENUM ('NEW', 'PROCESSING', 'COMPLETED', 'FAILED', 'ABORTING');
                      ^
3      ;
Unexpected kw_not token: "not". Instead, I was expecting to see one of the following:

To Reproduce

CREATE TYPE IF NOT EXISTS job_status AS ENUM ('NEW', 'PROCESSING', 'COMPLETED', 'FAILED', 'ABORTING')

pg-mem version

3.0.4