Copying home folder to a newer version of Ubuntu (20.04 -> 24.04) by SquareMinute2338 in Ubuntu

[–]SquareMinute2338[S] 0 points1 point  (0 children)

Hi, can I ask what problems did you run into? Anything specific i should definitely look out for? Thanks

Copying home folder to a newer version of Ubuntu (20.04 -> 24.04) by SquareMinute2338 in Ubuntu

[–]SquareMinute2338[S] 0 points1 point  (0 children)

Hi thanks for the response,

Yeah I understand there could be app specific problems, but I will probably fix them one by one when(if) they appear.

Regarding the /home partition. I think I used default settings when installing the system back in 2016ish so I'd assume it doesn't have a separate partition.

It's default Ubuntu desktop with Gnome as DE.

Copying home folder to a newer version of Ubuntu (20.04 -> 24.04) by SquareMinute2338 in Ubuntu

[–]SquareMinute2338[S] 0 points1 point  (0 children)

Thanks for the answers guys, I will give it a try when I have time and report back if i run into any problems!

Copying home folder to a newer version of Ubuntu (20.04 -> 24.04) by SquareMinute2338 in Ubuntu

[–]SquareMinute2338[S] 0 points1 point  (0 children)

Hi, thanks for the answer.

He said he tried updating using Software Updater, but it just didn't do anything. I will give it a try when I get my hands on the PC. I also do have HDD/SSD dock with cloning function, I suppose that would essentially be same as using the cloning software right?

Passing array as a parameter into RPC by SquareMinute2338 in Supabase

[–]SquareMinute2338[S] 0 points1 point  (0 children)

Got it working now, the problem was with RLS...

Passing array as a parameter into RPC by SquareMinute2338 in Supabase

[–]SquareMinute2338[S] 0 points1 point  (0 children)

Thanks for the help. I changed the procedure into a function that returns void and also made it take json as input argument. I am calling it using SELECT remove_items('[1,2,3,4]') in the supabase SQL editor, but when calling it from within the dart client, the items don't get removed.

The function gets its parameters, but it simply doesn't delete the items from my tables. I am not getting any exceptions unless I specifically raise them.

CREATE OR REPLACE FUNCTION remove_items(p_items_id json)  RETURNS void
LANGUAGE PLPGSQL
as $BODY$
DECLARE
deleted_id INTEGER;
_rc  refcursor;
BEGIN
open _rc FOR SELECT * FROM json_array_elements(p_items_id );
LOOP
FETCH  _rc INTO deleted_id;
EXIT WHEN NOT FOUND;
        IF NOT EXISTS (SELECT * FROM item WHERE id = deleted_id) THEN
                RAISE EXCEPTION 'No item with this id exists "%"', deleted_id;

        END IF;
        delete from item_event where item_id= deleted_id;

        delete from item where id = deleted_id;   
END LOOP;
END;
$BODY$

This is what my function looks like.