Re: Damaged (during upgrade?) table, how to repair?

2021-07-02 Thread Adrian Klaver
On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged (random files). Only problem that OS does not boot beyond "emergency mode". I would

Re: Damaged (during upgrade?) table, how to repair?

2021-07-02 Thread W.P.
W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: On 7/1/21 9:24 PM, W.P. wrote: W dniu 01.07.2021 o 22:27, Adrian Klaver pisze: On 7/1/21 12:56 PM, W.P. wrote: W dniu 01.07.2021 o 16:19, Laurenz Albe pisze: On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote: I have a PG 11.12 (was 9.5 or 9.5) upgra

[no subject]

2021-07-02 Thread Tom Lane
Igor Korot writes: > On Fri, Jul 2, 2021, 5:24 AM Atul Kumar wrote: >> -> Seq Scan on sam_participant pp (cost=0.00..777393.87 rows=56113 >> width=10) (actual time=0.277..10869.750 rows=2335154 loops=1) >> Filter: ((igroupid)::integer = >> (current_setting('env.groupid'::text))::integer

Re: Damaged (during upgrade?) table, how to repair?

2021-07-02 Thread Adrian Klaver
On 7/1/21 9:24 PM, W.P. wrote: W dniu 01.07.2021 o 22:27, Adrian Klaver pisze: On 7/1/21 12:56 PM, W.P. wrote: W dniu 01.07.2021 o 16:19, Laurenz Albe pisze: On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote: I have a PG 11.12 (was 9.5 or 9.5) upgraded from 9.x (during OS upgrade). One table is

Re:

2021-07-02 Thread Igor Korot
Hi, On Fri, Jul 2, 2021, 5:24 AM Atul Kumar wrote: > Hi, > > I have one query like below : > > > SELECT > m.iMemberId "memberId", > m.cFirstName "firstName", > m.cLastName "la

[no subject]

2021-07-02 Thread Atul Kumar
Hi, I have one query like below : SELECT m.iMemberId "memberId", m.cFirstName "firstName", m.cLastName "lastName", m.cFirstName || ' '