Re: Records count mismatch with logical replication

On Wed, 22 Jan, 2025, 03:11 Adrian Klaver, wrote: > On 1/21/25 11:40, Durgamahesh Manne wrote: > > > > > > On Wed, 22 Jan, 2025, 00:22 Adrian Klaver, > > wrote: > > > > > > > > On 1/21/25 10:06 AM, Durgamahesh Manne wrote: > > > > > > > > Hi Adrian

Re: Meaning of + symbol at end of column string

On Wed, 22 Jan 2025, David G. Johnston wrote: The value has a line break break character sequence at that point (I forget if it has any awareness of CR and CRLF differences…) David, Ah! A newline (\n). Thanks very much. I fix the row with an update and now I understand that the original input

Meaning of + symbol at end of column string

I use scripts to enter new rows in tables yet on rare occasions when I select all columns from a table I'll find a "+" at the end of a string value in one column. My web search finds no explanation. What does that + symbol mean in this context? TIA, Rich

Re: Meaning of + symbol at end of column string

On Wednesday, January 22, 2025, Rich Shepard wrote: > I use scripts to enter new rows in tables yet on rare occasions when I > select all columns from a table I'll find a "+" at the end of a string > value in one column. My web search finds no explanation. > > What does that + symbol mean in this

Re: Automatic deletion of orphaned rows

On Wed, Jan 22, 2025 at 9:37 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, January 22, 2025, Ron Johnson > wrote: >> >> >>> I therefore propose a feature, to be able to specify in a table schema >>> that a row should be deleted if orphaned. >> >> >> For one thing, rows

Re: Automatic deletion of orphaned rows

On Wed, Jan 22, 2025 at 2:00 AM Runxi Yu wrote: > I therefore propose a feature, to be able to specify in a table schema > that a row should be deleted if orphaned. > I think you mean "childless" rows, as "orphaned" has a different meaning traditionally. When and how would this deletion take pl

Re: Automatic deletion of orphaned rows

On Wednesday, January 22, 2025, Ron Johnson wrote: > > >> I therefore propose a feature, to be able to specify in a table schema >> that a row should be deleted if orphaned. > > > For one thing, rows *can't* be orphaned if there's a foreign key > reference. > The description was correct even thou

Re: Automatic deletion of orphaned rows

On Wed, Jan 22, 2025 at 2:00 AM Runxi Yu wrote: > Hi, > > While writing a new program, I encountered the following: > > I have three tables: A, B, and X. Rows in X are referenced by A and/or B > via foreign keys, one or more times. I would like to delete all orphaned > rows in X, i.e. a row in X

Re:

On 1/20/25 10:10, Lana ABADIE wrote: Hi all I bumped into a weird case that i don't really understand...maybe someone in this list could have a clue We have 2 Postgres databases configured as master/slave replica (Postgresq 12, RHEL8) We have applications which write data into the master and ap