set search_path = my_time_schema on db layer. After that you dont need to change any code. And can take for example freeze.fixed_date from config =)Some quick and dirty issue resolution is simple:
where my_time_schema contains all time function than I want to freeze.
Nevertheless i dont know how to deal with say localtimestamp with this approach %). Where localtimestamp is defined? pg_catalog doesnt have it
Some thoughts about localtimestamp redifinition with search_path?
"localtimestamp" isn't really a function but a keyword
that somewhat behaves as one.
Specifically those defined in 9.9.4
The fact that they can be used without adding the parenthesis is a big give-away. All true functions must use them. Note that these time function do allow parentheses but they have a different meaning - to specify precision as opposed to passing arguments - though the do look similar.
David J.
