Using PostgreSQL namespaced data types results in syntax error

[nene]

For example:

CREATE TYPE public.my_type AS ENUM('a', 'b', 'c');

SELECT 'a'::public.my_type;

The select statement produces a parse error:

Syntax Error: Unexpected "."
Was expecting to see: ...
--> undefined:3:15
  |
3 | SELECT 'a'::public.my_type;
  |                   ^

Similarly in CREATE TABLE:

CREATE TABLE foo (id public.my_type);

[nene]

As we implement this, we should make sure that we parse the schema name as identifier and the data type name as data type. Something like:

public.INT   --> namespaced_data_type
                      /          \
                  schema      data_type
                    /               \
                public              INT

[nene]

This has been fixed. I think in release 0.37.0.

The namespaced data types are now parsed correctly. Though not as described in the above comment. On the Prettier plugin side, these custom types are formatted as identifiers, only the actual builtin data-types get special formatting. See release notes for prettier plugin 0.17.0