Re: pg_stat_statements : how to catch non successfully finished statements ?

2020-04-30 Thread Tom Lane
legrand legrand writes: > Tom Lane-2 wrote >> The hard part here is that you have to be really careful what you do in >> a PG_CATCH block, because the only thing you know for sure about the >> backend's state is that it's not good. Catalog fetches are right out, >> and anything that might itself

Re: pg_stat_statements : how to catch non successfully finished statements ?

2020-04-30 Thread legrand legrand
Tom Lane-2 wrote > legrand legrand < > legrand_legrand@ > > writes: >> So the only solution is to had queryId to ErrorData in this hook >> or create a new hook fired on ERROR and containing queryId ? > > I see no particular need for a new hook. What's needed here is for > pgss_ExecutorRun (and

Re: Detecting renamed columns via pgouput in logical replication ?

2020-04-30 Thread Alvaro Herrera
On 2020-Apr-27, Andreas Andreakis wrote: > Are there plans to add comprehensive schema change detection abilities via > logical replication ? either by embedding more information into pgoutput or > perhaps by embedding the schema DDLs ? There aren't any plans currently that I am aware of. There

Re: script libraries?

2020-04-30 Thread Thomas Kellerer
Chris Stephens schrieb am 30.04.2020 um 15:54: as another Oracle DBA trying to pick up Postgresql one thing i haven't come across are script libraries such as there are for Oracle (https://github.com/tanelpoder/tpt-oracle and https://oracle-base.com/dba/scripts as examples). Does anything like t

Re: script libraries?

2020-04-30 Thread Pavel Stehule
čt 30. 4. 2020 v 15:54 odesílatel Chris Stephens napsal: > as another Oracle DBA trying to pick up Postgresql one thing i haven't > come across are script libraries such as there are for Oracle ( > https://github.com/tanelpoder/tpt-oracle and > https://oracle-base.com/dba/scripts as examples). >

script libraries?

2020-04-30 Thread Chris Stephens
as another Oracle DBA trying to pick up Postgresql one thing i haven't come across are script libraries such as there are for Oracle ( https://github.com/tanelpoder/tpt-oracle and https://oracle-base.com/dba/scripts as examples). Does anything like that exist for PG? Would be nice to see how peopl