PostgreSQL table with enum column and default value

[foarsitter]

Thank you for your beautiful piece of work!

Parsing a table with an enum column with a default results in a missing table. Removing the default solves this problem.

Here is a minimum viable DDL:

CREATE TYPE public.blog_categories_visibility AS ENUM (
    'public',
    'protected',
    'private'
);

CREATE TABLE public.blog_categories (
    id integer NOT NULL,
    client_id integer,
    name character varying(255),
    slug character varying(255),
    color character varying(16),
    published boolean DEFAULT true NOT NULL,
    visibility public.blog_categories_visibility DEFAULT 'public'::public.blog_categories_visibility NOT NULL,
    filter_id integer
);

Thanks again!

[xnuinside]

@foarsitter thanks for opening the issue, will be fixed in version 1.7.0, working on it

[xnuinside]

@foarsitter released in version 1.7.0 #287 https://pypi.org/project/simple-ddl-parser/1.7.0/ . Thanks for opening the issue, if will be needed anything else - feel free to open new one

[foarsitter]

Thanks for you quick action!