pgsql: Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security con

2024-02-08 Thread Heikki Linnakangas
Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security context The internal commands in REFRESH MATERIALIZED VIEW CONCURRENTLY are correctly executed in SECURITY_RESTRICTED_OPERATION mode, except for creating the temporary "diff" table, because you cannot create temporary tables in SRO mode.

pgsql: Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security con

2024-02-08 Thread Heikki Linnakangas
Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security context The internal commands in REFRESH MATERIALIZED VIEW CONCURRENTLY are correctly executed in SECURITY_RESTRICTED_OPERATION mode, except for creating the temporary "diff" table, because you cannot create temporary tables in SRO mode.

pgsql: Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security con

2024-02-08 Thread Heikki Linnakangas
Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security context The internal commands in REFRESH MATERIALIZED VIEW CONCURRENTLY are correctly executed in SECURITY_RESTRICTED_OPERATION mode, except for creating the temporary "diff" table, because you cannot create temporary tables in SRO mode.

pgsql: Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security con

2024-02-08 Thread Heikki Linnakangas
Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security context The internal commands in REFRESH MATERIALIZED VIEW CONCURRENTLY are correctly executed in SECURITY_RESTRICTED_OPERATION mode, except for creating the temporary "diff" table, because you cannot create temporary tables in SRO mode.

pgsql: Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security con

2024-02-08 Thread Heikki Linnakangas
Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security context The internal commands in REFRESH MATERIALIZED VIEW CONCURRENTLY are correctly executed in SECURITY_RESTRICTED_OPERATION mode, except for creating the temporary "diff" table, because you cannot create temporary tables in SRO mode.

pgsql: Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security con

2024-02-08 Thread Heikki Linnakangas
Run REFRESH MATERIALIZED VIEW CONCURRENTLY in right security context The internal commands in REFRESH MATERIALIZED VIEW CONCURRENTLY are correctly executed in SECURITY_RESTRICTED_OPERATION mode, except for creating the temporary "diff" table, because you cannot create temporary tables in SRO mode.