How should I mark a function which calls CURRENT_DATE? Parallel safe or
pg_proc shows that now() is marked as restricted, but transaction_timestamp()
is marked as safe.
The manual (https://www.postgresql.org/docs/9.6/static/functions-datetime.html)
says that "now() is a traditional PostgreSQL equivalent to
transaction_timestamp()" and "transaction_timestamp() is equivalent to
The code seems to confirm: GetSQLCurrentDate(), GetSQLCurrentTimestamp() and
now() all invoke the same GetCurrentTransactionStartTimestamp().
It looks like that functions which uses the CURRENT_* family of functions
should be marked as restricted (something to add to the docs) and that
transaction_timestamp() is incorrectly marked as safe.
Am I wrong?
Sent using Guerrillamail.com
Block or report abuse:
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: