marijnh / Postmodern

A Common Lisp PostgreSQL programming interface
http://marijnhaverbeke.nl/postmodern
Other
392 stars 90 forks source link

Minor bug fixes - Drop Role and Execute File #319

Closed sabracrolleton closed 1 year ago

sabracrolleton commented 1 year ago

Dollar Quoted tags are allowed in sql files. Prior to Postmodern version 1.33.8 only alphabetic characters were allowed in tags for purposes of the Postmodern execute-file function.

Postgresql documentation and industry practice allow any character to be in a dollar quoted tag. Postmodern version 1.33.8 relaxes the alphabetic character requirement. The only limitation now is that digit characters cannot be in the first position in a tag.

This version also fixes a bug in the postmodern function drop-role. Previously if a role owned objects in multiple databases, the drop-role function tried to drop the role before all owned objects were reassigned owners.