Re: Transaction and SQL errors

2022-04-12 Thread Sebastien Flaesch
Hello, Back on this "feature", I did some experiments by changing the code of our PostgreSQL driver (db connector)... We have our own programming language and VM/runtime. With a config setting (I don't want to enable this by default), our driver now automatically adds a SAVEPOINT before any SQ

Major release of advanced PostgreSQL driver written in C++

2022-04-12 Thread Dmitry Igrishin
Hello, I'm excited to announce Pgfe 2.0.0, an advanced and feature rich PostgreSQL driver written in C++. Features: - fast and robust; - can be used as either header-only, static or shared library; - works with database connections in both blocking and non-blocking IO manner; - supports prepared

OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

2022-04-12 Thread cecile rougnaux
My system is OS Mojave 10.14.6, I got homebrew from this command : /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" when I try to install postgresql with the command brew install postgresql I have this error: Error: An exception occurred with

Re: Major release of advanced PostgreSQL driver written in C++

2022-04-12 Thread Dominique Devienne
On Tue, Apr 12, 2022 at 12:17 PM Dmitry Igrishin wrote: > I'm excited to announce Pgfe 2.0.0, an advanced and feature rich > PostgreSQL driver written in C++. Congrats on the release. I've been following your progress, and saw good stuff in your commits. Could you please more clearly state in th

Re: Major release of advanced PostgreSQL driver written in C++

2022-04-12 Thread Dmitry Igrishin
вт, 12 апр. 2022 г. в 13:59, Dominique Devienne : > > On Tue, Apr 12, 2022 at 12:17 PM Dmitry Igrishin wrote: > > I'm excited to announce Pgfe 2.0.0, an advanced and feature rich > > PostgreSQL driver written in C++. > > Congrats on the release. I've been following your progress, and saw > good st

Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

2022-04-12 Thread Tom Lane
cecile rougnaux writes: > when I try to install postgresql with the command > brew install postgresql > I have this error: > Error: An exception occurred within a child process: > RuntimeError: /usr/local/opt/openssl@1.1 not present or broken > Please reinstall openssl@1.1. Sorry :(

Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

2022-04-12 Thread Dan Davis
The reason that openssl is not linked is that MacOS already has LibreSSL. It would be good to build PostgreSQL with LibreSSL on OS X, as LibreSSL is really more secure, but then again, PostgreSQL on OS X should be only for development purposes. You may have heard about the heartbleed attack - Libr

Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

2022-04-12 Thread Adrian Klaver
On 4/12/22 03:33, cecile rougnaux wrote: My system is OS Mojave 10.14.6, I got homebrew from this command :  /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" From here: https://docs.brew.sh/Installation macOS Catalina (10.15) (or higher

Re: alter function/procedure depends on extension

2022-04-12 Thread David G. Johnston
On Thu, Feb 17, 2022 at 9:32 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Feb 17, 2022 at 8:54 PM Tom Lane wrote: > >> "David G. Johnston" writes: >> > On Thu, Feb 17, 2022 at 6:17 PM Tom Lane wrote: >> >> There is no bug here; it's operating as designed and documented. >

Re: alter function/procedure depends on extension

2022-04-12 Thread Tom Lane
"David G. Johnston" writes: > - A function that's marked as dependent on an extension is automatically > - dropped when the extension is dropped. > + A function that's marked as dependent on an extension is skipped during > + dependency checking in restrict mode linkend="sql-d

Re: alter function/procedure depends on extension

2022-04-12 Thread David G. Johnston
On Tue, Apr 12, 2022 at 8:49 AM Tom Lane wrote: > "David G. Johnston" writes: > > - A function that's marked as dependent on an extension is > automatically > > - dropped when the extension is dropped. > > + A function that's marked as dependent on an extension is skipped > during

Feedback about hybrid SAN snap and rsync'd approach for large systemcloning

2022-04-12 Thread Jerry Sievers
Suppose we have a DB cluster with an additional tablespace and we are able to make an atomic SAN snapshot of *only* the main cluster volume... The additional tablespace contains only UNLOGGED relations. We cannot snap that volume so we use rsync as follows... 1. pg_start_backup('foo'); make SAN

Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql

2022-04-12 Thread Adrian Ho
On 12/4/22 18:33, cecile rougnaux wrote: My system is OS Mojave 10.14.6, I got homebrew from this command :  /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" when I try to install postgresql with the command brew install postgresql