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
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 happening on my local ubuntu 24.04 machine but on
ubuntu 24.04 on aws free
24 matches
Mail list logo
