Re: Issues with PostgreSQL Source Code Installation

> It looks to me like there is something > wrong with your libicu installation --- perhaps headers out of sync > with shared library? Yes correct, fixing libicu installation resolved the issue.

Re: Issues with PostgreSQL Source Code Installation

> I would go to the source link I posted download a specific version and > verify it builds. Then you know whether your setup is correct. Then you > could go back to exploring the Git code. Thanks will check that out

Re: Issues with PostgreSQL Source Code Installation

> Why are you building against the repo instead of a fixed version from > here?: So actually I wanted to modify and playaround with the code, hence I am using the github repo and building postgres from it. > Did you checkout a given tag? I haven't checkout on any branch and currently on branch ma

Issues with PostgreSQL Source Code Installation

Hi PostgreSQL Community, I am encountering an issue while trying to install PostgreSQL from its source code and would appreciate any guidance you can provide. Here are the steps I've taken so far: sudo yum install libicu-devel git clone git://git.postgresql.org/git/postgresql.git ./configure --ena

Re: Issue with pgstattuple on Sequences in PostgreSQL

QUENCE* from https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L255-L259 as well so that users can encounter *ERRCODE_FEATURE_NOT_SUPPORTED*. Thanks Ayush Vatsa SDE AWS

Issue with pgstattuple on Sequences in PostgreSQL

f condition - https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L326-L329 How can one use pgstattuple on sequences? Regards, Ayush Vatsa

Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions

DULE_PATHNAME', 'fun1' LANGUAGE C; We know the returned type will have two columns with type - integer and text. Am I correct? > Or a true record where the caller has to specify the shape. Sorry but didn't get this shape part? Thanks Ayush Vatsa

Seeking Clarification on Function Definitions in PostgreSQL Extensions

as "fun3" is used when we are returning only one row, but my doubt for "fun3" is that, Can the above definition (used for fun1 and fun2) cover both single and multiple row scenarios. 2/ How does someone decide which type of definition is to be used? Regards Ayush Vatsa

Query Discrepancy in Postgres HLL Test

ion error. However, I'm reaching out to seek clarity on why this disparity is occurring and to explore potential strategies for mitigating it (as I want the behaviour to be consistent to regress test file). Regards Ayush Vatsa

Re: Clarification on View Privileges and Operator Execution in PostgreSQL

Understood. Thanks David it was a nice conversation and clarification from you Regards Ayush Vatsa On Sun, 7 Apr 2024 at 23:45, David G. Johnston wrote: > On Sun, Apr 7, 2024 at 11:02 AM Ayush Vatsa > wrote: > >> > If you want to confirm what the documentation says create a

Re: Clarification on View Privileges and Operator Execution in PostgreSQL

VOKE ALL ON FUNCTION text_equals(text,text) FROM alex; It didn't work i.e alex can still execute text_equals function. Why is it so? Thanks Ayush Vatsa SDE AWS On Sun, 7 Apr 2024 at 22:31, David G. Johnston wrote: > On Sun, Apr 7, 2024 at 9:32 AM Ayush Vatsa > wrote: > >&g

Re: Clarification on View Privileges and Operator Execution in PostgreSQL

FROM x) with "postgres" privileges but who will execute the > underlying function inside the ( > ) operator ? Is it postgres or alex? On Sun, 7 Apr 2024 at 21:56, David G. Johnston wrote: > On Sun, Apr 7, 2024 at 9:10 AM Ayush Vatsa > wrote: > >> >> but

Clarification on View Privileges and Operator Execution in PostgreSQL

t; privileges but who will execute the underlying function inside the ( > ) operator ? Is it postgres or alex? 2. What if I used a user defined operator in the above example, then with whose privileges that operator will be executed? Thanks Ayush Vatsa SDE AWS

Query regarding functions of postgres

user is postgres Shouldn't it be "InnerFunction() -> Current user is alex" instead of postgres as alex called the security invoker function I tried reading docs but couldn't get any satisfactory answers, it will be helpful if someone helped me out here Thanks, Ayush Vatsa SDE AWS

Re: Query regarding function cleanup in extension upgrade path

so? Even in git blame , I couldn't find much! Regards Ayush Vatsa Amazon Web Services (AWS) On Wed, 14 Feb 2024 at 22:07, Tom Lane wrote: > Ayush Vatsa writes: > > To ask the question let me give a hypothetical example:- > > Suppose we have an extension named xyz with

Query regarding function cleanup in extension upgrade path

7_335645> but didn't get any reply hence trying my luck here. Regards Ayush Vatsa Amazon Web Services (AWS)

Re: Assistance Needed: Error during PostgreSQL Configuration

my issue. Next time I will use '_' in paths to be on the safer side. Thanks and regards Ayush Vatsa SDE Amazon On Tue, 12 Dec 2023 at 22:10, Tom Lane wrote: > Ayush Vatsa writes: > > Sorry, I should have included the required information initially itself. > I > > am

Re: Assistance Needed: Error during PostgreSQL Configuration

YSROOT) -Wl,-dead_strip_dylibs configure: creating ./config.status Thanks Ayush Vatsa On Mon, 11 Dec 2023 at 20:20, Tom Lane wrote: > Ian Lawrence Barwick writes: > > 2023年12月11日(月) 18:09 Ayush Vatsa : > >> ./config.status: line 486: syntax error near unexpected token `)' &

Assistance Needed: Error during PostgreSQL Configuration

; I have tried to resolve this on my own, but unfortunately, I haven't been successful in finding a solution. Could you please provide guidance or assistance in resolving this issue? I would appreciate any insights or suggestions you have to help me move past this obstacle. Looking forward to your response. Thanks Ayush Vatsa SDE Amazon