The presence of a NULL "defaclacl" value in pg_default_acl prevents the dropping of a role.

2024-01-02 Thread ()
Hello postgres hackers: I recently came across a scenario involving system catalog "pg_default_acl" where a tuple contains a NULL value for the "defaclacl" attribute. This can cause confusion while dropping a role whose default ACL has been changed. Here is a way to reproduce that: ``` example

function "cursor_to_xmlschema" causes a crash

2023-09-18 Thread ()
Hello postgres hackers: I recently notice that function "cursor_to_xmlschema" can lead to a crash if the cursor parameter points to the query itself. Here is an example: postgres=# SELECT cursor_to_xmlschema('' :: refcursor, TRUE , FALSE , 'xxx' ) into temp; server closed the connection