Browsing Archive: December, 2020

How to find List of Stored Procedures/ Functions in PostgresSQL Database

Posted by jineesh uvantavida on Wednesday, December 23, 2020,
Finding procedures without schema name

select n.nspname as schema_name, p.proname as specific_name, l.lanname as language, case when l.lanname = 'internal' then p.prosrc else pg_get_functiondef(p.oid) end as definition, pg_get_function_arguments(p.oid) as arguments from pg_proc p left join pg_namespace n on p.pronamespace = n.oid left join pg_language l on p.prolang = l.oid left join pg_type t on t.oid = p.prorettype where n.nspname not in (...
Continue reading ...
 

RazorTagHelper - DOTNET_HOST_PATH is not set -Error MSB4018

Posted by jineesh uvantavida on Wednesday, December 2, 2020, In : asp.net 

After updating VS 2019 16.8.2 There will be an error on compilation on any project:


dot net --version : 5.0.100

Severity Code Description Project File Line Suppression State

Error MSB4018 The "RazorGenerate" task failed unexpectedly.
System.InvalidOperationException: DOTNET_HOST_PATH is not set at Microsoft.AspNetCore.Razor.Tasks.DotNetToolTask.get_DotNetPath()
at Microsoft.AspNetCore.Razor.Tasks.DotNetToolTask.GenerateFullPathToTool()
at Microsoft.Build.Utilities.ToolTask.ComputePathToTool() a...


Continue reading ...
 
 

Translate This Page

 


Make a free website with Yola