Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
wrote: On 3/1/25 19:35, Krishnakant Mane wrote: For my future reference does something like this response work better? -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.linkedin.co

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
On 3/1/25 22:17, Adrian Klaver wrote: On 2/28/25 21:29, Krishnakant Mane wrote: All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine. How did you

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
pinpoint the issue. Regards. -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist -- Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.link

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
On 3/2/25 07:54, David G. Johnston wrote: On Saturday, March 1, 2025, Krishnakant Mane wrote: pg_ivm | 1.10 | pg_catalog plpgsql | 1.0 | pg_catalog. 2) show search_path; "$user" public. 3) \df *.create_immv pgivm | create_immv | bigint | text, t

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
On 3/2/25 07:54, David G. Johnston wrote: On Saturday, March 1, 2025, Krishnakant Mane wrote: pg_ivm | 1.10 | pg_catalog plpgsql | 1.0 | pg_catalog. 2) show search_path; "$user" public. 3) \df *.create_immv pgivm | create_immv | bigint | text, t

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
On 3/2/25 07:23, Adrian Klaver wrote: On 3/1/25 17:39, Krishnakant Mane wrote: But when I try creating the same immv on the server it says function create_immv (unknown, unknown ) does not exist. Connect with psql then do: 1) \dx This will show what extensions are installed and in what

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
On 3/2/25 07:03, Adrian Klaver wrote: On 3/1/25 17:25, Krishnakant Mane wrote: On 3/1/25 22:17, Adrian Klaver wrote: On 2/28/25 21:29, Krishnakant Mane wrote: All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I

Re: create_immv issue on aws Ubuntu even after create extention

2025-03-01 Thread Krishnakant Mane
Mane wrote: On 2/28/25 22:53, Ron Johnson wrote: Differing search_path values can lead to problems like this. So what can I do to resolve this? On Fri, Feb 28, 2025 at 12:01 PM Krishnakant Mane wrote: Ok here you go. select create_immv

Re: create_immv issue on aws Ubuntu even after create extention

2025-02-28 Thread Krishnakant Mane
Thank you. Just a quick question. should it be in pg_catalog? if yes then it is so. On 3/1/25 01:39, Adrian Klaver wrote: On 2/28/25 09:26, Krishnakant Mane wrote: On 2/28/25 22:53, Ron Johnson wrote: Differing search_path values can lead to problems like this. So what can I do to

Re: create_immv issue on aws Ubuntu even after create extention

2025-02-28 Thread Krishnakant Mane
klpaylvl  where kwapp_skill.id  = kwapp_pltsklpaylvl.skillid_id  and kwapp_plant.id = kwapp_pltsklpaylvl.plantid_id'); You see, the point is this works perfectly on all local machines with exact same versions and same data. Regards. On 2/28/25 22:24, Ron Johnson wrote: On Fri, Feb 28, 2025 at 11:41

Re: create_immv issue on aws Ubuntu even after create extention

2025-02-28 Thread Krishnakant Mane
On 2/28/25 22:53, Ron Johnson wrote: Differing search_path values can lead to problems like this. So what can I do to resolve this? On Fri, Feb 28, 2025 at 12:01 PM Krishnakant Mane wrote: Ok here you go. select create_immv('plantskillpayment', '

create_immv issue on aws Ubuntu even after create extention

2025-02-28 Thread Krishnakant Mane
ame OS and postgresql version. Can someone suggest what could be the solution? Regards. Email Signature *Krishnakant Mane* Software Architecture Design & Implementation Specialist Mobile: +91 8424039903 https://www.linkedin.com/in/krishnakant-r-mane/

Re: can stored procedures with computational sql queries improve API performance?

2024-07-09 Thread Krishnakant Mane
On 7/10/24 06:44, Guyren Howe wrote: On Jul 9, 2024, at 17:58, Krishnakant Mane wrote: Hello. I have a straight forward question, but I am just trying to analyze the specifics. So I have a set of queries depending on each other in a sequence to compute some results for generating

can stored procedures with computational sql queries improve API performance?

2024-07-09 Thread Krishnakant Mane
Hello. I have a straight forward question, but I am just trying to analyze the specifics. So I have a set of queries depending on each other in a sequence to compute some results for generating financial report. It involves summing up some amounts from tuns or of rows and also on certain c

Re: confused about material view locks please explain

2024-07-05 Thread Krishnakant Mane
On 7/5/24 21:10, Peter J. Holzer wrote: If I understand https://github.com/sraoss/pg_ivm correctly, the materialized view will be updated within the same transaction. So it's just the same as any other change in the database: Neither client will wait for the other. The first client will see ei

confused about material view locks please explain

2024-07-05 Thread Krishnakant Mane
Hello all. I am an old timer postgresql user for last 17 years. I have used it for my open source as well as enterprise cloud services. IN my current fintech solution, I need to do some performance optimisations. I have decided to use materialised views (more precisely IVM ). So on my postgre

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Krishnakant Mane
On 26/09/19 6:53 PM, Rob Sargent wrote: >   > > On Sep 26, 2019, at 12:27 AM, Krishnakant Mane <mailto:kkm...@riseup.net>> wrote: > >> >> On 26/09/19 12:03 AM, Adrian Klaver wrote: >>> On 9/25/19 8:04 AM, Rob Sargent wrote: >>>> &

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-26 Thread Krishnakant Mane
On 26/09/19 12:03 AM, Adrian Klaver wrote: > On 9/25/19 8:04 AM, Rob Sargent wrote: >> >> >> On Sep 25, 2019, at 8:24 AM, Krishnakant Mane > <mailto:kkm...@riseup.net>> wrote: >> >>> >>> On 25/09/19 7:50 PM, Adrian Klaver wrote: >>

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Krishnakant Mane
On 25/09/19 7:50 PM, Adrian Klaver wrote: > On 9/25/19 12:15 AM, Krishnakant Mane wrote: >> Hello all, >> >> I have been using postgresql for an enterprise quality account's >> automation and inventory management software called GNUKhata >> <https://gnukh

Re: managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Krishnakant Mane
On 25/09/19 4:32 PM, Rob Sargent wrote: > > > On Sep 25, 2019, at 1:15 AM, Krishnakant Mane <mailto:kkm...@riseup.net>> wrote: > >> Hello all, >> >> I have been using postgresql for an enterprise quality account's >> automation and inven

managing primary key conflicts while restoring data to table with existing data

2019-09-25 Thread Krishnakant Mane
an even say this is a copy paste instead of a pure backup and restore. Can any one suggest how to handle such conflicts? -- Regards, Krishnakant Mane, Project Founder and Leader, GNUKhata <https://gnukhata.in/> //(Opensource Accounting, Billing and Inventory Management Software)//