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 resolve this?
In psql do:
\dx
That will show you what extensions are installed and in what schema.
Then read this:
https://www
Differing search_path values can lead to problems like this.
On Fri, Feb 28, 2025 at 12:01 PM Krishnakant Mane
wrote:
> Ok here you go.
>
> select create_immv('plantskillpayment', 'select distinct kwapp_plant.id
> as plantid, kwapp_skill.id as skillid, kwapp_skill.skillname,
> kwapp_plant.plantn
Yes perfect thank you.
Besides, I will soon switch over to Mac air m3 and voice over does not
have such problems.
This screen reader Orca is great as well and I am very sure, that it
being open source, will have the issue fixed at the earliest.
Regards.
On 3/2/25 09:53, Adrian Klaver 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 never had to compile the extention on my
local ubuntu 24.04 machine.
How did you ins
On 3/1/25 19:35, Krishnakant Mane wrote:
For my future reference does something like this response work better?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/2/25 08:44, Adrian Klaver wrote:
Then deal with the fact it is no longer installed to pg_control but
instead pgivm. With usual schema qualifications or search_path
techniques.
Thank you, it worked. now pgivm.create_immv works.
I should have got it before.
Did you not read my previ
Then deal with the fact it is no longer installed to pg_control but
instead pgivm. With usual schema qualifications or search_path techniques.
Thank you, it worked. now pgivm.create_immv works.
I should have got it before.
Did you not read my previous post?
--
Email Signature
*Kris
On Saturday, March 1, 2025, Krishnakant Mane wrote:
>
> Can you tell me how exactly should the syntax be?
>
https://www.postgresql.org/docs/current/ddl-schemas.html
> Is my function definition wrong?
>
It isn’t a function definition, it is a function call.
David J.
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, text | func.
Prov
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, text | func.
Prov
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, text | func.
> Provide the outputs from the above three commands in your re
On 3/1/25 18:14, Krishnakant Mane wrote:
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 w
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 s
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 schema.
2) show search_path;
3) \df *.c
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 never had to compile the extention on my
loc
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 nev
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 install Postgres on the AWS EC2 instance?
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.
I just did a create extention and it worked just fine.
But on my aws server I had to compile it m
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 resol
Ok here you go.
select create_immv('plantskillpayment', 'select distinct kwapp_plant.id
as plantid, kwapp_skill.id as skillid, kwapp_skill.skillname,
kwapp_plant.plantname, kwapp_pltsklpaylvl.level, kwapp_pltsklpaylvl.pay
from kwapp_skill, kwapp_plant, kwapp_pltsklpaylvl where
kwapp_skill.i
When you know that the SELECT statement runs on the local machines, then on
each server, run these SQL statements:
SHOW search_path;
SELECT * FROM pg_extension;
On Fri, Feb 28, 2025 at 12:26 PM Krishnakant Mane
wrote:
>
> On 2/28/25 22:53, Ron Johnson wrote:
>
>
> Differing search_path values
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', 'select distinct
kwapp_plant.id
On Fri, Feb 28, 2025 at 11:41 AM Krishnakant Mane
wrote:
> Hello all.
>
> I am not able to use create_immv in postgresql 16.6 even after installing
> it and doing create extention.
>
> I did a git clone of the repository and then make sudo make install to
> install it.
>
> The issue is not happen
23 matches
Mail list logo
