On Thu, 2023-03-16 at 13:20 +0000, Dolan, Sean wrote: > I messed up and confused issues. The error is : > ERROR: Could not extend pg_tblspc/16555/PG_13_20200/xxxx/xxxx No space left > on device > HINT: Check free disk space > > So the schema is "full" and the offender is this one table. > I can't TRUNCATE as there needs to be space to perform the action. > Is there a way to see if there is a transaction on that table like you allude > to?
Ah, that's different. If you don't have enough space to run TRUNCATE, and you don't feel like extending the disk space, DROP TABLE would be a convenient alternative. Yours, Laurenz Albe
