Information regarding how to build libpq client using visual studio is missing
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/libpq-build.html Description: Current(12.2) documentation does not have information regarding how to build libpq client using visual studio is missing.It would be great help if this is specified in document
Re: Information regarding how to build libpq client using visual studio is missing
PG Doc comments form writes: > Current(12.2) documentation does not have information regarding how to build > libpq client using visual studio is missing.It would be great help if this > is specified in document There is no support anymore for building only libpq; you have to build the whole package, as described at https://www.postgresql.org/docs/current/install-windows.html Of course, you could discard the files you don't need afterwards. regards, tom lane
No docs for interaction of ON DELETE/UPDATE and permissions
I was planning to add a new table TA only writable by user A, with a foreign key reference with ON DELETE CASCADE to another table TB only writable by user B. My hope was that user B would still be allowed to delete rows in TB and cause cascading deletions in table TA, and some manual investigation makes it seem like that is the implemented semantics. However, I could not find a direct answer to my question in the docs. I looked primarily at https://www.postgresql.org/docs/current/sql-grant.html and https://www.postgresql.org/docs/current/sql-createtable.html . There are references to permissions required to create references, but not to the permissions (not, apparently) required to indirectly write to a table via referential actions. Am I correct that (a) no permissions are needed here and (b) this is undocumented and (c) it would be helpful to document this, probably in the CREATE TABLE docs? Happy to write a patch if so. --dave
