CamelCase notation for PostgreSQL function name might cause confusion.

https://github.com/IQSS/dataverse/blob/fbb215ac69b34fae63e0197e8d9d15b38d8424a9/doc/sphinx-guides/source/_static/util/createsequence.sql#L25

The actual function created by running this SQL statement is generateidentifierfromstoredprocedure(), without the CamelCase Capitals. If someone would for example manualy create a function with the CamelCase name it will not work, because PostgreSQL will add "" around the function name.

By the way, I used this functionality to get a PID with a random UUID4, by using the function like this:

CREATE OR REPLACE FUNCTION generateidentifierfromstoredprocedure()
RETURNS varchar AS $$
DECLARE
identifier varchar;
BEGIN
identifier := (select gen_random_uuid())::varchar;
RETURN identifier;
END;
$$ LANGUAGE plpgsql IMMUTABLE;

which works nicely :)!

great job on the multiple PID providers!

Stefan

Start with doc/sphinx-guides/source/_static/util/createsequence.sql at line 25 and inspect the function declaration and its documented name. Check how the function is referenced, then make the SQL and surrounding documentation consistently identify the callable PostgreSQL name; verify the resulting statement or references use the same name.