Hello,
I noticed a change of behaviour since PostgreSQL 14.14 that is breaking the
permissions in my application: it looks like the “ALTER ROLE IN DATABASE
SET ROLE ” is no longer applied when is connecting to
the database. For example, I have this setup to create my database and roles:
--
On Mon, Nov 18, 2024 at 2:24 PM Maxime Legault-Venne <
m.legault-ve...@metrio.net> wrote:
>
> I noticed a change of behaviour since PostgreSQL 14.14 that is breaking
> the permissions in my application: it looks like the “ALTER ROLE IN
> DATABASE SET ROLE ” is no longer applied when is
> connec
On Mon, 2024-11-18 at 15:37 +0100, Moreno Andreo wrote:
> I'm creating indexes for some tables, and I came across a doubt.
>
> If a column appears in the WHERE clause (and so it should be placed in
> index), in case it is "processed" in a function (see below), is it
> possible to insert this fun
On Mon, 2024-11-18 at 18:11 +0200, Alexandru Lazarev wrote:
> Highly appreciate your response. But I have some additional questions (inline)
>
> On Thu, Nov 14, 2024 at 4:40 PM Laurenz Albe wrote:
> > On Wed, 2024-11-13 at 21:09 +0200, Alexandru Lazarev wrote:
> >
> > > My questions are as follo
On 11/18/24 01:03, 張宸瑋 wrote:
Hello!
I would like to inquire about the installation of the credcheck
third-party package to support password complexity and expiration date,
etc., when setting up open-source PostgreSQL. I am using the
credcheck--2.8.0.sql version from GitHub. After completin
On Mon, 2024-11-18 at 17:22 +, Thomas Schweikle wrote:
> Had installed PostgreSQL 16.5 on Windows 10:
>
> Install directory: "C:\PRGS\pgSQL\16"
> DB-Directory: "C:\DB\pgSQL\16\data"
>
> Environment variable "PGDATA" is set to "C:\DB\pgSQL\16\data".
>
> Initialized the database. Then sta
On 11/18/24 09:22, Thomas Schweikle wrote:
Hi!
Had installed PostgreSQL 16.5 on Windows 10:
Using what installer?
Install directory: "C:\PRGS\pgSQL\16"
DB-Directory: "C:\DB\pgSQL\16\data"
Environment variable "PGDATA" is set to "C:\DB\pgSQL\16\data".
Initialized the database. Then st
Hi!
Had installed PostgreSQL 16.5 on Windows 10:
Install directory: "C:\PRGS\pgSQL\16"
DB-Directory: "C:\DB\pgSQL\16\data"
Environment variable "PGDATA" is set to "C:\DB\pgSQL\16\data".
Initialized the database. Then started postgres services using:
c:\PRGS\pgSQL\16\bin\pg_ctl.exe start
Hi @Laurenz Albe & PG Community,
Highly appreciate your response. But I have some additional questions
(inline)
On Thu, Nov 14, 2024 at 4:40 PM Laurenz Albe
wrote:
> On Wed, 2024-11-13 at 21:09 +0200, Alexandru Lazarev wrote:
> > I have some questions regarding how the "work_mem" parameter affe
On Mon, 18 Nov 2024 15:37:57 +0100
Moreno Andreo wrote:
> If a column appears in the WHERE clause (and so it should be placed
> in index), in case it is "processed" in a function (see below), is it
> possible to insert this function to further narrow down things?
You probably want to look at
ht
Hi folks,
I'm creating indexes for some tables, and I came across a doubt.
If a column appears in the WHERE clause (and so it should be placed in
index), in case it is "processed" in a function (see below), is it
possible to insert this function to further narrow down things?
Common index:
SE
Hi,
On Mon, Nov 18, 2024 at 5:03 PM 張宸瑋 wrote:
>
> Hello!
> I would like to inquire about the installation of the credcheck third-party
> package to support password complexity and expiration date, etc., when
> setting up open-source PostgreSQL. I am using the credcheck--2.8.0.sql
> version
Hello!
I would like to inquire about the installation of the credcheck
third-party package to support password complexity and expiration date,
etc., when setting up open-source PostgreSQL. I am using the
credcheck--2.8.0.sql version from GitHub. After completing the setup, I
encountered the follo
13 matches
Mail list logo
