Transaction Management

2020-07-07 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html
Description:

Hello,

We are looking to use transaction management and have run into a limitation
when the procedure is security definer.  There doesn't appear to be any
reference to this in the
https://www.postgresql.org/docs/13/plpgsql-transactions.html so we cannot
see when the limitation is lifted.

Are you able to clarify the situation with this between PG11, 12 and 13?  We
are hoping the limitation is lifted as we cannot see what the reason for the
limitation is.

Thanks,
James


Wording about foreign key technically not correct

2020-07-07 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/ddl-constraints.html
Description:

As asked here,
https://dba.stackexchange.com/questions/270567/can-a-foreign-key-be-referring-to-the-same-table-as-the-source
the documentation specifies that a foreign key must reference another table.
But it can also be the same table.


Request for TDE Implementation Doc for Centos

2020-07-07 Thread murali maheswaram
Dear Team,

I am M Murali, working in an MNC. As part of the current requirement I am
working in implementing a POC to check the Postgres TDE implementation in
centOS.

*Version details:*
Postgres Version 12
Centos 8

Please could you provide me with the best standard document related to this
POC.

Thanks in advance!

Best Regards,
Murali M