如何在django/django copg2中清理递归查询的postgres临时表

SELECT * FROM pg_temp_tables;

DROP TABLE IF EXISTS pg_temp.your_temp_table_name;

from django.db import connection

def cleanup_temp_tables():
    with connection.cursor() as cursor:
        cursor.execute("DROP TABLE IF EXISTS pg_temp.your_temp_table_name CASCADE;")

from django.db.models.signals import post_migrate
from django.dispatch import receiver
from django.db import connection

@receiver(post_migrate)
def cleanup_temp_tables(sender, **kwargs):
    with connection.cursor() as cursor:
        cursor.execute("DROP TABLE IF EXISTS pg_temp.your_temp_table_name CASCADE;")

from django.utils.deprecation import MiddlewareMixin
from django.db import connection

class TempTableCleanupMiddleware(MiddlewareMixin):
    def process_response(self, request, response):
        with connection.cursor() as cursor:
            cursor.execute("DROP TABLE IF EXISTS pg_temp.your_temp_table_name CASCADE;")
        return response

MIDDLEWARE = [
    # 其他中间件
    'your_app.middleware.TempTableCleanupMiddleware',
]