Mariel Cherkassky wrote: > The solution you suggested arent helpfull (both unique index and pg_partman) because I need to > make sure that in all the partitions I have a specific column that is unique. > In otherwords one column can have the same value in two different partitions and that > is the concept of the global index. There is no way to guarantee uniqueness across partitions in PostgreSQL. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com