Code of Conduct: Russian Translation for Review

2021-02-26 Thread Stacey Haysler
The PostgreSQL Community Code of Conduct Committee has received a draft of the Russian translation of the Code of Conduct Policy updated August 18, 2020 for review.The English version of the Policy is at:https://www.postgresql.org/about/policies/coc/The translation was created by:Anastasia Raspopin

Re: PostgreSQL Licensing Question for pg_crypto and tablefunc extensions

2021-02-26 Thread Rumpi Gravenstein
David, Thank you -- that is exactly what I needed! On Fri, Feb 26, 2021 at 2:06 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Feb 26, 2021 at 12:01 PM Adrian Klaver > wrote: > >> Which refers to COPYRIGHT: >> >> >> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob

Old .deleted file in pg_wal

2021-02-26 Thread Guy Burgess
Hello, There is a file in my pg_wal directory called "0001003B00D0.deleted", last modified in December 2020, and has survived PG & server restarts.  I've been having some errors with WAL files (https://www.postgresql.org/message-id/flat/095ccf8d-7f58-d928-427c-b17ace23cae6%40burge

Re: PostgreSQL URI

2021-02-26 Thread Tom Lane
=?utf-8?Q?Paul_F=C3=B6rster?= writes: > sorry, I just realized I used a redundant @ character. So here's the > corrected version. Actually we need a patch against the SGML sources, not the generated files. I took this and marked it up into SGML, and (as usual when looking at this text, it seems

Re: PostgreSQL Licensing Question for pg_crypto and tablefunc extensions

2021-02-26 Thread David G. Johnston
On Fri, Feb 26, 2021 at 12:01 PM Adrian Klaver wrote: > Which refers to COPYRIGHT: > > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=COPYRIGHT;h=655a3c59d60f54a824cc8ad6c94a4522f2b465cd;hb=HEAD > > The COPYRIGHT file indeed is serving as the in-repo documentation of our license.

Re: PostgreSQL URI

2021-02-26 Thread Paul Förster
Hi Tom, > On 26. Feb, 2021, at 19:02, Paul Förster wrote: > > as I said, I don't know how to write a patch. But I played around with diff & > patch. > > However, does this do when applied to > https://www.postgresql.org/docs/current/libpq-connect.html? Would this be > what is needed? sorry,

Re: PostgreSQL Licensing Question for pg_crypto and tablefunc extensions

2021-02-26 Thread Adrian Klaver
On 2/26/21 10:39 AM, Rumpi Gravenstein wrote: Tom Thanks for the quick reply.  What you stated is what I was expecting. I've searched high and low for the documentation that proves that point -- something I need to do to satisfy our legal team.  Any thoughts on under which rock that license

Re: PostgreSQL Licensing Question for pg_crypto and tablefunc extensions

2021-02-26 Thread Rob Sargent
On 2/26/21 11:39 AM, Rumpi Gravenstein wrote: Tom Thanks for the quick reply.  What you stated is what I was expecting. I've searched high and low for the documentation that proves that point -- something I need to do to satisfy our legal team.  Any thoughts on under which rock that license

Re: PostgreSQL Licensing Question for pg_crypto and tablefunc extensions

2021-02-26 Thread Rumpi Gravenstein
Tom Thanks for the quick reply. What you stated is what I was expecting. I've searched high and low for the documentation that proves that point -- something I need to do to satisfy our legal team. Any thoughts on under which rock that license language exists? Best Regards, Rumpi On Thu, Feb

Re: PostgreSQL URI

2021-02-26 Thread Paul Förster
Hi Tom, > On 26. Feb, 2021, at 17:13, Tom Lane wrote: > > WFM. Who's going to write the patch? (I can, but if one of you > wants to, be my guest.) as I said, I don't know how to write a patch. But I played around with diff & patch. However, does this do when applied to https://www.postgres

Re: Batch update million records in prd DB

2021-02-26 Thread Michael Lewis
It might be a concern, but generally that should be a row level lock and only block other update/delete options on those rows. It might be helpful to look at the explain analyze output early on vs later in the process. It might be that you are getting very few hot updates and indexes are being upda

Re: PostgreSQL URI

2021-02-26 Thread Paul Förster
Hi Tom, > On 26. Feb, 2021, at 17:13, Tom Lane wrote: > > WFM. Who's going to write the patch? (I can, but if one of you > wants to, be my guest.) I don't know how to write a patch. Is there any documentation about that? Cheers, Paul

Re: PostgreSQL URI

2021-02-26 Thread Tom Lane
Alvaro Herrera writes: > On 2021-Feb-26, Paul Förster wrote: >> if you remove the outer brackets of host spec, then that means that >> only the port may be repeated. The repeat is always meant to refer to >> its immediate preceding argument. The outer brackets make sure that it >> refers to either

Re: PostgreSQL URI

2021-02-26 Thread Alvaro Herrera
On 2021-Feb-26, Paul Förster wrote: > Hi Tom, > > > On 26. Feb, 2021, at 15:51, Tom Lane wrote: > > > > +1. I think you could lose the outer brackets in hostspec in > > this formulation, ie given that hostspec is already bracketed > > above, it should be enough to write > > > >hostspec is

Re: PostgreSQL URI

2021-02-26 Thread Paul Förster
Hi Tom, > On 26. Feb, 2021, at 15:51, Tom Lane wrote: > > +1. I think you could lose the outer brackets in hostspec in > this formulation, ie given that hostspec is already bracketed > above, it should be enough to write > >hostspec is [host][:port][,...] > > Also, the paramspec is under-

Re: PostgreSQL URI

2021-02-26 Thread Tom Lane
Alvaro Herrera writes: > I wonder if we shouldn't instead try to break it up in parts that can be > explained or described separately. This many brackets makes it pretty > hard to read. > We could say something like > postgresql://[userspec@][hostspec][/dbname][?paramspec] > where > userspec

Re: PostgreSQL URI

2021-02-26 Thread Paul Förster
Hi Alvaro, > On 26. Feb, 2021, at 15:30, Alvaro Herrera wrote: > > We could say something like > > postgresql://[userspec@][hostspec][/dbname][?paramspec] > > where > userspec is user[:password] > hostspec is [[host][:port]][,...] > paramspec is param1=value1&... > > which makes it easier

Re: PostgreSQL URI

2021-02-26 Thread Alvaro Herrera
On 2021-Feb-25, Paul Förster wrote: > So, my suggestion is: > > postgresql://[user[:password]@][[host][:port]][,...][/dbname][?param1=value1&...] > > Still, I think that it's an improvement, because it makes clear that not only > the port, but also the host may be repeated. I wonder if we shou

Re: Tables used by a function

2021-02-26 Thread Laurenz Albe
On Fri, 2021-02-26 at 13:12 +0200, Yambu wrote: > Is there a quick way to list tables used by a function if the function is big > to search for tables manually? No. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com

Tables used by a function

2021-02-26 Thread Yambu
Hello Is there a quick way to list tables used by a function if the function is big to search for tables manually? regards