RE: Additional Chapter for Tutorial
Hi all, I want to import XML file into PG database table. I've find functions to get the XML content of a cell after imported an XML file with the pg_get_file function. But, I want to explode the XML content to colums. How can I do this ? PG 10 under Ubuntu 18 _ Cordialement, Pascal CROZET DBA - Qualis Consulting • 300 Route Nationale 6 – 69760 LIMONEST _
Re: Transaction Management
On Wed, Jul 15, 2020 at 10:52:04AM +0100, James King wrote: > Hi Bruce, > > Thanks for taking a look at this. > > This is really about making a limitation obvious. In other parts of the > documentation, like table partitioning, limitations are really spelled out, > good solid health warnings for those uninitiated. For transactions we have > found that procedures cannot handle commit and rollbacks when marked as > security definer, we found this out through trial and error (we don't have a > clue as to why the limitation is in there and are trying to figure it out). > The only reference we found in the documentation was on https:// > www.postgresql.org/docs/11/sql-createprocedure.html with the line "A SECURITY > DEFINER procedure cannot execute transaction control statements (for example, > COMMIT and ROLLBACK, depending on the language)." We only spotted this when > digging as to find any information as to why we received this error. > > My reasoning of raising the point is it would have been really helpful for us > if the limitation was listed on the versions for https://www.postgresql.org/ > docs/13/plpgsql-transactions.html so we didn't sleepwalk into a limitation and > if documented there we can see when the limitation is raised (we can't figure > out what the problem is with security definer as it works so well for our use > case). Well, we try to put warnings at the places where it is most relevant, and I assume the CREATE PROCEDURE is the most relevent place to have it, and we do. Putting it in other places can get tiresome on the reader. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
Re: Add A Glossary
On 2020-Jul-21, Jürgen Purtz wrote: > - Added '(process)' to the two terms 'Autovacuum' and 'Stats Collector' > > - Removed link to himself in 'Logger (process)' > > - new term: Base Backup Pushed. I was not courageous enough to include "base backup" in 13, so that one's in master only, but the other ones are in both branches. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Re: Add A Glossary
On 19.06.20 19:10, Alvaro Herrera wrote: Thanks for these fixes! I included all of these. On 2020-Jun-19, Erik Rijkers wrote: And one thing that I am not sure of (but strikes me as a bit odd): there are several cases of 'are enforced unique'. Should that not be 'are enforced to be unique' ? I included this change too; I am not too sure of it myself. If some English language neatnik wants to argue one way or the other, be my guest. - Added '(process)' to the two terms 'Autovacuum' and 'Stats Collector' - Removed link to himself in 'Logger (process)' - new term: Base Backup -- Jürgen Purtz diff --git a/doc/src/sgml/glossary.sgml b/doc/src/sgml/glossary.sgml index 76525c6302..58e5071642 100644 --- a/doc/src/sgml/glossary.sgml +++ b/doc/src/sgml/glossary.sgml @@ -108,7 +108,7 @@ - Autovacuum + Autovacuum (process) A set of background processes that routinely perform @@ -178,6 +178,19 @@ + + Base Backup + + + A binary copy of all + database cluster + files. It is generated by the tool . + In combination with WAL files it can be used as the starting point + for recovery, log shipping, or streaming replication. + + + + Bloat @@ -855,8 +868,7 @@ Logger (process) - If activated, the - Logger process + If activated, the process writes information about database events into the current log file. When reaching certain time- or @@ -1486,7 +1498,7 @@ - Stats collector + Stats collector (process) This process collects statistical information about the