According to the documentation: "Functions and aggregates must be marked PARALLEL UNSAFE if they write to the database, access sequences, change the transaction state even temporarily (e.g. a PL/pgSQL function which establishes an EXCEPTION block to catch errors), or make persistent changes to settings." If a LANGUAGE C function calls ereport(ERROR, ...), does that qualify as a potential change to the transaction state that requires it to be marked PARALLEL UNSAFE? If an error is raised in one parallel worker, does this cause the other parallel workers to be immediately terminated? How about a C function f(x) that calls out to an external system and returns a text value. If f(x) is altered on the external system, it might return a slightly different answer for some x. Let's say that for some x it returns "one" instead of "1", and we happen to know that users don't care if it returns "one" or "1". If someone were to declare f(x) to be PARALLEL SAFE, what's the worst that could happen? ----- Jim Finnerty, AWS, Amazon Aurora PostgreSQL -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
