Re: FK to partitioned table

2021-06-29 Thread richard coleman
Piotr, Thanks for the question. This is the pgAdmin4 (a GUI for managing PostgreSQL databases) list. You might have better luck on the postgres list Pgsql-admin . Good luck, rik. On Tue, Jun 29, 2021 at 8:28 AM Piotr Włodarczyk < piotrwlodarczy...@gmail.com> wrote: > Hello geeks, > > I have

FK to partitioned table

2021-06-29 Thread Piotr Włodarczyk
Hello geeks, I have a question I can't find any answer. First we need some basic structure. So it is: CREATE SCHEMA parts AUTHORIZATION postgres; DROP TABLE IF EXISTS parts.main; CREATE TABLE IF NOT EXISTS parts.main ( id bigserial NOT NULL, id_ext bigint NOT NULL,