Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin

Поиск
Список
Период
Сортировка
От Satish Nayak [NMC - IT]
Тема Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin
Дата
Msg-id DFB6C970-1302-475E-9D19-6E0CC5227669@nmc.ae
обсуждение исходный текст
Ответ на Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения

Greetings All,

 

Thanks for the support, index rebuild solved the issue .

Sorry for duplicate request.

 

Regards,

 

Satish Chikkathammaiah,

Manager Database Administration

 

NMC Healthcare Ltd (In Administration)

Registered Office: DD#16 - 109 - 001, 16th Floor, WeWork Hub71,

Al Khatem Tower, ADGM Squre, Al Mariya Island, Abu Dhabi, UAE.

T: +971 2 207 6217 Ext: 15086  |  F: +971 2 633 2256  |  M: +971 509148678

9th Floor, Al Ain Tower, Khalidiyah, Abu Dhabi, UAE

 

 

 

From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Friday, February 18, 2022 at 8:05 PM
To: "Satish Nayak [NMC - IT]" <satish.nayak@nmc.ae>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin

 

***This email was sent from a source outside of NMC***

Do NOT ACT on any instructions given on email unless you recognize the Sender, If in doubt please contact the Sender directly for confirmation.Do not click on links or open attachments unless you recognize the sender.

 

On Fri, Feb 18, 2022 at 9:01 AM PG Bug reporting form <noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference:      17410
Logged by:          satish nayak
Email address:      satish.nayak@nmc.ae
PostgreSQL version: 12.9
Operating system:   Ubuntu 9.3.0-17ubuntu1~20.04  9.3.0, 64-bit
Description:       

After upgrade to postgresql 12.9 from 12.6 , some of the statements having
”=” operator not returning any rows..

 

Duplicate of a pgsql-admin email.

 

O/S Upgraded, needs to ReIndex.

 

David J.

 

'Classification: Restricted
On 27 September 2020 a number of the entities of the NMC Healthcare group were placed into administration under Abu Dhabi Global Market Regulations. Richard Fleming and Ben Cairns have been appointed Joint Administrators in this regard to manage the affairs, business and property of the relevant companies in administration as agents without personal liability. In that capacity the Joint Administrators have delegated certain powers to the board of directors to act as agents of the relevant companies. For full information regarding these appointments please redirect to this web page: https://nmc.ae/
This e-mail message including any attachments is intended solely for the addressee(s) and may contain privileged information. If you have received this email by mistake, please notify the sender and delete the message destroying any hard copies of the original message. This message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender. NMC accepts no liability for any damage caused by any virus/worms transmitted by this email..

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17410: After upgrade to postgresql 12.9 from 12.6 , some of the statements having ”=” operator not returnin
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pg_visibility's pg_check_visible() yields false positive when working in parallel with autovacuum