DB Error?
introspect, 22:14:23
Error
SQL Query
select "ns"."nspname" as "schema", "cls"."relname" as "name", (select coalesce(json_agg(agg), '[]') from (select "att"."attname" as "name", "typ"."typname" as "datatype", "tns"."nspname" as "datatype_schema", "fk_ns"."nspname" as "foreign_key_schema", "fk_cls"."relname" as "foreign_key_table", "fk_att"."attname" as "foreign_key_column", "pk_con"."conkey" is not null as "pk", "att"."attgenerated" != '' as "computed", "att"."attnotnull" != true as "nullable", coalesce((select json_agg("enm"."enumlabel") as "o" from "pg_catalog"."pg_enum" as "enm" where "enm"."enumtypid" = "typ"."oid"), '[]') as "options" from "pg_catalog"."pg_attribute" as "att" inner join "pg_catalog"."pg_type" as "typ" on "typ"."oid" = "att"."atttypid" inner join "pg_catalog"."pg_namespace" as "tns" on "tns"."oid" = "typ"."typnamespace" left join "pg_catalog"."pg_constraint" as "pk_con" on "pk_con"."contype" = 'p' and "pk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("pk_con"."conkey") left join "pg_catalog"."pg_constraint" as "fk_con" on "fk_con"."contype" = 'f' and "fk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("fk_con"."conkey") left join "pg_catalog"."pg_class" as "fk_cls" on "fk_cls"."oid" = "fk_con"."confrelid" left join "pg_catalog"."pg_namespace" as "fk_ns" on "fk_ns"."oid" = "fk_cls"."relnamespace" left join "pg_catalog"."pg_attribute" as "fk_att" on "fk_att"."attrelid" = "fk_cls"."oid" and "fk_att"."attnum" = any("fk_con"."confkey") where "att"."attrelid" = "cls"."oid" and "att"."attnum" >= 0 and "att"."attisdropped" != true) as agg) as "columns" from "pg_catalog"."pg_class" as "cls" inner join "pg_catalog"."pgnamespace" as "ns" on "cls"."relnamespace" = "ns"."oid" where "ns"."nspname" !~ '^pg' and "ns"."nspname" != 'information_schema' and "cls"."relkind" in ('r', 'v')
Error Details
Failed to upload schema to query engine: Bad Request
Error
SQL Query
select "ns"."nspname" as "schema", "cls"."relname" as "name", (select coalesce(json_agg(agg), '[]') from (select "att"."attname" as "name", "typ"."typname" as "datatype", "tns"."nspname" as "datatype_schema", "fk_ns"."nspname" as "foreign_key_schema", "fk_cls"."relname" as "foreign_key_table", "fk_att"."attname" as "foreign_key_column", "pk_con"."conkey" is not null as "pk", "att"."attgenerated" != '' as "computed", "att"."attnotnull" != true as "nullable", coalesce((select json_agg("enm"."enumlabel") as "o" from "pg_catalog"."pg_enum" as "enm" where "enm"."enumtypid" = "typ"."oid"), '[]') as "options" from "pg_catalog"."pg_attribute" as "att" inner join "pg_catalog"."pg_type" as "typ" on "typ"."oid" = "att"."atttypid" inner join "pg_catalog"."pg_namespace" as "tns" on "tns"."oid" = "typ"."typnamespace" left join "pg_catalog"."pg_constraint" as "pk_con" on "pk_con"."contype" = 'p' and "pk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("pk_con"."conkey") left join "pg_catalog"."pg_constraint" as "fk_con" on "fk_con"."contype" = 'f' and "fk_con"."conrelid" = "cls"."oid" and "att"."attnum" = any("fk_con"."conkey") left join "pg_catalog"."pg_class" as "fk_cls" on "fk_cls"."oid" = "fk_con"."confrelid" left join "pg_catalog"."pg_namespace" as "fk_ns" on "fk_ns"."oid" = "fk_cls"."relnamespace" left join "pg_catalog"."pg_attribute" as "fk_att" on "fk_att"."attrelid" = "fk_cls"."oid" and "fk_att"."attnum" = any("fk_con"."confkey") where "att"."attrelid" = "cls"."oid" and "att"."attnum" >= 0 and "att"."attisdropped" != true) as agg) as "columns" from "pg_catalog"."pg_class" as "cls" inner join "pg_catalog"."pgnamespace" as "ns" on "cls"."relnamespace" = "ns"."oid" where "ns"."nspname" !~ '^pg' and "ns"."nspname" != 'information_schema' and "cls"."relkind" in ('r', 'v')
Error Details
Failed to upload schema to query engine: Bad Request
