On 2024-Jun-18, Philipp Faster wrote:
> I've done a bad job describing my issue in the first place: I left out a
> key definition statement that I thought doesn't play any role in the issue:
> another unique index on the same columns as PK.
I see. That unique index seems quite useless. Why not j
Hey Alvaro and everyone,
Thank you for replying! I've checked `pg_dump -s`, but it didn't help - the
definition here was exactly the same (except order, but I didn't notice it
since in my actual schema there are thousands of rows).
I've done a bad job describing my issue in the first place: I lef
On 2024-Jun-18, Philipp Faster wrote:
> As I understand, PostgreSQL refuses to use existing primary key for
> some reason and tries to create its own as a children of
> "Transactions" table's primary key.
Yeah. Your case sounds like the primary key in the partitioned table
has some slight defini
Hello everyone!
Using Postgres v15.5. I'm struggling to attach a partition to a table with a
primary key.
I have a partitioned table `Transactions`:
```
create table "Transactions"
(
id bigserial
not null,
uid uuid
