{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404","repository_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL","labels_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404/comments","events_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404/events","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404","id":322983285,"number":404,"title":"Npgsql.PostgresException: 42601: syntax error at or near \"[\"","user":{"login":"bdparrish","id":720788,"avatar_url":"https://avatars2.githubusercontent.com/u/720788?v=4","gravatar_id":"","url":"https://api.github.com/users/bdparrish","html_url":"https://github.com/bdparrish","followers_url":"https://api.github.com/users/bdparrish/followers","following_url":"https://api.github.com/users/bdparrish/following{/other_user}","gists_url":"https://api.github.com/users/bdparrish/gists{/gist_id}","starred_url":"https://api.github.com/users/bdparrish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bdparrish/subscriptions","organizations_url":"https://api.github.com/users/bdparrish/orgs","repos_url":"https://api.github.com/users/bdparrish/repos","events_url":"https://api.github.com/users/bdparrish/events{/privacy}","received_events_url":"https://api.github.com/users/bdparrish/received_events","type":"User","site_admin":false},"labels":[{"id":355737763,"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/labels/invalid","name":"invalid","color":"fbca04","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":11,"created_at":"2018-05-14T21:11:54Z","updated_at":"2018-05-29T15:16:20Z","closed_at":"2018-05-27T08:09:57Z","author_association":"NONE","body":"Ran into this error message while trying to perform `dotnet ef database update` with my initial migration.\r\n\r\nAll of my explicit updates from the migration went fine according to the verbose output, but I hit a snag with this update to the database.\r\n\r\n```\r\ndbug: Microsoft.EntityFrameworkCore.Database.Command[20100]\r\n      Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']\r\n      CREATE UNIQUE INDEX \"RoleNameIndex\" ON \"AspNetRoles\" (\"NormalizedName\") WHERE [NormalizedName] IS NOT NULL;\r\nfail: Microsoft.EntityFrameworkCore.Database.Command[20102]\r\n      Failed executing DbCommand (23ms) [Parameters=[], CommandType='Text', CommandTimeout='30']\r\n      CREATE UNIQUE INDEX \"RoleNameIndex\" ON \"AspNetRoles\" (\"NormalizedName\") WHERE [NormalizedName] IS NOT NULL;\r\nNpgsql.PostgresException (0x80004005): 42601: syntax error at or near \"[\"\r\n   at Npgsql.NpgsqlConnector.<DoReadMessage>d__157.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult()\r\n   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n```\r\n\r\n> dotnet --version\r\n> 2.1.200\r\n\r\nhttps://github.com/dotnet/core/blob/master/release-notes/download-archives/2.1.200-sdk-download.md\r\n\r\nPlease let me know what other information I can give you to help out."},"comment":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/comments/392815434","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404#issuecomment-392815434","issue_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/404","id":392815434,"user":{"login":"bdparrish","id":720788,"avatar_url":"https://avatars2.githubusercontent.com/u/720788?v=4","gravatar_id":"","url":"https://api.github.com/users/bdparrish","html_url":"https://github.com/bdparrish","followers_url":"https://api.github.com/users/bdparrish/followers","following_url":"https://api.github.com/users/bdparrish/following{/other_user}","gists_url":"https://api.github.com/users/bdparrish/gists{/gist_id}","starred_url":"https://api.github.com/users/bdparrish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bdparrish/subscriptions","organizations_url":"https://api.github.com/users/bdparrish/orgs","repos_url":"https://api.github.com/users/bdparrish/repos","events_url":"https://api.github.com/users/bdparrish/events{/privacy}","received_events_url":"https://api.github.com/users/bdparrish/received_events","type":"User","site_admin":false},"created_at":"2018-05-29T15:16:20Z","updated_at":"2018-05-29T15:16:20Z","author_association":"NONE","body":"@roji Can you explain a little clearer as to what your understanding is?  This problem still seems to be an issue.  The provided sample app from @cleversoftware has a single migration script for the initial migration.  My project also was an initial migration using Npsql from the start.  So my erroneous `[` are from scripts created by EF in the background when building the migration scripts from all that I can see and understand.\r\n"}}
{"actor":{"display_login":"bdparrish"}}