How should I mark a function which calls CURRENT_DATE? Parallel safe or 
parallel restricted?

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?

Mark Kolar

Sent using Guerrillamail.com
Block or report abuse: 

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to