Friday 18 November 2022

How To Resolve/Fix 'ServerManager' Object Has No Attribute 'user info' I...


Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.




Download pgAdmin 4: https://www.pgadmin.org/download/pgadmin-4-windows/ How To Resolve/Fix 'ServerManager' Object Has No Attribute 'user info' In PostgreSQL pgAdmin 4 v6.16 'ServerManager' object has no attribute 'user_info' For PostgreSQL 15, the pgAdmin is not supported. We have the pgAdmin 4 6.8 version. But we need to install the latest version which comes with the installation file for PostgreSQL. I have already made that video. The link is in the description to download that. So we need to download only the pgAdmin. If we want to keep our database as it is. The pgAdmin download link is given in the video description. We have version 6.8 but the latest v is 6.16 Before installing this one, let's close the pgAdmin. Open the pgAdmin 4 v6 As we can see, I am able to log in to PostgreSQL 15 version. Also, I can see my PostgreSQL 14 as well, along with my previous works. Well, if you don't want to keep the previous version at all. Uninstall the existing system PostgreSQL. Then install PostgreSQL 15, which will come with the latest version of pgAdmin 4 itself. Thanks for watching... How To Resolve/Fix 'ServerManager' Object Has No Attribute 'user info' In PostgreSQL pgAdmin 4, Resolve/Fix 'ServerManager' Object Has No Attribute 'user info', 'ServerManager' Object Has No Attribute 'user info', Resolve/Fix 'ServerManager' Object Has No Attribute 'user info', Resolve 'ServerManager' Object Has No Attribute 'user info', Fix 'ServerManager' Object Has No Attribute 'user info', PostgreSQL pgAdmin 4, PostgreSQL, internal server error, resolve server error, fix server manager, fix user info postgres

Wednesday 16 November 2022

How To Call A Stored Procedure From Another Stored Procedure In PostgreS...


Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.




/*In this video we will see how to call a stored procedure 
from another stored procedure in PostgreSQL PLpgSQL*/

-- Please watch till the end, and leave a like-comment.
-- Don't forget to subscribe the channel

CREATE OR REPLACE PROCEDURE public.proc1()
LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
BEGIN
 RAISE NOTICE 'This is proc 1, it will be called from proc2';
END;
$BODY$;

-- This is proc1 I have created
-- This will display the output
-- so, lets create it


CREATE OR REPLACE PROCEDURE public.proc2()
LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
BEGIN
RAISE NOTICE 'This is proc 2';
-- Calling another procedure proc1()
call proc1(); -- here it is
END;
$BODY$;

-- This is proc2
-- I am calling proc1 inside proc2
-- When it gets executed, it should give output like this

-- 'This is proc 2'
-- 'This is proc 1, it will be called from proc2'

-- Now, lets call the procedure

-- In the next video, I will show how to call a parameterized procedure or function with
-- OUT parameter
-- Please subscribe the channel to get updates for such videos

call proc2();

-- As shown, the procedure is getting called from another procedure
-- Thanks for watching
-- Please leave your comment for the video

-- Source codes you will find from video description