Writing values of 'Pgvector.Vector' is not supported for parameters having no NpgsqlDbType or DataTypeName. Try setting one of these values to the expected database type

[Issung]

Sorry I never do this but after 2 days I can't crack this nut and have reached my limit 😂

I've been getting this error when trying to save a type with a Vector column in it...

Writing values of 'Pgvector.Vector' is not supported for parameters having no NpgsqlDbType or DataTypeName. Try setting one of these values to the expected database type..

   at Npgsql.Internal.AdoSerializerHelpers.<GetTypeInfoForWriting>g__ThrowWritingNotSupported|1_0(Type type, PgSerializerOptions options, Nullable`1 pgTypeId, Nullable`1 npgsqlDbType, Exception inner)
   at Npgsql.Internal.AdoSerializerHelpers.GetTypeInfoForWriting(Type type, Nullable`1 pgTypeId, PgSerializerOptions options, Nullable`1 npgsqlDbType)
   at Npgsql.NpgsqlParameter.ResolveTypeInfo(PgSerializerOptions options)
   at Npgsql.NpgsqlParameterCollection.ProcessParameters(PgSerializerOptions options, Boolean validateValues, CommandType commandType)
   at Npgsql.NpgsqlCommand.<ExecuteReader>d__120.MoveNext()
   at Npgsql.NpgsqlCommand.<ExecuteReader>d__120.MoveNext()
   at Npgsql.NpgsqlCommand.<ExecuteDbDataReaderAsync>d__113.MoveNext()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.<ExecuteReaderAsync>d__18.MoveNext()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.<ExecuteReaderAsync>d__18.MoveNext()
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.<ExecuteAsync>d__50.MoveNext()

I've tried everything I can, today I created minimal projects following your guides, then another using IdentityDbContext thinking that may be the issue, nothing seems to fix it. I downloaded the Npgsql source code and mounted it to see where this exception was thrown and debug from there but couldn't figure it out much further.

My repo is relatively small it's just some prototyping with Razor Pages and your stuff. If you clone the commit linked below, startup the pg17 docker container, and try to run the DndTest project, it will try to do an insert of the type and reproduce the error immediately. The other projects are attempts at minimal reproductions but they don't reproduce 😭

Or if you just take a look at the source code or have some recommendations of things to try before doing that it would all be greatly appreciated 🙏

https://github.com/Issung/SemanticDnd/commit/83d430bfc82567575f6262a1f06abbedc23d1811

[ankane]

Hi @Issung, this looks like the same error as #31 and #41 (likely missing a call to useVector somewhere).

[Issung]

Thanks for the reply @ankane. I have this in my Program.cs. It works well enough that it is able to create the initial migration.
I'll try doing it in the DbContext's OnConfiguring override and see if that fixes it.

builder.Services.AddDbContext<DndDbContext>(options =>
{
    options.UseNpgsql(connectionString, o => o.UseVector());
    options.EnableSensitiveDataLogging();
});

[Issung]

That didn't fix it..

I cloned my project and started trimming things out until the program started to work.. What makes it or breaks it is app.UseHangfireDashboard()... I guess because it also uses the postgres database? Very bizarre. I can try to make a minimal reproducible example, but not sure who the fix would need to come from, you guys or the Hangfire.PostgreSql guys.. 😅

[ankane]

Looks like others have run into this as well: hangfire-postgres/Hangfire.PostgreSql#316

It sounds like Hangfire.PostgreSql has the same issue with NodaTime and there's a workaround: hangfire-postgres/Hangfire.PostgreSql#322 (comment)

[ankane]

We may be able to remove the NpgsqlConnection.GlobalTypeMapper call like other extensions did in npgsql/efcore.pg#3167, which may fix it.

[ankane]

Switched to the new plugin approach in this branch, but it requires EF Core 9.

[Issung]

Mre.zip

You're a couple steps ahead of me! Here's the minimal reproducible example. If it's not of use to you any more maybe it will be for someone else in the future, so I'll upload it anyway :)

[roji]

Switched to the new plugin approach in this branch, but it requires EF Core 9.

@ankane looks great, this is definitely the right direction from 9.0 onwards.

[ankane]

@roji Thanks for taking a look.

@Issung I probably won't merge / drop support for EF Core 8 until EF Core 10 is released, so I'd recommend using the workaround linked above in the meantime.

[Tuyetlangsa]

Hi @ankane , I have the same error. I use EF core 8 and not missing UseVector(). Can you give me how to fix that error.

---> Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> System.InvalidCastException: Writing values of 'Pgvector.Vector' is not supported for parameters having no NpgsqlDbType or DataTypeName. Try setting one of these values to the expected database type..
at Npgsql.Internal.AdoSerializerHelpers.g__ThrowWritingNotSupported|1_0(Type type, PgSerializerOptions options, Nullable1 pgTypeId, Nullable1 npgsqlDbType, Exception inner)
at Npgsql.Internal.AdoSerializerHelpers.GetTypeInfoForWriting(Type type, Nullable1 pgTypeId, PgSerializerOptions options, Nullable1 npgsqlDbType)
at Npgsql.NpgsqlParameter.ResolveTypeInfo(PgSerializerOptions options)
at Npgsql.NpgsqlParameterCollection.ProcessParameters(PgSerializerOptions options, Boolean validateValues, CommandType commandType)
at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)