Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module

### Description

If we run the cmdlet

`Test-AzPostgreSqlFlexibleServerConnect -ResourceGroupName $serverResourceGroupName -Name $serverName -DatabaseName $databaseName -AdministratorUserName $aadAdministratorName -AdministratorLoginPassword $secureToken -ErrorAction Stop -QueryText $script`

The PowerShell host quits when the new version of needed PowerShell Module SimplySQL is installed, with version prior to 2.x the cmdlet works fine.

The issue occurs within file

`src/PostgreSql/PostgreSql.Autorest/custom/Test-AzPostgreSqlFlexibleServerConnect.ps1`

line 149 and 152 when Open-PostGreConnection is called. The new version of Open-PostGreConnection needs a Credential Parameter instead of Username and Password ([OpenPostGreConnection.vb](https://github.com/mithrandyr/SimplySql/blob/master/source/SimplySql.Cmdlets/ProviderCmdlets/OpenPostGreConnection.vb)), therefore you get a ParameterBindingException and then the cmdlet uses exit !!!! I highly recommend to rethrow the exception instead of closing the powershell session!

### Issue script & Debug output

```PowerShell
Can't paste because the powershell host quits ...
```


### Environment data

```PowerShell
Name                           Value
----                           -----
PSVersion                      7.4.3
PSEdition                      Core
GitCommitId                    7.4.3
OS                             Microsoft Windows 10.0.22621
Platform                       Win32NT
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0
```


### Module versions

```PowerShell
ModuleType Version    PreRelease Name                                PSEdition ExportedCommands
---------- -------    ---------- ----                                --------- ----------------
Script     12.0.0                Az                                  Core,Desk 
Script     3.0.0                 Az.Accounts                         Core,Desk {Disable-AzDataCollection, Disable-AzConΓÇª
Script     2.0.1                 Az.Advisor                          Core,Desk {Disable-AzAdvisorRecommendation, EnableΓÇª
Script     6.0.3                 Az.Aks                              Core,Desk {Disable-AzAksAddOn, Enable-AzAksAddOn, ΓÇª
Script     1.1.5                 Az.AnalysisServices                 Core,Desk {Add-AzAnalysisServicesAccount, Export-AΓÇª
Script     4.0.3                 Az.ApiManagement                    Core,Desk {Add-AzApiManagementApiToGateway, Add-AzΓÇª
Script     1.0.0                 Az.App                              Core,Desk {Disable-AzContainerAppRevision, Enable-ΓÇª
Script     1.3.1                 Az.AppConfiguration                 Core,Desk {Clear-AzAppConfigurationDeletedStore, GΓÇª
Script     2.2.5                 Az.ApplicationInsights              Core,Desk {Get-AzApplicationInsights, Get-AzApplicΓÇª
Script     1.0.1                 Az.ArcResourceBridge                Core,Desk {Get-AzArcResourceBridge, Get-AzArcResouΓÇª
Script     2.0.2                 Az.Attestation                      Core,Desk {Add-AzAttestationPolicySigner, Get-AzAtΓÇª
Script     1.0.1                 Az.Automanage                       Core,Desk {Get-AzAutomanageBestPractice, Get-AzAutΓÇª
Script     1.10.0                Az.Automation                       Core,Desk {Export-AzAutomationDscConfiguration, ExΓÇª
Script     3.6.1                 Az.Batch                            Core,Desk {Disable-AzBatchAutoScale, Disable-AzBatΓÇª
Script     2.0.4                 Az.Billing                          Core,Desk {Get-AzBillingAccount, Get-AzBillingInvoΓÇª
Script     3.2.0                 Az.Cdn                              Core,Desk {Clear-AzCdnEndpointContent, Clear-AzFroΓÇª
Script     2.0.1                 Az.CloudService                     Core,Desk {Get-AzCloudService, Get-AzCloudServiceIΓÇª
Script     1.14.1                Az.CognitiveServices                Core,Desk {Get-AzCognitiveServicesAccount, Get-AzCΓÇª
Script     8.0.0                 Az.Compute                          Core,Desk {Add-AzImageDataDisk, Add-AzVhd, Add-AzVΓÇª
Script     1.0.1                 Az.ConfidentialLedger               Core,Desk {Get-AzConfidentialLedger, New-AzConfideΓÇª
Script     4.0.1                 Az.ContainerInstance                Core,Desk {Add-AzContainerInstanceOutput, Get-AzCoΓÇª
Script     4.2.1                 Az.ContainerRegistry                Core,Desk {Connect-AzContainerRegistry, Get-AzContΓÇª
Script     1.14.3                Az.CosmosDB                         Core,Desk {Get-AzCosmosDBAccount, Get-AzCosmosDBAcΓÇª
Script     1.1.1                 Az.DataBoxEdge                      Core,Desk {Get-AzDataBoxEdgeBandwidthSchedule, GetΓÇª
Script     1.7.2                 Az.Databricks                       Core,Desk {Get-AzDatabricksAccessConnector, Get-AzΓÇª
Script     1.18.4                Az.DataFactory                      Core,Desk {Add-AzDataFactoryV2DataFlowDebugSessionΓÇª
Script     1.0.3                 Az.DataLakeAnalytics                Core,Desk {Get-AzDataLakeAnalyticsDataSource, New-ΓÇª
Script     1.3.1                 Az.DataLakeStore                    Core,Desk {Add-AzDataLakeStoreFirewallRule, Add-AzΓÇª
Script     2.4.0                 Az.DataProtection                   Core,Desk {Backup-AzDataProtectionBackupInstanceAdΓÇª
Script     1.0.2                 Az.DataShare                        Core,Desk {Get-AzDataShare, Get-AzDataShareAccountΓÇª
Script     1.1.0                 Az.DeploymentManager                Core,Desk {Get-AzDeploymentManagerArtifactSource, ΓÇª
Script     4.3.1                 Az.DesktopVirtualization            Core,Desk {Disconnect-AzWvdUserSession, Expand-AzWΓÇª
Script     1.1.1                 Az.DevCenter                        Core,Desk {Deploy-AzDevCenterUserEnvironment, Get-ΓÇª
Script     1.0.3                 Az.DevTestLabs                      Core,Desk {Get-AzDtlAllowedVMSizesPolicy, Get-AzDtΓÇª
Script     1.2.1                 Az.Dns                              Core,Desk {Add-AzDnsRecordConfig, Get-AzDnsRecordSΓÇª
Script     1.0.0                 Az.DnsResolver                      Core,Desk {Get-AzDnsForwardingRuleset, Get-AzDnsFoΓÇª
Script     1.0.2                 Az.ElasticSan                       Core,Desk {Add-AzElasticSanVolumeGroupNetworkRule,ΓÇª
Script     2.0.0                 Az.EventGrid                        Core,Desk {Disable-AzEventGridPartnerTopic, EnableΓÇª
Script     5.0.0                 Az.EventHub                         Core,Desk {New-AzEventHubAuthorizationRuleSASTokenΓÇª
Script     1.10.1                Az.FrontDoor                        Core,Desk {Disable-AzFrontDoorCustomDomainHttps, EΓÇª
Script     4.0.8                 Az.Functions                        Core,Desk {Get-AzFunctionApp, Get-AzFunctionAppAvaΓÇª
Script     6.1.0                 Az.HDInsight                        Core,Desk {Add-AzHDInsightClusterIdentity, Add-AzHΓÇª
Script     2.0.1                 Az.HealthcareApis                   Core,Desk {Get-AzHealthcareApisService, Get-AzHealΓÇª
Script     0.2.0                 Az.ImageBuilder                     Core,Desk {Get-AzImageBuilderRunOutput, Get-AzImagΓÇª
Script     2.7.6                 Az.IotHub                           Core,Desk {Add-AzIotHubCertificate, Add-AzIotHubCoΓÇª
Script     6.0.0                 Az.KeyVault                         Core,Desk {Add-AzKeyVaultCertificate, Add-AzKeyVauΓÇª
Script     2.3.1                 Az.Kusto                            Core,Desk {Add-AzKustoClusterLanguageExtension, AdΓÇª
Script     1.0.1                 Az.LoadTesting                      Core,Desk {Get-AzLoad, New-AzLoad, Remove-AzLoad, ΓÇª
Script     1.5.1                 Az.LogicApp                         Core,Desk {Get-AzIntegrationAccount, Get-AzIntegraΓÇª
Script     1.1.4                 Az.MachineLearning                  Core,Desk {Add-AzMlWebServiceRegionalProperty, ExpΓÇª
Script     1.0.1                 Az.MachineLearningServices          Core,Desk {Get-AzMLServiceQuota, Get-AzMLServiceUsΓÇª
Script     1.4.1                 Az.Maintenance                      Core,Desk {Get-AzApplyUpdate, Get-AzConfigurationAΓÇª
Script     1.2.1                 Az.ManagedServiceIdentity           Core,Desk {Get-AzFederatedIdentityCredential, Get-ΓÇª
Script     3.0.1                 Az.ManagedServices                  Core,Desk {Get-AzManagedServicesAssignment, Get-AzΓÇª
Script     2.0.1                 Az.MarketplaceOrdering              Core,Desk {Get-AzMarketplaceTerms, Invoke-AzMarketΓÇª
Script     1.1.2                 Az.Media                            Core,Desk {Sync-AzMediaServiceStorageKey, Set-AzMeΓÇª
Script     2.3.1                 Az.Migrate                          Core,Desk {Get-AzMigrateDiscoveredServer, Get-AzMiΓÇª
Script     5.2.1                 Az.Monitor                          Core,Desk {Add-AzLogProfile, Add-AzMetricAlertRuleΓÇª
Script     1.1.2                 Az.MySql                            Core,Desk {Get-AzMySqlConfiguration, Get-AzMySqlCoΓÇª
Script     7.6.0                 Az.Network                          Core,Desk {Add-AzApplicationGatewayAuthenticationCΓÇª
Script     1.0.1                 Az.NetworkCloud                     Core,Desk {Deploy-AzNetworkCloudCluster, Disable-AΓÇª
Script     1.0.1                 Az.Nginx                            Core,Desk {Get-AzNginxCertificate, Get-AzNginxConfΓÇª
Script     1.1.2                 Az.NotificationHubs                 Core,Desk {Get-AzNotificationHub, Get-AzNotificatiΓÇª
Script     3.2.1                 Az.OperationalInsights              Core,Desk {Disable-AzOperationalInsightsIISLogCollΓÇª
Script     1.6.5                 Az.PolicyInsights                   Core,Desk {Get-AzPolicyAttestation, Get-AzPolicyEvΓÇª
Script     1.1.1                 Az.PostgreSql                       Core,Desk {Get-AzPostgreSqlConfiguration, Get-AzPoΓÇª
Script     2.0.0                 Az.PowerBIEmbedded                  Core,Desk {Resume-AzPowerBIEmbeddedCapacity, SuspeΓÇª
Script     1.0.5                 Az.PrivateDns                       Core,Desk {Add-AzPrivateDnsRecordConfig, Get-AzPriΓÇª
Script     7.0.0                 Az.RecoveryServices                 Core,Desk {Add-AzRecoveryServicesAsrReplicationProΓÇª
Script     1.9.1                 Az.RedisCache                       Core,Desk {Export-AzRedisCache, Get-AzRedisCache, ΓÇª
Script     1.2.1                 Az.RedisEnterpriseCache             Core,Desk {Export-AzRedisEnterpriseCache, Get-AzReΓÇª
Script     2.0.1                 Az.Relay                            Core,Desk {Get-AzRelayAuthorizationRule, Get-AzRelΓÇª
Script     1.0.0                 Az.ResourceGraph                    Core,Desk {Search-AzGraph, Get-AzResourceGraphQuerΓÇª
Script     1.2.1                 Az.ResourceMover                    Core,Desk {Add-AzResourceMoverMoveResource, Get-AzΓÇª
Script     7.1.0                 Az.Resources                        Core,Desk {Export-AzResourceGroup, Export-AzTemplaΓÇª
Script     1.6.2                 Az.Security                         Core,Desk {Add-AzSecurityAdaptiveNetworkHardening,ΓÇª
Script     3.1.2                 Az.SecurityInsights                 Core,Desk {Get-AzSentinelAlertRule, Get-AzSentinelΓÇª
Script     4.0.0                 Az.ServiceBus                       Core,Desk {New-AzServiceBusAuthorizationRuleSASTokΓÇª
Script     3.3.3                 Az.ServiceFabric                    Core,Desk {Add-AzServiceFabricClientCertificate, AΓÇª
Script     2.0.1                 Az.SignalR                          Core,Desk {Get-AzSignalR, Get-AzSignalRKey, Get-AzΓÇª
Script     5.0.0                 Az.Sql                              Core,Desk {Add-AzSqlDatabaseToFailoverGroup, Add-AΓÇª
Script     2.2.1                 Az.SqlVirtualMachine                Core,Desk {Get-AzAvailabilityGroupListener, Get-AzΓÇª
Script     2.3.2                 Az.StackHCI                         Core,Desk {Add-AzStackHCIVMAttestation, Disable-AzΓÇª
Script     1.0.4                 Az.StackHCIVM                       Core,Desk {Add-AzStackHCIVMVirtualMachineDataDisk,ΓÇª
Script     7.0.0                 Az.Storage                          Core,Desk {Add-AzRmStorageContainerLegalHold, Add-ΓÇª
Script     1.3.1                 Az.StorageMover                     Core,Desk {Get-AzStorageMover, Get-AzStorageMoverAΓÇª
Script     2.1.1                 Az.StorageSync                      Core,Desk {Get-AzStorageSyncCloudEndpoint, Get-AzSΓÇª
Script     2.0.1                 Az.StreamAnalytics                  Core,Desk {Get-AzStreamAnalyticsCluster, Get-AzStrΓÇª
Script     2.0.0                 Az.Support                          Core,Desk {Get-AzSupportChatTranscript, Get-AzSuppΓÇª
Script     3.0.8                 Az.Synapse                          Core,Desk {Add-AzSynapseDataFlowDebugSessionPackagΓÇª
Script     1.2.2                 Az.TrafficManager                   Core,Desk {Add-AzTrafficManagerCustomHeaderToEndpoΓÇª
Script     3.2.1                 Az.Websites                         Core,Desk {Add-AzWebAppAccessRestrictionRule, Add-ΓÇª
Binary     2.0.2.182             AzureAD                             Desk      
Binary     2.0.2.149             AzureADPreview                      Desk
```


### Error output

```PowerShell
Can't paste because the powershell host quits ...
```


Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

Description

Issue script & Debug output

Environment data

Module versions

Error output

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

Description

Description

Issue script & Debug output

Environment data

Module versions

Error output

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions