Re: User's responsibility when using a chain of "immutable" functions?

2022-06-30 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > > b...@yugabyte.com wrote: >> >> Meanwhile. I'll appeal for some pointers to what I should read... > > I tend not to search...or at least that isn't my first (or at least only) > recourse. The pg/pgsql chapter has a subchapter named "Plan Caching": > > htt

Re: Function inside query status

2022-06-30 Thread Adrian Klaver
On 6/29/22 23:57, Rama Krishnan wrote: Hi All, Is it possible to check the query execution status inside the function.  created or replace function data_purge() returns void as$$ Declare Begin Drop table test_old; Create table test_old as select * from sales where bill_date-interval '1 year

Re: Fatel: unsupported frientend protocol error

2022-06-30 Thread Tom Lane
"David G. Johnston" writes: > On Thursday, June 30, 2022, Laurenz Albe wrote: >> On Thu, 2022-06-30 at 16:40 +0530, eswar reddy wrote: >>> Fatel: unsupported frientend protocol 1234.5680: server supports 1.0 to >>> 3.0 >> This is simple: upgrade the server to a supported version, ideally v14. >

pg_amcheck warnings after upgrade to 14.4

2022-06-30 Thread Aleš Zelený
Hello, we have suffered from BUG #17485, so we have upgraded our databases to 14.4. When (on 14.3 we discovered the issue all affected indexes were rebuilt [not concurrently]), so subsequent pg_amcheck --heapallindexed was without errors or warnings. After the upgrade to 14.4, we run pg_amcheck

Re: Fatel: unsupported frientend protocol error

2022-06-30 Thread David G. Johnston
On Thursday, June 30, 2022, Laurenz Albe wrote: > On Thu, 2022-06-30 at 16:40 +0530, eswar reddy wrote: > > Hi sir, I am getting below error for the past 3 month's plz can suggest > how to resolve this issue. > > > > PostgreSQL 9.6 version and Linux redhat 7.2 efm 4.1 plz > > > > Fatel: unsupport

Re: Fatel: unsupported frientend protocol error

2022-06-30 Thread Laurenz Albe
On Thu, 2022-06-30 at 16:40 +0530, eswar reddy wrote: > Hi sir, I am getting below error for the past 3 month's plz can suggest how > to resolve this issue. > > PostgreSQL 9.6 version and Linux redhat 7.2 efm 4.1 plz > > Fatel: unsupported frientend protocol 1234.5680: server supports 1.0 to 3.0

Fatel: unsupported frientend protocol error

2022-06-30 Thread eswar reddy
Hi sir, I am getting below error for the past 3 month's plz can suggest how to resolve this issue. PostgreSQL 9.6 version and Linux redhat 7.2 efm 4.1 plz Fatel: unsupported frientend protocol 1234.5680: server supports 1.0 to 3.0 This error continuesly getting in log file Thanks & Regards Eswa