Hi
A simple question before design.
Would there be performance issues having perhaps a million users, each
having several roles? I could imagine a user would have on average 10-20
roles.
Roles would be used to allow or restrict access to tables or rows
according to the business rules.
/kaare
On Tue, Nov 12, 2024 at 1:35 AM Peter Geoghegan wrote:
> On Mon, Nov 11, 2024 at 12:41 AM yudhi s
> wrote:
> > So it means it will ensure no duplication happens for ID values, but
> still we are seeing "duplicate key" error. So what is the possible reason
> here or are we encountering any buggy
On Tue, Nov 12, 2024 at 3:38 PM yudhi s wrote:
> Can you share your thoughts on how exactly this merge query can possibly
> cause the duplicate key error?
MERGE doesn't take any special precautions to avoid such unique
violations. ON CONFLICT does. It really is that simple.
Your app will be pro
On 11/11/24 22:09, JOLAPARA Urvi (SAFRAN) wrote:
C2 - Confidential
This is a publicly readable list, the above has no meaning in that context.
Hello Klaver,
We are using PSADT for creating a script and installing through SCCM.
1) I don't work with Windows so I have no idea what the above
The documentation tells you, down in the Notes section.
https://www.postgresql.org/docs/16/sql-createpublication.html
On Tue, Nov 12, 2024 at 5:46 AM Jayadevan M
wrote:
> Hello all,
>
> I am using PostgreSQL 16.4. I tried to set up logical replication with
> "postgres" user and all worked fine.
In PG16.4, we have a table of key/pair data (around 30M rows) where there
are about 7 distinct keys and each has a conditional or partial index on
them (the distribution is different for each key/value pair combination).
I've found that when we have a query that uses an OR then those partial
indexe
Hello all,
I am using PostgreSQL 16.4. I tried to set up logical replication with
"postgres" user and all worked fine. Then I created a new user
(my_replication) to be used for the purpose and couldn't figure out which
privileges are necessary. Initially I got an error like "ERROR: permission
de
C2 - Confidential
Hello Klaver,
We are using PSADT for creating a script and installing through SCCM.
And when we are installing Through Software center it is throwing error as
below:
"There has been an error
error while writing file
C:\windows\Temp\postgresql_installer_8b85d458af\temp_check_c
On Mon, 2024-11-11 at 15:10 -0800, Mark Phillips wrote:
> PostgreSQL 12
Upgrade now!
> Given a table “customer” with a column “deadfiled” of the type boolean. The
> column
> deadfiled is used to indicate that a row is “in the trash bin”. The app has a
> window
> that lists the contents of the “
PostgreSQL 12
Given a table “customer” with a column “deadfiled” of the type boolean. The
column deadfiled is used to indicate that a row is “in the trash bin”. The app
has a window that lists the contents of the “trash bin”, which any rows with
deadfiled = true. Row so marked should be excluded
10 matches
Mail list logo
