Re: Fwd: SQL transactions executing from VMSS

On 4/28/25 01:25, chandan Kumar wrote: Hello Team, I did not get any answer till now.  If someone has any idea please help me is getting this resolved. The issue is - database deployment , sql query to database is slow when we run database script from vmss to postgres database in flexible serv

Re: Fwd: SQL transactions executing from VMSS

Laurenz Albe writes: > I think that the answer you didn't get was as helpful as your problem > description: > "I got some statement that is slow, but I will neither tell you the > statement nor >show you the execution plan. What is the cause of the slowness?" The OP did say that the exec

Re: Fwd: SQL transactions executing from VMSS

On Mon, 2025-04-28 at 13:55 +0530, chandan Kumar wrote: > I did not get any answer till now.  If someone has any idea please help me is > getting this resolved. > The issue is - database deployment , sql query to database is slow when we > run database script from > vmss to postgres database in f

Fwd: SQL transactions executing from VMSS

Hello Team, I did not get any answer till now. If someone has any idea please help me is getting this resolved. The issue is - database deployment , sql query to database is slow when we run database script from vmss to postgres database in flexible server. both the servers are in US EAST under t

Re: Fwd: Identify system databases

On Wed, 2025-04-16 at 17:06 +0200, Dominique Devienne wrote: > So in a way, you guys are saying one should never REVOKE CONNECT ON > DATABASE FROM PUBLIC? No, not at all. > All my DBs are not PUBLIC-accessible. > And inside my DBs, I try to revoke everything from PUBLIC > (USAGE ON TYPES, EXECUTE

Re: Fwd: Identify system databases

"David G. Johnston" writes: > But feel free to work out a design and add it to the ToDo list for the v4 > protocol. The use case seems reasonable and doable (on the basis of the > replication protocol works). No, the replication protocol isn't a precedent. Physical replication needn't connect t

Re: Fwd: Identify system databases

On Wed, Apr 16, 2025 at 8:07 AM Dominique Devienne wrote: > On Wed, Apr 16, 2025 at 4:39 PM Tom Lane wrote: > > Laurenz Albe writes: > > > On Wed, 2025-04-16 at 10:09 +0200, Dominique Devienne wrote: > > So in a way, you guys are saying one should never REVOKE CONNECT ON > DATABASE FROM PUBLIC?

Re: Fwd: Identify system databases

On Wed, Apr 16, 2025 at 4:39 PM Tom Lane wrote: > Laurenz Albe writes: > > On Wed, 2025-04-16 at 10:09 +0200, Dominique Devienne wrote: So in a way, you guys are saying one should never REVOKE CONNECT ON DATABASE FROM PUBLIC? All my DBs are not PUBLIC-accessible. And inside my DBs, I try to rev

Re: Fwd: Identify system databases

Laurenz Albe writes: > On Wed, 2025-04-16 at 10:09 +0200, Dominique Devienne wrote: >> Authentication is cluster-wide, not DB specific, so I'd welcome a way to >> connect >> to the cluster, not a specific DB, and introspect shared-objects, >> including databases >> I'm allowed to connect to, whic

Re: Fwd: Identify system databases

On Wed, 2025-04-16 at 10:09 +0200, Dominique Devienne wrote: > On Wed, Apr 16, 2025 at 9:32 AM Laurenz Albe wrote: > > On Tue, 2025-04-15 at 17:24 -0700, Adrian Klaver wrote: > > But then you fortunately cannot drop all databases, because you cannot > > drop the database you are connected to. > >

Re: Fwd: Identify system databases

On Wed, Apr 16, 2025 at 9:32 AM Laurenz Albe wrote: > On Tue, 2025-04-15 at 17:24 -0700, Adrian Klaver wrote: > But then you fortunately cannot drop all databases, because you cannot > drop the database you are connected to. > > Still, a cluster that is missing "postgres" will give beginners troub

Re: Fwd: Identify system databases

On Tue, 2025-04-15 at 17:24 -0700, Adrian Klaver wrote: > I know I can use --template=template with createdb, but that still means > there has to be a database existing in the initial cluster to use as a > template. You can't get around that fact. Right. But then you fortunately cannot drop all

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 5:24 PM Adrian Klaver wrote: > > > > By creating the initial three databases the system is more usable due to > > having established conventions. They are conventional databases, not > > system ones. > > The bottom line is the Postgres project has built an infrastructure

Re: Fwd: Identify system databases

On 4/15/25 11:35, David G. Johnston wrote: On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: 1) Try connecting(not using single user mode) to a cluster without them. First I have had this discussion before and was not successful and I expect the

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 3:11 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver < > adrian.kla...@aklaver.com> > > wrote: > >> If what you say is true why does initdb lack an option to not create > >> them on creating a cluster? > > > By creating

Re: Fwd: Identify system databases

"David G. Johnston" writes: > On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver > wrote: >> If what you say is true why does initdb lack an option to not create >> them on creating a cluster? > By creating the initial three databases the system is more usable due to > having established conventions

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver wrote: > On 4/15/25 09:48, David G. Johnston wrote: > > On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver > > wrote: > > > > > > > Agreed. > > > > The fact that initdb creates the template0, template1 and postgr

Re: Fwd: Identify system databases

On 4/15/25 09:48, David G. Johnston wrote: On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver > wrote: Agreed. The fact that initdb creates the template0, template1 and postgres databases and you can't change that makes them system not user datab

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver wrote: > On 4/15/25 09:21, Igor Korot wrote: > > > > > > > Hi, David, > > > > On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston > > mailto:david.g.johns...@gmail.com>> wrote: > > > > On Tuesday, April 15, 2025, Igor Korot >

Re: Fwd: Identify system databases

On 4/15/25 09:21, Igor Korot wrote: Hi, David, On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Tuesday, April 15, 2025, Igor Korot mailto:ikoro...@gmail.com>> wrote: Hi, ALL, Is there a field in the pg_databases table w

Fwd: Identify system databases

-- Forwarded message - From: Igor Korot Date: Tue, Apr 15, 2025 at 11:16 AM Subject: Re: Identify system databases To: Adrian Klaver Hi, Adrian, On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver wrote: > On 4/15/25 07:48, Igor Korot wrote: > > Hi, ALL, > > Is there a field in th

Fwd: Identify system databases

-- Forwarded message - From: Igor Korot Date: Tue, Apr 15, 2025 at 11:15 AM Subject: Re: Identify system databases To: David G. Johnston Hi, David, On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, April 15, 2025, Igor Korot

Re: Fwd: Lock in postgreSQL

On 1/14/25 10:42 AM, Igor Korot wrote: Hi, ALL, This concern both libpq and DBC API. Hopefully I can get answers on both. Read: https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS Than yu. -- Forwarded message - From: Igor Korot Date: Tue, Ja

Fwd: Lock in postgreSQL

Hi, ALL, This concern both libpq and DBC API. Hopefully I can get answers on both. Than yu. -- Forwarded message - From: Igor Korot Date: Tue, Jan 14, 2025 at 12:50 AM Subject: Lock in postgreSQL To: pgsql-generallists.postgresql.org , PostgreSQL ODBC list Hi, ALL, https://

Re: Fwd: A million users

On Fri, Nov 22, 2024 at 6:57 AM wrote: > Yeah, this is still on my list of things to research more about > eventually - currently still unsolved. > > For my use-case the NO RESET would need to apply until the end of the > transaction, not end of the session. > > I imagine something like an extens

Re: Fwd: A million users

Eric Hanson: Did you find some way to prevent RESET ROLE?  I once advocated for a NO RESET option on SET ROLE [1] so that RESET ROLE would be impossible for the rest of the session.  Still think it would be helpful. Yeah, this is still on my list of things to research more about eventually -

Re: Fwd: A million users

On Wed, Nov 13, 2024 at 12:02 PM wrote: > I don't have any benchmarks, but the following data point: > > We use PostgREST [1] which connects to the database with one > "authenticator" role. For each request it handles, it does a SET ROLE to > a role defined in the Authorization Header (JWT). > >

Re: Fwd: A million users

Hi That said, having a million users is a bit strange. Do you want to give each visitor to your website a unique Postgres role, or something like that? I think this is unusual, but it should work. OK, thanks for the feedback, all. It may not be necessary to have such a fine grained syst

Re: Fwd: Error when opening pgAdmin

Reply to list also Ccing list On 11/20/24 9:36 AM, Violetta wrote: What exactly did you delete, the entire package or just pgAdmin4? I deleted the entire package.  How did you delete/uninstall it? I deleted everything that was in the automatically created folder I don't use Mac OS

Re: Fwd: Error when opening pgAdmin

On 11/19/24 11:57, Violetta wrote: Hi, I got an error, opening pgAdmin, after installation from EDB host. Please take a look at it. This is how I got it incrementally: 1. First time I downloaded postgreSQL v17.0 from the site https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Re: Fwd: Error when opening pgAdmin

PLEASE DEAR FRIEND SEND BIGGER MESSAGES! WE DON'T MIND! On 19/11/2024 20:57, Violetta wrote: Hi, I got an error, opening pgAdmin, after installation from EDB host. Please take a look at it. This is how I got it incrementally: 1. First time I downloaded postgreSQL v17.0 from the site https://www.

Re: Fwd: A million users

Dominique Devienne: Hi. Sure, that's a good point, and a best practice IMHO. But I already do that, and the original question remain, i.e. how does PostgreSQL with thousands or millions of roles? In my use case, 1000 LOGIN users, and 10'000 schema related ROLEs, is possible, with can translate to

Re: Fwd: A million users

On 2024-Nov-13, Kaare Rasmussen wrote: > Sorry if my original post was unclear, but I don't expect that there > will be much more than perhaps a hundred roles. Each may have from a > few up to a million users in them, though. In Postgres, a user is a role. So if you have a hundred roles and a mi

Re: Fwd: A million users

Hi Dominique Hi. Sure, that's a good point, and a best practice IMHO. But I already do that, and the original question remain, i.e. how does PostgreSQL with thousands or millions of roles? Sorry if my original post was unclear, but I don't expect that there will be much more than perhaps

Fwd: A million users

-- Forwarded message - From: Kaare Rasmussen <> Hi A simple question before design. Would there be performance issues having perhaps a million users, each having several roles? I could imagine a user would have on average 10-20 roles. I tried to grant select permissions to 5000

Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

On 2024-Nov-10, Tom Lane wrote: > This surprised me a bit too, because I thought we took a > slightly-less-than-exclusive lock for FK additions or deletions. > Tracing through it, I find that CloneFkReferencing opens the > referenced relation with ShareRowExclusiveLock as I expected. > But then we

Re: Fwd: A million users

On Wed, Nov 13, 2024, 4:42 PM Achilleas Mantzios - cloud < a.mantz...@cloud.gatewaynet.com> wrote: > > Exactly! In the later versions, security gets more and more refined and > strengthened. So ppl should think about moving away from "public" , and > start implementing finer grained schemes of sec

Re: Fwd: A million users

On Wed, Nov 13, 2024, 5:00 PM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > > > On Wed, Nov 13, 2024, 4:42 PM Achilleas Mantzios - cloud < > a.mantz...@cloud.gatewaynet.com> wrote: > >> >> Exactly! In the later versions, security gets more and more refined and >> strengthened. So ppl

Re: Fwd: A million users

On 11/13/24 12:29, Alvaro Herrera wrote: On 2024-Nov-13, Vijaykumar Jain wrote: I tried to grant select permissions to 5000 different roles on one table, It failed with row size too big already at 2443. But you can grant select to one "reader" role, and grant that one role to however many ot

Re: Fwd: A million users

On 2024-Nov-13, Vijaykumar Jain wrote: > I tried to grant select permissions to 5000 different roles on one table, > It failed with row size too big already at 2443. But you can grant select to one "reader" role, and grant that one role to however many other roles you want. This way you can have

Re: Fwd: A million users

On Wed, Nov 13, 2024 at 11:29 AM Alvaro Herrera wrote: > On 2024-Nov-13, Vijaykumar Jain wrote: > > I tried to grant select permissions to 5000 different roles on one table, > > It failed with row size too big already at 2443. > > But you can grant select to one "reader" role, and grant that one r

Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

Adrian Klaver writes: > 3) Because of 1 & 2, this needs further analysis by someone or someones > more knowledgeable. This surprised me a bit too, because I thought we took a slightly-less-than-exclusive lock for FK additions or deletions. Tracing through it, I find that CloneFkReferencing opens

Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

On 11/10/24 11:52, user wrote: Thank you for an answer! So reparenting of a constraint required that additional lock. I made some measurements and can see that even that reparenting (and additional lock) is required, the time it takes to make the attach is smaller than when the foreign constrai

Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

Thank you for an answer! So reparenting of a constraint required that additional lock. I made some measurements and can see that even that reparenting (and additional lock) is required, the time it takes to make the attach is smaller than when the foreign constraint hasn't been created beforehand.

Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

On 11/10/24 05:18, user wrote: Hello, Sorry for nagging, but I would really like to find some answers. So, to reiterate. Experiment done as follows: "' CREATE TABLE refs (                     id integer primary key,                     did integer                 ); CREATE

Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

ong. 2. Even when attach is adding a foreign key again, why is there AccessExclusiveLock on refs table? foreign key constraint addition does not require it. https://pglocks.org/?pgcommand=ALTER%20TABLE%20ADD%20FOREIGN%20KEY%20(CHILD) 3. If I repeat the steps listed above, but do not add foreign

Re: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

Hello Adrian, My apology for answering so late. Indeed I have not splitted my transactions correctly in my first example. BUT, if you change the syntaxt so that attach is performed in its own transaction, result is the same. Try it out! Also you have told me that I am seeing ExclusiveLock on refs

Re: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

On 10/21/24 1:40 AM, user wrote: ** forwarding to mailing list, forgot to add header Thanks for answering. I think one misunderstanding happened. The parent table has the foreign key constraint. So attach partition will add this constraint for table being attached. (How this compares to for

Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

** forwarding to mailing list, forgot to add header Thanks for answering. I think one misunderstanding happened. The parent table has the foreign key constraint. So attach partition will add this constraint for table being attached. (How this compares to foreign keys not being considered, not sur

Fwd: Inefficient use of index scan on 2nd column of composite index during concurrent activity

-- Forwarded message - From: Durgamahesh Manne Date: Mon, Oct 7, 2024 at 10:01 AM Subject: Inefficient use of index scan on 2nd column of composite index during concurrent activity To: Hi team Second column of composite index not in use effectively with index scan when using se

Fwd: Suggestions to overcome 'multixact "members" limit exceeded' in temporary tables

(resending to general since I believe I originally sent it to hackers by mistake) I've reached the limit of my understanding and attempts at correcting my code/use of temporary tables in the face of multixact members and have come to ask for your help! Here's a brief description of my software; P

Re: Fwd: lost master password

On 7/22/24 06:32, Afa Jamal wrote: master Read: https://www.pgadmin.org/docs/pgadmin4/8.9/master_password.html Sent from Gmail Mobile On Mon, Jul 22, 2024 at 9:30 AM Laurenz Albe > wrote: On Fri, 2024-07-19 at 11:59 -0400, Afa Jamal wrote: > can

Re: Fwd: lost master password

master Sent from Gmail Mobile On Mon, Jul 22, 2024 at 9:30 AM Laurenz Albe wrote: > On Fri, 2024-07-19 at 11:59 -0400, Afa Jamal wrote: > > can you help me with reset > > I am not able to do this > > what u caan advise > > > > On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe > wrote: > > > On Sun

Re: Fwd: lost master password

On Fri, 2024-07-19 at 11:59 -0400, Afa Jamal wrote: > can you help me with reset  > I am not able to do this > what u caan advise > > On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe wrote: > > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > > how you can help me with lost super password? > >

Re: Fwd: lost master password

Hello can you help me with reset I am not able to do this what u caan advise On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe wrote: > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > how you can help me with lost super password? > > Are you talking about a PostgreSQL superuser password or >

Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()

Hi , You can consider the pg_pathman extension. *Muhammad Imtiaz* *PostgreSQL Technical Support Lead * */ Pakistan R&D* *Mobile: +923345072521* *Email: imtia...@bitnine.net * On Fri, Jul 19, 2024 at 7:55 PM Durgamahesh Manne wrote: > > > On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg wrote

Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()

On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg wrote: > Re: Durgamahesh Manne > > with pg_partman By default proc() does not detach tables concurrently. > How > > do we implement tables detach concurrently without blocking other > sessions > > Here queries not using date column to detach tables w

Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()

Re: Durgamahesh Manne > with pg_partman By default proc() does not detach tables concurrently. How > do we implement tables detach concurrently without blocking other sessions > Here queries not using date column to detach tables with > run_maintenance_proc() which is not using concurrently based

Fwd: Regarding tables detach concurrently with run_maintenance_proc()

Hi Respected Team with pg_partman By default proc() does not detach tables concurrently. How do we implement tables detach concurrently without blocking other sessions Here queries not using date column to detach tables with run_maintenance_proc() which is not using concurrently based on the rete

Re: Fwd: lost master password

superuser Sent from Gmail Mobile On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe wrote: > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > how you can help me with lost super password? > > Are you talking about a PostgreSQL superuser password or > about the "master password" that the pgAdm

Re: Fwd: lost master password

On Mon, 2024-06-10 at 05:06 -0400, Afa Jamal wrote: > On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe wrote: > > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > > how you can help me with lost super password? > > > > Are you talking about a PostgreSQL superuser password or > > about the "mas

Re: Fwd: lost master password

On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > how you can help me with lost super password? Are you talking about a PostgreSQL superuser password or about the "master password" that the pgAdmin client uses to encrypt connection information? Yours, Laurenz Albe

Fwd: lost master password

Sent from Gmail Mobile -- Forwarded message - From: Afa Jamal Date: Fri, Jun 7, 2024 at 8:13 PM Subject: lost master password To: Hello how you can help me with lost super password? thank you -- *Afa J Zada*

Re: Fwd: Receipt for PostgreSQL US Invoice #1840

gt; > >> Begin forwarded message: > >> > >> *From: *Sadie Bella >> <mailto:bellasadie@gmail.com>> > >> *Subject: **Fwd: Receipt for PostgreSQL US Invoice #1840* > >> *Date: *March 12, 2024 at 19:13:40 PDT > >> *To: *Christ

Re: Fwd: Receipt for PostgreSQL US Invoice #1840

On 3/12/24 19:14, Christophe Pettus wrote: Oops? Begin forwarded message: *From: *Sadie Bella <mailto:bellasadie@gmail.com>> *Subject: **Fwd: Receipt for PostgreSQL US Invoice #1840* *Date: *March 12, 2024 at 19:13:40 PDT *To: *Christophe mailto:x...@d

Fwd: Receipt for PostgreSQL US Invoice #1840

Begin forwarded message:From: Sadie Bella <bellasadie@gmail.com>Subject: Fwd: Receipt for PostgreSQL US Invoice #1840Date: March 12, 2024 at 19:13:40 PDTTo: Christophe <x...@dvvent.com>-- Forwarded message -From: <treasu...@postgresql.us>Date: Tue, Mar 12, 20

Fwd: Getting error while upgrading

On Sat, Mar 9, 2024 at 12:18 PM omkar narkar wrote: > Hello Team, > > I am trying to upgrade my edb 10.5 community version to postgres 15.6 > version and while doing this i am getting error regarding OIDS are not > stable across Postgresql version (sys.callback_queue_table.user_data). > Kindly he

Re: Fwd: Unexpected Multiple Records from Randomized Query

=?UTF-8?B?6rmA66qF7KSA?= writes: > explain analyze > SELECT * FROM users WHERE name = 'User '||trunc(random()*100) ; > I expected the result to return one record. However, in some cases, the > result comes back with 2 or 3 records. What am I doing wrong? random() is re-evaluated at each row, so

Fwd: Unexpected Multiple Records from Randomized Query

Hello. I encountered a problem while setting up a test environment to learn the use of the random() function. The query is as follows: CREATE TABLE users ( id SERIAL PRIMARY KEY, name VARCHAR(100), email VARCHAR(100), signup_date DATE ); INSERT INTO users (name, email, signup_d

Re: Fwd: pgadmin not opening in concurrent sessions

On 2/8/24 07:27, Siraj G wrote: Hello! I installed PgAdmin4 8.2 in a Windows platform, for all the users. The issue we are having is, if any user launches it, nobody else can launch it. Eg., userB logs in and launches PgAdmin, it gets launched. Now if UserA and UserB tried to login, they get n

Fwd: pgadmin not opening in concurrent sessions

Hello! I installed PgAdmin4 8.2 in a Windows platform, for all the users. The issue we are having is, if any user launches it, nobody else can launch it. Eg., userB logs in and launches PgAdmin, it gets launched. Now if UserA and UserB tried to login, they get nothing, no event/response from Windo

Re: Fwd: Disable autocommit inside dbeaver

On 12/6/23 20:45, arun chirappurath wrote: Hi All, Is there a way we can disable autocommit option inside query writing area? Not by choosing auto commit from drop down menu. Thanks, Arun maybe "begin; ; commit;"

Fwd: Disable autocommit inside dbeaver

Hi All, Is there a way we can disable autocommit option inside query writing area? Not by choosing auto commit from drop down menu. Thanks, Arun

Fwd: Need efficient way to remove (almost) duplicate rows from a table

I'm not clear which rows are duplicates. It looks like limb_id, branch_id and twig_id make up a unique key. If there was a row (2, 2, 7,103.7) would it be a duplicate of rows (1,1,2,103.7) and (1,1,3,103.7)? -- MIke Nolan

Re: Fwd: TSQL To Postgres - Unpivot/Union All

Anthony Apollis schrieb am 20.07.2023 um 14:17: Does not give me outputs for columns: Metric and Pricing Channel: image.png What am i doing wrong? Please assist? UNPIVOT can be done using a LATERAL sub-query with a VALUES clause: https://blog.sql-workbench.eu/post/unpivot-with-postgres/

Fwd: TSQL To Postgres - Unpivot/Union All

-- Forwarded message - From: Anthony Apollis Date: Thu, 20 Jul 2023 at 16:07 Subject: Re: TSQL To Postgres - Unpivot/Union All To: Geoff Winkless , David G. Johnston < david.g.johns...@gmail.com> I am attaching my TSQL and Postgres SQL: On Thu, 20 Jul 2023 at 15:58, Geoff Winkle

Re: Fwd: Regarding Installation of PostgreSQL

On 7/18/23 20:14, Sahil Sojitra wrote: -- Forwarded message - From: *Sahil Sojitra* > Date: Tue, 18 Jul, 2023, 8:43 am Subject: Regarding Installation of PostgreSQL To: mailto:secur...@postgresql.org>> Hello Sir,                I got stuck i

Re: Fwd: error in the example given for numeric data types

On 2023-07-15 12:08:26 +0530, Priyank Rajvansh wrote: > Page: https://www.postgresql.org/docs/15/datatype-numeric.html > Description: > > article 8.1.2 states the following: > > ''We use the following terms below: The precision of a numeric is the total > count of significant digits in the whole

Fwd: error in the example given for numeric data types

Respected postgresql team,forwarded email. Thank You Kindly have a look at the -- Forwarded message - From: PG Doc comments form Date: Sat, Jan 28, 2023 at 11:22 AM Subject: error in the example given for numeric data types To: Cc: The following documentation comment has been

Fwd: Migration database from mysql to postgress

Hello Necesito mover algunas bases de datos de un servidor MySQL a Postgresql. Can anyone tell me the migration procedure, tools and recommendations? Gracias El vie, 23 jun 2023 a las 11:30, Alfredo Alcala () escribió: > Hola > > Necesito mover algunas bases de datos de un servidor MySQL a Po

Fwd: PGCon remote attendance

Hi pgsql-general, Will there be any option to attend the upcoming PG conference remotely? Will the talks and papers be posted online following the conference, if not? Thank you, Joe Hammerman

Fwd: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency

I'm using an EC2 on AWS running Amazon Linux 2. I'm trying to install Postgresql version 15 server along with the contrib libraries for various extension. This is how I installed Posgres15 sudo rpm --import https://yum.postgresql.org/RPM-GPG-KEY-PGDG-15 sudo yum update -y sudo yum install -y post

Fwd: Request for information about Postgres version 15.2 stability

-- Forwarded message - From: gayathri ramesh <17gayathriram...@gmail.com> Date: Tue, 18 Apr, 2023, 12:20 pm Subject: Request for information about Postgres version 15.2 stability To: Hi Team, Our company is currently supporting around 100+ postgres databases and we are planning

Fwd: Behavior of PL/pgSQL function following drop and re-create of a table that it uses

Forwarding this to the list; Note the potential bug found at the end. My actual follow-on reply notes the lack of documentation regarding the composite cache-checking behavior (relative to the non-composite situation) -- Forwarded message - From: David G. Johnston Date: Tue, Mar

Re: Fwd: garbage data back

On 3/6/23 12:48 PM, Brad White wrote: LOL Joke's on me. Here's the relevant part of the view SELECT ...     "Order Items"."ID" AS "OrderItemID",     ...     (("Orders"."ID" || '-'::text) || "Order Items"."ID") AS "FileKey"\ Because "Orders"."ID" is different then "Order Items"."ID"? W

Fwd: garbage data back

LOL Joke's on me. Here's the relevant part of the view SELECT ... "Order Items"."ID" AS "OrderItemID", ... (("Orders"."ID" || '-'::text) || "Order Items"."ID") AS "FileKey" Wait, then why are the Item IDs different? Here are the results again, with the FileKey field expanded a bit.

Fwd: Quoting issue from ODBC

Front end: Access 365 Back end: Postgres 9.4 (I know, we are in the process of upgrading) I'm getting some cases where the SQL sent from MS-Access is failing. Looking at the postgres log shows that the field names and table names are not being quoted properly. It has been my experience that Access

Fwd: Sequence vs UUID

Copying the list... -- Forwarded message - From: Dominique Devienne Date: Fri, Feb 3, 2023 at 4:57 PM Subject: Re: Sequence vs UUID To: veem v On Thu, Feb 2, 2023 at 8:47 PM veem v wrote: > Tested the UUIDv7 generator for postgres as below. > With regards to performance , It's

Fwd: Segmentation fault on RelationGetDescr in my first extension

Hi! I'm trying to write my first extension and open a table in it. I use check_password_hook and my function executes at the moment of changing user password. But if I try to open a table inside this function, I get Segmentation fault on the line with "RelationGetDescr". What am I doing wrong?

Fwd: Change the auth. postgresql and GIS

Dear Community, we tried to change the auth. in our postgresql environment (PostgreSQL V.11) from MD5 to SCRUM SHA 256 - stop the services and killed all active connections - changed with alter and set pw the editor user to sha (psql) - checked if the pw changes successfull (psql and pg4admin) -

Re: Fwd: Postgre und GIS Umstellung von MD5 auf SCUM SHA 256

You can send questions in German to . On 23.11.22 11:22, Nikolas Hanry wrote: Liebe Community, Wir haben versucht, die Authentizierung  in unserer postgresql-Umgebung von MD5 zu SCRUM SHA 256 zu ändern (PostgreSQL V.11) - Stoppen Sie die Dienste und beenden alle aktiven Verbindungen - mit a

Re: Fwd: Change the auth. postgresql and GIS

On 11/23/22 02:23, Nikolas Hanry wrote: Dear Community, Comments inline below. we tried to change the auth. in our postgresql environment (PostgreSQL V.11) from MD5 to SCRUM SHA 256  - stop the services and killed all active connections - changed with alter and set pw the editor user to sh

Fwd: Change the auth. postgresql and GIS

Dear Community, we tried to change the auth. in our postgresql environment (PostgreSQL V.11) from MD5 to SCRUM SHA 256 - stop the services and killed all active connections - changed with alter and set pw the editor user to sha (psql) - checked if the pw changes successfull (psql and pg4admin) -

Fwd: Postgre und GIS Umstellung von MD5 auf SCUM SHA 256

Liebe Community, Wir haben versucht, die Authentizierung in unserer postgresql-Umgebung von MD5 zu SCRUM SHA 256 zu ändern (PostgreSQL V.11) - Stoppen Sie die Dienste und beenden alle aktiven Verbindungen - mit alter and set pw den Editor-Benutzer auf sha (psql) geändert - überprüft, ob die pw-

Fwd: Postgresql/Postgis: Trigger for historization/versioning

Good evening, I work with Postgresql 13, Postgis (and Qgis 3.22.) My need is to set up within my Postgis database (used for maps production), triggers for automation of data historization/versioning. The idea: For instance within a table 'BOREHOLE' (geometry: points), different updates of the table

Re: Fwd: Data caching

On 8/18/22 09:39, Anant ngo wrote: Hello Is there a postgres extension or project related to application-level/foreign-table data caching ? The postgres_fdw extension fetches data from foreign table for each command. I have seen previous messages in archive about caching in form of global t

Fwd: Data caching

Hello Is there a postgres extension or project related to application-level/foreign-table data caching ? The postgres_fdw extension fetches data from foreign table for each command. I have seen previous messages in archive about caching in form of global temp tables, query cache etc. There are go

Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed

On Thu, 11 Aug 2022 at 12:00, Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > Hi Tony > > The reason I'm looking to do it from scratch is that its a case of "once > bitten, twice shy". > > This CMS will be replacing a Joomla based CMS. > > I can't quite say I'm enamoured by the option o

Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed

Sent with Proton Mail secure email. --- Original Message --- On Thursday, August 11th, 2022 at 13:11, Ray O'Donnell wrote: > On 11/08/2022 11:00, Laura Smith wrote: > > > Hi Tony > > > > The reason I'm looking to do it from scratch is that its a case of > > "once bitten, twice sh

Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed

Hi Tony The reason I'm looking to do it from scratch is that its a case of "once bitten, twice shy". This CMS will be replacing a Joomla based CMS. I can't quite say I'm enamoured by the option of trading one "baggage included" opinionated CMS for another.  Also in this day and age, removing t

  1   2   3   >