Hi,
I noticed that test/authentication/t/003_peer.pl can fail when the system_user
name contains characters that require quoting in SQL, such as a hyphen.
The test creates a role using a name derived from the OS user:
$node->safe_psql('postgres', "CREATE ROLE $mapped_name LOGIN");
If $mapped_name contains a hyphen, this results in a syntax error.
The attached patch fixes this by properly quoting the role name:
$node->safe_psql('postgres', "CREATE ROLE \"$mapped_name\" LOGIN");
Regards,
Yugo Nagata
--
Yugo Nagata <nagata@sraoss.co.jp>
