Hello
Thank you for attention! I marked CF entry as returned with feedback.
regards, Sergei
On Thu, Aug 29, 2019 at 03:47:40PM +0500, Ibrar Ahmed wrote:
> I think its a user request and don't require to be in the core of
> PostgreSQL.
> A simple SQL function can fulfill the requirement of the user.
>
> CREATE OR REPLACE FUNCTION pg_get_databasebyid(dboid integer) RETURNS name
> AS $$
>
On Thu, Aug 29, 2019 at 3:16 PM Sergei Kornilov wrote:
> Hello
>
> > Is there a need for this function for the user?
>
> This was feature request from user. I got such comment:
>
> This function is useful when working with pg_stat_statements. For
> obtaining a databаse name for particular query y
Hello
> Is there a need for this function for the user?
This was feature request from user. I got such comment:
This function is useful when working with pg_stat_statements. For obtaining a
databаse name for particular query you need to join pg_database relation, but
for obtaining an username
On Wed, Aug 28, 2019 at 6:05 PM Sergei Kornilov wrote:
> > Please add that to commitfest.
>
> Done: https://commitfest.postgresql.org/24/2261/
>
> regards, Sergei
>
Hi,
I have checked the code, the function "pg_get_userbyid" is used in many
places in code. I am just curious why we need that "pg
> Please add that to commitfest.
Done: https://commitfest.postgresql.org/24/2261/
regards, Sergei
On Wed, Aug 28, 2019 at 5:38 PM Sergei Kornilov wrote:
> Hello
> We already have function pg_get_userbyid(oid) with lookup in pg_authid
> catalog. My collegue ask me can we add similar function
> pg_get_databasebyid(oid) with lookup in pg_databases.
> It is simple function to get
Hello
We already have function pg_get_userbyid(oid) with lookup in pg_authid catalog.
My collegue ask me can we add similar function pg_get_databasebyid(oid) with
lookup in pg_databases.
It is simple function to get a database name by oid and fallback to 'unknown
(OID=n)' if mis
