Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't add new non-nullable JSON column #2965

Closed
dashiell-zhang opened this issue Nov 20, 2023 · 0 comments · Fixed by #2967
Closed

Can't add new non-nullable JSON column #2965

dashiell-zhang opened this issue Nov 20, 2023 · 0 comments · Fixed by #2967
Assignees
@roji
Labels
bug Something isn't working
Milestone
8.0.0

Comments

@dashiell-zhang
Copy link

Npgsql.EntityFrameworkCore.PostgreSQL Version 8.0.0-rtm-ci.20231119T221732

image

image

image

image

22P02: invalid input syntax for type json

DETAIL: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.

The default value of jsonb type field cannot be ""

The default value of an empty string will cause Update-Database to report an error
@roji roji self-assigned this Nov 20, 2023
@roji roji added the bug Something isn't working label Nov 20, 2023
@roji roji added this to the 8.0.0 milestone Nov 20, 2023
@roji roji changed the title There is a problem with the default value of jsonb field type Can't add new non-nullable JSON column Nov 20, 2023
roji added a commit to roji/efcore.pg that referenced this issue Nov 20, 2023
@roji
Fix adding a new non-nullable JSON column
1593640 
Fixes npgsql#2965
@roji roji mentioned this issue Nov 20, 2023
Merged
roji added a commit that referenced this issue Nov 20, 2023
@roji
Fix adding a new non-nullable JSON column (#2967)
4d34642 
Fixes #2965
@roji roji mentioned this issue Jan 26, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@roji roji

Labels
bug Something isn't working
Projects
None yet
Milestone
8.0.0
Development

Successfully merging a pull request may close this issue.

Fix adding a new non-nullable JSON column roji/efcore.pg
2 participants
@roji @dashiell-zhang