yuniql postgresql gis extenstion

[dnyandeobharambe]

I am trying to deploy postgresql script where it have geospatial data . So it use corresponding data types. But it seems Yuniql does not support it and fail with following error

SqlState: 42704
MessageText: type "geometry" does not exist
Position: 138
File: parse_type.c
Line: 275
Routine: typenameType

--- End of inner exception stack trace ---
at Yuniql.Core.MigrationService.RunVersionSqlScripts(IDbConnection connection, IDbTransaction transaction, TransactionContext transactionContext, Stopwatch stopwatch, String version, String workspace, String scriptDirectory, String metaSchemaName, String metaTableName, List1 tokens, Nullable1 commandTimeout, String environment, String appliedByTool, String appliedByToolVersion)
at Yuniql.Core.MigrationService.<>c__DisplayClass12_0.g__RunVersionDirectoriesInternal|8(IDbConnection connection, IDbTransaction transaction, List1 scriptSubDirectories, String scriptDirectory, String versionDirectory, Stopwatch stopwatch) at Yuniql.Core.MigrationService.<>c__DisplayClass12_0.<RunVersionDirectories>b__7(<>f__AnonymousType02 version)
at System.Collections.Generic.List1.ForEach(Action1 )
at Yuniql.Core.MigrationService.RunVersionDirectories(IDbConnection connection, IDbTransaction transaction, List1 appliedVersions, String workspace, String targetVersion, TransactionContext transactionContext, List1 tokens, String bulkSeparator, String metaSchemaName, String metaTableName, Nullable1 commandTimeout, Nullable1 bulkBatchSize, String appliedByTool, String appliedByToolVersion, String environment, String transactionMode)
at Yuniql.Core.MigrationService.g__RunAllInternal|11_3(IDbConnection connection, IDbTransaction transaction, Boolean isRequiredClearedDraft, <>c__DisplayClass11_0& )
at Yuniql.Core.MigrationService.Run(String workspace, String targetVersion, Nullable1 isAutoCreateDatabase, List1 tokens, Nullable1 isVerifyOnly, String bulkSeparator, String metaSchemaName, String metaTableName, Nullable1 commandTimeout, Nullable1 bulkBatchSize, String appliedByTool, String appliedByToolVersion, String environment, Nullable1 isContinueAfterFailure, String transactionMode, Boolean isRequiredClearedDraft)
at Yuniql.Core.MigrationService.Run()
at Yuniql.CLI.CommandLineService.RunRunOption(RunOption opts)
If you think this is a bug, please report an issue here https://github.com/rdagumampan/yuniql/issues.

yuniql/error: The process 'C:\hostedtoolcache\windows\yuniql\0.0.0\x64\yuniql.exe' failed with exit code 1
##[error]The process 'C:\hostedtoolcache\windows\yuniql\0.0.0\x64\yuniql.exe' failed with exit code 1
Finishing: RunYuniqlCLI

[DavidPavlicek]

I have no problem with migration scripts containing PostGIS geomtery type. It looks like postgres does not know about geometry type. Did you enable PosGIS extension inside that database (create extension postgis;)?

[dnyandeobharambe]

Yes GIS extension is enabled Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

…

________________________________ From: David Pavlíček ***@***.***> Sent: Tuesday, March 28, 2023 10:17:57 PM To: rdagumampan/yuniql ***@***.***> Cc: dnyandeobharambe ***@***.***>; Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) I have no problem with migration scripts containing PostGIS geomtery type. It looks like postgres does not know about geometry type. Did you enable PosGIS extension inside that database (create extension postgis;)? — Reply to this email directly, view it on GitHub<#295 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AJJWEPESM2I5SZL4URHTQG3W6PAYLANCNFSM6AAAAAAWBXAZUI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[DavidPavlicek]

Can yuniql user acces postgis function and types? If you login into database as the same user, can you select 'POINT(1 1)'::geometry?

[dnyandeobharambe]

let me check Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

…

________________________________ From: David Pavlíček ***@***.***> Sent: Wednesday, March 29, 2023 1:25:59 PM To: rdagumampan/yuniql ***@***.***> Cc: dnyandeobharambe ***@***.***>; Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) Can yuniql user acces postgis function and types? If you login into database as the same user, can you select 'POINT(1 1)'::geometry? — Reply to this email directly, view it on GitHub<#295 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AJJWEPEOKAFWMRDLFE7KVN3W6SLFPANCNFSM6AAAAAAWBXAZUI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[dnyandeobharambe]

I check and saw some weird,instance I set in azure with gis,show all gis data type like polygon,point but not geometry,that could be issue as data type of table I am creating is geometry Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

…

________________________________ From: dny bha ***@***.***> Sent: Wednesday, March 29, 2023 4:02:35 PM To: rdagumampan/yuniql ***@***.***>; rdagumampan/yuniql ***@***.***> Cc: Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) let me check Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

________________________________ From: David Pavlíček ***@***.***> Sent: Wednesday, March 29, 2023 1:25:59 PM To: rdagumampan/yuniql ***@***.***> Cc: dnyandeobharambe ***@***.***>; Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) Can yuniql user acces postgis function and types? If you login into database as the same user, can you select 'POINT(1 1)'::geometry? — Reply to this email directly, view it on GitHub<#295 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AJJWEPEOKAFWMRDLFE7KVN3W6SLFPANCNFSM6AAAAAAWBXAZUI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[dnyandeobharambe]

Thanks It was issue with extensions, I reenable it and it works well Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

…

________________________________ From: dny bha ***@***.***> Sent: Wednesday, March 29, 2023 8:22:30 PM To: rdagumampan/yuniql ***@***.***>; rdagumampan/yuniql ***@***.***> Cc: Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) I check and saw some weird,instance I set in azure with gis,show all gis data type like polygon,point but not geometry,that could be issue as data type of table I am creating is geometry Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

________________________________ From: dny bha ***@***.***> Sent: Wednesday, March 29, 2023 4:02:35 PM To: rdagumampan/yuniql ***@***.***>; rdagumampan/yuniql ***@***.***> Cc: Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) let me check Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/AAb9ysg>

________________________________ From: David Pavlíček ***@***.***> Sent: Wednesday, March 29, 2023 1:25:59 PM To: rdagumampan/yuniql ***@***.***> Cc: dnyandeobharambe ***@***.***>; Author ***@***.***> Subject: Re: [rdagumampan/yuniql] yuniql postgresql gis extenstion (Issue #295) Can yuniql user acces postgis function and types? If you login into database as the same user, can you select 'POINT(1 1)'::geometry? — Reply to this email directly, view it on GitHub<#295 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AJJWEPEOKAFWMRDLFE7KVN3W6SLFPANCNFSM6AAAAAAWBXAZUI>. You are receiving this because you authored the thread.Message ID: ***@***.***>