Re: WAL accumulating, Logical Replication pg 13

2021-06-11 Thread Willy-Bas Loos
Hi, I was going to follow up on this one, sorry for the long silence. The replication is working fine now, and I have no idea what the problem was. Not cool. If I find out, I will let you know. On Mon, May 31, 2021 at 6:06 PM Tomas Pospisek wrote: > Hi Willy-Bas Loos, > > On 31.05.21 17:32, Will

Re: How to pass a parameter in a query to postgreSQL 12

2021-06-11 Thread Jehan-Guillaume de Rorthais
On Wed, 9 Jun 2021 14:51:46 -0500 Hassan Camacho Cadre wrote: > Hello > > > I recently installed a postgreSQL v12, in previous version 8.3 in all my > queries I pass parameters using the character : > > SELECT > > public.tabla.id > > FROM > > public.tabla > > WHERE > > public.tabla.

Re: index unique

2021-06-11 Thread Marc Millas
Hi Alban, I plainly agree on the uniqueness thing. and on the fact that a PK with only a geometry column can be considered somehow "ill suited". That said, the PK we finally use contains, as said, 3 columns: --an id (integer column) --a topology describer (the text column) --and the geometry colum

Re: bottom / top posting

2021-06-11 Thread Bruce Momjian
On Thu, Jun 10, 2021 at 10:21:00PM +0200, Peter J. Holzer wrote: > > I wonder about the tolerance of the world we live in.  Somehow, I can deal > > with > > top-posting, bottom-posting, middle-posting, HTML eMail, straight-text > > eMails, > > 80-column eMails, variable-width eMails, occasional A

Re: Even more OT: Ditto machines [was: bottom / top posting]

2021-06-11 Thread Bruce Momjian
On Thu, Jun 10, 2021 at 01:52:24PM -0700, Dean Gibson (DB Administrator) wrote: > Tom mentioned "old-timers."  Remember "Ditto" machines?  Remember the odor?  > They were in common use when I was in high school (1960). > > https://en.wikipedia.org/wiki/Mimeograph Yeah, everyone at school would sm

Re: bottom / top posting

2021-06-11 Thread Nikolay Samokhvalov
My thoughts: https://twitter.com/samokhvalov/status/1403408281389789189. Apologies for top-posting. On Fri, Jun 11, 2021 at 10:04 AM Bruce Momjian wrote: > On Thu, Jun 10, 2021 at 10:21:00PM +0200, Peter J. Holzer wrote: > > > I wonder about the tolerance of the world we live in. Somehow, I can