处理错误消息心理Copg2.ProgrammingError

Question

我如何处理错误，比如心理学2. psycopg2.ProgrammingError：

   try
      cursor.execute("CREATE TEMP TABLE temp_table1 AS SELECT 11 as a, 22 as b, 'Count' as unit; DROP TABLE temp_table1;")
      data = cursor.fetchall()
   except psycopg2.ProgrammingError as e:
        if print(e) == "no result to fetch":
            print("Skip Error - {}".format(e)
        else:
            raise(e)

cursor以前已经创建过了。

e.pgerror是零。

if print(e) == "no result to fetch"不起作用

我将运行具有返回值和不返回值的不同脚本。当脚本没有返回任何内容时，我如何处理这种情况？

更新： cursor.description是工作方式

   try
      cursor.execute("CREATE TEMP TABLE temp_table1 AS SELECT 11 as a, 22 as b, 'Count' as unit; DROP TABLE temp_table1;")
      if cursor.description:
            data = cursor.fetchall()
   except psycopg2.ProgrammingError as e:
        if print(e) == "no result to fetch":
            print("Skip Error - {}".format(e)
        else:
            raise(e)

Answer 1

cursor.description是工作方式

   try
      cursor.execute("CREATE TEMP TABLE temp_table1 AS SELECT 11 as a, 22 as b, 'Count' as unit; DROP TABLE temp_table1;")
      if cursor.description:
            data = cursor.fetchall()
   except psycopg2.ProgrammingError as e:
        if print(e) == "no result to fetch":
            print("Skip Error - {}".format(e)
        else:
            raise(e)