System.NotSupportedException: has unsupported column type when trying to use with postgresql enum

[AlenGeoAlex]

Hey folks! Hope you are doing well...

I was exploring the plugin and was faced with weird issue with enum. The database is PG17

Below is the error

# package csharp
error generating code: 
Unhandled Exception:
System.NotSupportedException: Column block_type has unsupported column type: post_block_type in NpgsqlDriver
   at SqlcGenCsharp.Drivers.DbDriver.GetCsharpTypeWithoutNullableSuffix(Column column, Query query)
   at EnumDbDriver.GetCsharpTypeWithoutNullableSuffix(Column column, Query query)
   at SqlcGenCsharp.Drivers.DbDriver.GetCsharpType(Column column, Query query)
   at SqlcGenCsharp.Generators.DataClassesGen.<>c__DisplayClass4_1.<GenerateAsCLass>b__2(Column column)
   at System.Linq.Enumerable.SelectIListIterator`2[[Plugin.Column, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[Microsoft.CodeAnalysis.CSharp.Syntax.MemberDeclarationSyntax, Microsoft.CodeAnalysis.CSharp, Version=4.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]].Fill(IList`1 , Span`1 , Func`2 )
   at System.Linq.Enumerable.SelectIListIterator`2[[Plugin.Column, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[Microsoft.CodeAnalysis.CSharp.Syntax.MemberDeclarationSyntax, Microsoft.CodeAnalysis.CSharp, Version=4.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]].ToArray()
   at System.Linq.Enumerable.ToArray[MemberDeclarationSyntax](IEnumerable`1 )
   at SqlcGenCsharp.Generators.DataClassesGen.<>c__DisplayClass4_0.<GenerateAsCLass>g__ColumnsToProperties|0()
   at SqlcGenCsharp.Generators.DataClassesGen.GenerateAsCLass(String className, IList`1 columns, Query query)
   at SqlcGenCsharp.Generators.DataClassesGen.Generate(String name, Nullable`1 classMember, IList`1 columns, Options options, Query query)
   at SqlcGenCsharp.Generators.ModelsGen.<GenerateDataClasses>b__14_3(<>f__AnonymousType1`2 <>h__TransparentIdentifier1)
   at System.Linq.Utilities.<>c__DisplayClass2_0`3[[<>f__AnonymousType0`2[[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[<>f__AnonymousType1`2[[<>f__AnonymousType0`2[[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[Microsoft.CodeAnalysis.CSharp.Syntax.MemberDeclarationSyntax, Microsoft.CodeAnalysis.CSharp, Version=4.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]].<CombineSelectors>b__0(<>f__AnonymousType0`2 x)
   at System.Linq.Enumerable.SelectEnumerableIterator`2[[<>f__AnonymousType0`2[[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[Microsoft.CodeAnalysis.CSharp.Syntax.MemberDeclarationSyntax, Microsoft.CodeAnalysis.CSharp, Version=4.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]].ToArray()
   at System.Linq.Enumerable.ToArray[MemberDeclarationSyntax](IEnumerable`1 )
   at SqlcGenCsharp.Generators.ModelsGen.GenerateDataClasses(Dictionary`2 tables)
   at SqlcGenCsharp.Generators.ModelsGen.GenerateFile(Dictionary`2 tables, Dictionary`2 enums)
   at SqlcGenCsharp.CodeGenerator.Generate(GenerateRequest generateRequest)
   at SqlcGenCsharp.PluginRunner.Run()
   at Program.<Main>$(String[] args)

This is the config

version: "2"
plugins:
  - name: csharp
    wasm:
      url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.22.2/sqlc-gen-csharp.wasm
      sha256: 40af6dbb1447fb42f9e12d094a79e5adbfcb3669470cf7055896a179ee2e7427
sql:
  - schema: "schema.sql"
    queries: "Queries"
    engine: postgresql
    codegen:
      - plugin: csharp
        out: Database.Gen
        options:
          useDapper: true
          withAsyncSuffix: true
          targetFramework: net8.0
          generateCsproj: true
          namespaceName: Database.Gen
          overrides:
            - column: "*:block_type"
              csharp_type:
                type: "string"
                notNull: true

This is the part of the schema

CREATE TYPE public.post_block_type AS ENUM (
    'text',
    'markdown',
    'media',
    'code',
    'html',
    'card_content',
    'embed'
);

CREATE TABLE public.post_block (
    id character varying(26) NOT NULL,
    block_ordinal integer NOT NULL,
    block_type public.post_block_type NOT NULL,
    post_id character varying(36) NOT NULL,
    content_data jsonb DEFAULT '{}'::jsonb NOT NULL,
    revision_id character varying(26) NOT NULL,
    vector_text tsvector
);

[SockworkOrange]

I don't think you should override enum columns, this is not supported:
Try removing that part:

          overrides:
            - column: "*:block_type"
              csharp_type:
                type: "string"
                notNull: true

[AlenGeoAlex]

I don't think you should override enum columns, this is not supported: Try removing that part:

          overrides:
            - column: "*:block_type"
              csharp_type:
                type: "string"
                notNull: true

Yes, I tried that too...It gives the same error

version: "2"
plugins:
  - name: csharp
    wasm:
      url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.22.2/sqlc-gen-csharp.wasm
      sha256: 40af6dbb1447fb42f9e12d094a79e5adbfcb3669470cf7055896a179ee2e7427
sql:
  - schema: "Database/[PACKAGE_NAME_PLACEHOLDER].Database.Sql/schema.sql"
    queries: "Database/[PACKAGE_NAME_PLACEHOLDER].Database.Sql/Queries"
    engine: postgresql
    codegen:
      - plugin: csharp
        out: Database/[PACKAGE_NAME_PLACEHOLDER].Database.Gen
        options:
          useDapper: false
          withAsyncSuffix: true
          targetFramework: net8.0
          generateCsproj: true
          namespaceName:[PACKAGE_NAME_PLACEHOLDER]Database.Gen

System.NotSupportedException: Column block_type has unsupported column type: post_block_type in NpgsqlDriver
   at SqlcGenCsharp.Drivers.DbDriver.GetCsharpTypeWithoutNullableSuffix(Column column, Query query)
   at EnumDbDriver.GetCsharpTypeWithoutNullableSuffix(Column column, Query query)
   at SqlcGenCsharp.Drivers.DbDriver.GetCsharpType(Column column, Query query)
   at SqlcGenCsharp.Generators.DataClassesGen.<>c__DisplayClass3_0.<GenerateAsRecord>b__0(Column column)
   at System.Linq.Enumerable.SelectIListIterator`2[[Plugin.Column, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].MoveNext()
   at System.String.Join(String separator, IEnumerable`1 values)
   at SqlcGenCsharp.ListExtensions.JoinByComma(IEnumerable`1 me)
   at SqlcGenCsharp.Generators.DataClassesGen.GenerateAsRecord(String className, IList`1 columns, Query query)
   at SqlcGenCsharp.Generators.DataClassesGen.Generate(String name, Nullable`1 classMember, IList`1 columns, Options options, Query query)
   at SqlcGenCsharp.Generators.ModelsGen.<GenerateDataClasses>b__14_3(<>f__AnonymousType1`2 <>h__TransparentIdentifier1)
   at System.Linq.Utilities.<>c__DisplayClass2_0`3[[<>f__AnonymousType0`2[[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[<>f__AnonymousType1`2[[<>f__AnonymousType0`2[[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[Microsoft.CodeAnalysis.CSharp.Syntax.MemberDeclarationSyntax, Microsoft.CodeAnalysis.CSharp, Version=4.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]].<CombineSelectors>b__0(<>f__AnonymousType0`2 x)
   at System.Linq.Enumerable.SelectEnumerableIterator`2[[<>f__AnonymousType0`2[[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.Dictionary`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.KeyValuePair`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Plugin.Table, GeneratedProtobuf, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], CodeGenerator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[Microsoft.CodeAnalysis.CSharp.Syntax.MemberDeclarationSyntax, Microsoft.CodeAnalysis.CSharp, Version=4.9.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]].ToArray()
   at System.Linq.Enumerable.ToArray[MemberDeclarationSyntax](IEnumerable`1 )
   at SqlcGenCsharp.Generators.ModelsGen.GenerateDataClasses(Dictionary`2 tables)
   at SqlcGenCsharp.Generators.ModelsGen.GenerateFile(Dictionary`2 tables, Dictionary`2 enums)
   at SqlcGenCsharp.CodeGenerator.Generate(GenerateRequest generateRequest)
   at SqlcGenCsharp.PluginRunner.Run()
   at Program.<Main>$(String[] args)