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
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
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
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
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
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
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
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
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
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
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', '
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/
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
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
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
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
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:
>>>>
&
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:
>>
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
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
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)//
21 matches
Mail list logo