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
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
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
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
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,
>
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
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
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
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,
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
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
*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*
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
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
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
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(
16 matches
Mail list logo