{"action":"created","issue":{"url":"https://api.github.com/repos/dalibo/sqlserver2pgsql/issues/27","labels_url":"https://api.github.com/repos/dalibo/sqlserver2pgsql/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/dalibo/sqlserver2pgsql/issues/27/comments","events_url":"https://api.github.com/repos/dalibo/sqlserver2pgsql/issues/27/events","html_url":"https://github.com/dalibo/sqlserver2pgsql/issues/27","id":103580802,"number":27,"title":"Error when converting sql_variant data type column","user":{"login":"robotfoot","id":2722785,"avatar_url":"https://avatars.githubusercontent.com/u/2722785?v=3","gravatar_id":"","url":"https://api.github.com/users/robotfoot","html_url":"https://github.com/robotfoot","followers_url":"https://api.github.com/users/robotfoot/followers","following_url":"https://api.github.com/users/robotfoot/following{/other_user}","gists_url":"https://api.github.com/users/robotfoot/gists{/gist_id}","starred_url":"https://api.github.com/users/robotfoot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robotfoot/subscriptions","organizations_url":"https://api.github.com/users/robotfoot/orgs","repos_url":"https://api.github.com/users/robotfoot/repos","events_url":"https://api.github.com/users/robotfoot/events{/privacy}","received_events_url":"https://api.github.com/users/robotfoot/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-27T19:47:54Z","updated_at":"2015-08-27T20:00:39Z","closed_at":null,"body":"Hi,\r\n\r\nJust tried to run the script (table structure only). It looks like it barfed on attempting to convert a sql_variant data type\r\n\r\nCannot determine the PostgreSQL's datatype corresponding to sql_variant. This is a bug\r\n at C:\\Users\\Will\\Downloads\\dalibo-sqlserver2pgsql-d1ef8b7\\dalibo-sqlserver2pgsql-d1ef8b7\\sqlserver2pgsql.pl line 264, <$file> line 193.\r\n        main::convert_type(\"sql_variant\", undef, \"Value\", \"ActualProp_EquipmentActual\", undef, \"public\") called at C:\\Users\\Will\\Downloads\\dalibo-sqlserver2pgsql-d1ef8b7\\dalibo-sqlserver2pgsql-d1ef8b7\\sqlserver2pgsql.pl line 983\r\n        main::add_column_to_table(\"public\", \"ActualProp_EquipmentActual\", \"Value\", undef, \"sql_variant\", undef, undef, \"NULL\") called at C:\\Users\\Will\\Downloads\\dalibo-sqlserver2pgsql-d1ef8b7\\dalibo-sqlserver2pgsql-d1ef8b7\\sqlserver2pgsql.pl line 1103\r\n        main::parse_dump() called at C:\\Users\\Will\\Downloads\\dalibo-sqlserver2pgsql-d1ef8b7\\dalibo-sqlserver2pgsql-d1ef8b7\\sqlserver2pgsql.pl line 2444"},"comment":{"url":"https://api.github.com/repos/dalibo/sqlserver2pgsql/issues/comments/135536886","html_url":"https://github.com/dalibo/sqlserver2pgsql/issues/27#issuecomment-135536886","issue_url":"https://api.github.com/repos/dalibo/sqlserver2pgsql/issues/27","id":135536886,"user":{"login":"marco44","id":294693,"avatar_url":"https://avatars.githubusercontent.com/u/294693?v=3","gravatar_id":"","url":"https://api.github.com/users/marco44","html_url":"https://github.com/marco44","followers_url":"https://api.github.com/users/marco44/followers","following_url":"https://api.github.com/users/marco44/following{/other_user}","gists_url":"https://api.github.com/users/marco44/gists{/gist_id}","starred_url":"https://api.github.com/users/marco44/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marco44/subscriptions","organizations_url":"https://api.github.com/users/marco44/orgs","repos_url":"https://api.github.com/users/marco44/repos","events_url":"https://api.github.com/users/marco44/events{/privacy}","received_events_url":"https://api.github.com/users/marco44/received_events","type":"User","site_admin":false},"created_at":"2015-08-27T20:00:39Z","updated_at":"2015-08-27T20:00:39Z","body":"Hi,\r\n\r\nJust when I thought I couldn't see a weirder datatype coming from SQL Server… :)\r\n\r\nThis type isn't supported yet in sqlserver2pgsql. There is no equivalent datatype in PostgreSQL: anyelement/anyarray can only be used in functions. Data in tables should be typed, at least that is how PostgreSQL developpers see it…\r\n\r\nIf you have any idea about what I could convert it to… maybe just issue a warning and convert it to text, and store it as is. What do you think ?"}}