How to reset a server error '25P02 in_failed_sql_transaction'

Hello, Due to a wrong human input in the GUI of our application our application server, from the point of view of the PostgreSQL server it is the PostgreSQL client, issues a broken ESQL/C command to the PostgreSQL server, here from our own debug logging the command and the error message of the s

Re: A JOIN question

On Mon, Dec 30, 2019 at 02:47:53PM -0700, Michael Lewis wrote: > > > > LEFT join mfg_vendor_relationship on > > mfg_vendor_relationship.mfg_key = mfg_part.mfg_key > > AND > > mfg_vendor_relationship.project_key = bom_item.project_key > > LEFT join vendor on > > mfg

Re: A JOIN question

> > LEFT join mfg_vendor_relationship on > mfg_vendor_relationship.mfg_key = mfg_part.mfg_key > AND > mfg_vendor_relationship.project_key = bom_item.project_key > LEFT join vendor on > mfg_vendor_relationship.vendor_key = vendor.vendor_key > Perhaps I am missing som

A JOIN question

I am working on a system whee one group of folks inputs portions of data into a table, and a 2nd completes the data for each row. The engineers enter in the items they need into a BOM table, and purchasing agents get quotes and create PO's. There is not a fixed relationship between the parts (par

Re: Need auto fail over cluster solution for PostGres

Em seg., 30 de dez. de 2019 às 13:30, Girish Kumar escreveu: > > Hello, > > I need to setup an auto fail over cluster for Postgres similar to Always Available Group(AAG) provided by Microsoft for SQL Server. Any suggestions? Prefer open source solutions(On Ubuntu) > Some FOSS options: https://gi

Need auto fail over cluster solution for PostGres

Hello, I need to setup an auto fail over cluster for Postgres similar to Always Available Group(AAG) provided by Microsoft for SQL Server. Any suggestions? Prefer open source solutions(On Ubuntu) Regards, Girish kumar Sent from Mail for Windows 1

Re: replace single char for string using regexp_replace

PegoraroF10 wrote: > I have a > Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),,'chr(39)') > It works but I would like to call just one Replace. For performance, it might be the fastest method, despite the lack of elegance and the mul