How to rename a table in Aster?
if you are in a schema = ABC, but the search path schema does not have ABC, then it might be challenging to rename the table in schema ABC.
I think the transaction tric is not necessary. At least in recent version (I check v 7.0.2).
Aster's rename table prohibits target shcema and always renames it to same schema.
show search_path; -- "public" create table sandbox.t1(c1 int)distribute by replication; alter table rename sandbox.t1 to t2; select * from sandbox.t2; -- success select * from public.t2; -- fail (public.t2 does not exist)