Re: Pgbackrest fails due after an ISP change

2025-04-22 Thread KK CHN
Hi List, Thanks for the clarification. If I want to start a fresh backup to the same repo server ( the one which fails the pgbackrest backup due to the file system full outage) what all are the steps I have to perform on the Repo Server and the DB server ? AFAIK,These all are the steps re

Another documentation issue

2025-04-22 Thread Igor Korot
Hi, ALL, On the page https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-SEQ-PAGE-COST it is only given the default value of this parameter. No min/max values are provided.. The same can be sad about https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RANDOM

Bash automation for PostgreSQL

2025-04-22 Thread Travis Bean
Hello, I developed a Bash script to automate the installation and configuration of open-source software (i.e., launchpad.net/linuxha). I want to make sure the syntax of this script is perfect so I can use it as a teaching tool to educate people about Linux. I need to know if there is anything mis

RE: Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread Deas, Scott
I would also suggest that this would complicate grants. It makes sense that we have users who can UPDATE rows, but not remove rows completely, but if this new syntax utilizes the DELETE keyword, how would that be implemented from a permissions perspective? We use CI/CD automation for DDL and s

Re: Oracle_fdw

2025-04-22 Thread Yongye Serkfem
Thanks, I'll look into it. On Tue, Apr 22, 2025, 7:54 AM Laurenz Albe wrote: > On Tue, 2025-04-22 at 07:28 -0400, Yongye Serkfem wrote: > > We are using Postgresql-15, ahd having issues importing foreign schema > with all > > its objects from an Oracle databse. Here is the error I am getting, >

Re: Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread thombrown1979
On Tue, 22 Apr 2025, 13:09 Abhishek Hatgine, wrote: Dear SQL Development Team, > > I hope this message finds you well. > > I'd like to propose a new feature for consideration in future versions of SQL > — the ability to perform a column-level DELETE operation, allowing removal of > specific colu

Re: Cannot turn track_counts on

2025-04-22 Thread Adrian Klaver
On 4/22/25 01:31, Anton Shepelev wrote: Adrian Klaver: There is something different about your setup, as here on Ubuntu(which uses the Debian packaging) I see: [...] Yes. It is on on your side, and pgsql shows NULL values as NULL. Can the latter be due to a differnce in Postgres versions

Re: Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread David G. Johnston
On Monday, April 21, 2025, Abhishek Hatgine wrote:. > > >- > >More intuitive for developers coming from languages or NoSQL systems >where fields can be "deleted" from an object/document. > > Why should this matter to us? We don’t have this paradigm, you can’t remove columns from exist

Re: Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread Laurenz Albe
On Mon, 2025-04-21 at 22:23 +0530, Abhishek Hatgine wrote: > I'd like to propose a new feature for consideration in future versions of SQL > — the ability > to perform a column-level DELETE operation, allowing removal of specific > column values > without affecting the entire row. In PostgreSQL,

Re: Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread Amul Sul
On Tue, Apr 22, 2025 at 5:56 PM Karsten Hilbert wrote: > > Am Mon, Apr 21, 2025 at 10:23:30PM +0530 schrieb Abhishek Hatgine: > > >*deleting* a value is conceptually different from *updating* it to NULL. > > In what way ? > > In other words, you'll have to much better define what you > mean be

Re: Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread Karsten Hilbert
Am Mon, Apr 21, 2025 at 10:23:30PM +0530 schrieb Abhishek Hatgine: >*deleting* a value is conceptually different from *updating* it to NULL. In what way ? In other words, you'll have to much better define what you mean be "deleting a value". DROP COLUMN already exists, for that matter. Upd

Feature Proposal: Column-Level DELETE Operation in SQL

2025-04-22 Thread Abhishek Hatgine
*Dear SQL Development Team,* I hope this message finds you well. I'd like to propose a new feature for consideration in future versions of SQL — the ability to perform a column-level DELETE operation, allowing removal of specific column values without affecting the entire row. *Proposal Summary*

Re: Oracle_fdw

2025-04-22 Thread Laurenz Albe
On Tue, 2025-04-22 at 07:28 -0400, Yongye Serkfem wrote: > We are using Postgresql-15, ahd having issues importing foreign schema with > all > its objects from an Oracle databse. Here is the error I am getting, > "error connecting to Oracle: OCIEnvCreate failed to create environment > handle: Det

SQL transactions executing from VMSS

2025-04-22 Thread chandan Kumar
Hi Team, Greetings! Kindly help in below situation, where in I see slowness in response time while I do testing running SQL transaction in batches from VMSS to postgres database in flexible server(PaaS) 14.17 version. VMSS to IaaS(postgres db on ubuntu) is faster than VMSs to PaaS. 14 version is s

Oracle_fdw

2025-04-22 Thread Yongye Serkfem
Hello Team! We are using Postgresql-15, ahd having issues importing foreign schema with all its objects from an Oracle databse. Here is the error I am getting, "error connecting to Oracle: OCIEnvCreate failed to create environment handle: Detail: SQL state: HV00N I have installed oracle instantclie

Re: Cannot turn track_counts on

2025-04-22 Thread Anton Shepelev
Adrian Klaver: > Anton Shepelev: > > > Have you any further ideas how to turn track_counts on? > > It is matter of finding out what is setting?: > > source | override Indeed, I having begun with this crucial question. > There is something different about your setup, as here on > Ubuntu(