>
> I am writing to inquire about the use cases for the SAVEPOINT feature.
>
Savepoints are used to implement ON_ERROR_ROLLBACK in psql. See:
https://www.endpointdev.com/blog/2015/02/postgres-onerrorrollback-explained/
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgre
On Mon, 14 Apr 2025 at 21:54, itumonohito wrote:
>
> Dear hackers,
>
> I hope this email finds you well.
>
> I am writing to inquire about the use cases for the SAVEPOINT feature.
>
> I would appreciate it if you could provide some examples of scenarios where
> this functionality proves particula
On Mon, 23 Dec 2024, 18:32 Luca Ferrari, wrote:
>
> Hi all,
> hope this is the right place to ask for, otherwise please point me in
> the right resource.
> I'm trying to develop a module that needs shared memory between
> background workers.
>
> The _PG_init calls a function to reserve the shared
On Friday, July 26, 2024, Ayush Vatsa wrote:
>
> I wanted to modify the SQL script of an extension by creating multiple
> objects within it.
> My aim is to make minimal changes to the existing script. To achieve this,
> I have created an
> external script and am attempting to run it within the ext
This seven email thread should never have appeared on the hackers list.
It is more appropriate for the pgsql-gene...@postgresql.org email list.
---
On Mon, May 6, 2024 at 08:53:15AM +0500, Kashif Zeeshan wrote:
> Hi
>
>
Hi
Upgrade works when you have an existing Postgres installation with server
running.
If you run the following command then it will upgrade the
existing installation of postgre.
sudo dnf install -y postgresql13-server
But you don't need to execute the below commands as this will create data
direc
On Mon, Apr 29, 2024 at 9:07 PM •Isaac Rv wrote:
> Ok entiendo sí, pero mi versión sigue en la 13.12 y necesito que sea
> 13.14, me indica que ya no tiene actualizaciones pero realmente sí, ya no
> sé cómo actualizarla a la 13.14
>
Hi
Please make sure that your postgres repository is set proper
Glad to be of help.
pg_uprade is used with major version upgrade e.g. from PG13 to 14 etc
Regards
Kashif Zeeshan
Bitnine Global
On Fri, Apr 26, 2024 at 10:47 PM •Isaac Rv wrote:
> Hola, lo acabo de hacer, quedó bien luego detuve el servidor, aplique otra
> vez el sudo yum update postgresql13
On Fri, Apr 26, 2024 at 9:22 PM •Isaac Rv wrote:
> Mira intente con el yum y si actualizó pero sin embargo no actualizo a la
> 13.14
>
> sudo yum update postgresql13
> Updating Subscription Management repositories.
>
> This system is registered with an entitlement server, but is not receiving
> u
On Thu, Apr 25, 2024 at 11:55 PM •Isaac Rv wrote:
> Entiendo si, me han dicho que es sencillo, pero no entiendo si solo
> descargo los binarios y en cual carpeta reemplazo? no hay una guía cómo tal
> de cómo realizarlo, me podrías ayudar?
>
Follow the below steps
1. Backup your data
2. Review t
Hi Isaac
You are doing the minor version upgrade so it's not a big effort as
compared to major version upgrade, following is the process to do it.
*Minor releases never change the internal storage format and are always
compatible with earlier and later minor releases of the same major version
num
We've figured it out. Please ignore.
Regards.
On Fri, Apr 30, 2021 at 3:13 PM Patrik Novotny wrote:
> Hi,
>
> I need to reproduce the CVE-2020-25695 on PostgreSQL 9.2.24. I know this
> is not a supported version, however, it is important for us to have a
> reproducer for this version as well.
CHIN KHANNA
212 BASIS DBA TEAM OFFSHORE
Office : 204058624
Cell : 9049522511
-Original Message-
From: Ashutosh Sharma
Sent: Thursday, August 27, 2020 2:12 PM
To: Khanna, Sachin 000
Cc: pgsql-hack...@postgresql.org; Thomas Munro
Subject: Re: Help needed configuring postgreSQL with xml suppo
In addition to what Thomas said, I would also recommend you to refer
to the description of --with-libxml command line option provided in
the postgres installation-procedure page - [1].
[1] - https://www.postgresql.org/docs/12/install-procedure.html
--
With Regards,
Ashutosh Sharma
EnterpriseDB:ht
On Thu, Aug 27, 2020 at 8:17 PM Khanna, Sachin 000
wrote:
> I am getting following error in configuration.log of installation . Please
> help
You didn't mention what operating system this is, but, for example, if
it's Debian, Ubuntu or similar you might need to install libxml2-dev
and pkg-confi
On Thu, Apr 25, 2019 at 9:53 AM alex lock wrote:
>
>
> that's something I want to change, as I said at the beginning. include
> avoid some memory release (like the EState and so on), snapshot release.
>
>
I check my original statement, I found "snapshot release" was missed, that
obviously is
On Wed, Apr 24, 2019 at 11:30 PM Tom Lane wrote:
> alex lock writes:
> > The cursor means something like declare c cursor for select * from t;
> > The holdable cursor means declare c cursor WITH HOLD for select * from t;
>
> > Holdable cursor is good at transaction, user can still access it a
alex lock writes:
> The cursor means something like declare c cursor for select * from t;
> The holdable cursor means declare c cursor WITH HOLD for select * from t;
> Holdable cursor is good at transaction, user can still access it after the
> transaction is commit. But it is bad at it have
On 18 March 2018 at 04:08, Projat Banerjee
wrote:
> What is the type of proposal should I submit here ? What kind or on what
> basis should I build my proposal so that I may get easily selected or
> chances for my selection is high ?
>
>
Are you asking about Google Summer of Code?
Because if so
Hello Thomas,
Thank you for your suggestions, needless to say it helped a lot. As
you suggested, I have created an initial dsm segment and used it create dsa
area as well as to detach dsm. Thus, it helped me in using 'on_dsm_detach'
callback. I have tested the code and it work
On Wed, Jan 24, 2018 at 8:37 PM, Gaddam Sai Ram
wrote:
> Found that there is a callback for dsa detach but that function requires
> segment pointer as an argument, Should be as below:
>
> on_dsm_detach(PROC_DSA_AREA->segment_maps[0].segment, detach_func);
> ...
> But i couldn't access that segment
21 matches
Mail list logo
