Hi again, I realized I can't mix function partitioning with the new DDL partitioning. Sorry for the stupid question. Thanks again, Nunks On 10/30/18, nunks <nunks.lol@xxxxxxxxx> wrote: > Hi, > > What is the error code for capturing "no partition or relation found > for row" errors on PL/pgSQL? I feel there should be a specific error > code for that, but I can't find it in the documentation. > > In the past, with function partitioning schemes, I used > "undefined_table" exceptions, but it doesn't work with new Postgres 11 > partitioning. > > Judging by the executor code in execPartition.c, the error code seems > to be ERRCODE_CHECK_VIOLATION, but listening for "check_violation" on > EXCEPTION blocks doesn't work. > > Even if it worked, though, wouldn't it collide with other CHECK > constraint violations? I'm writing a function to create partitions > automatically on insert, and this mixed behavior could trigger an > unwanted "CREATE TABLE ... PARTITION OF ..." > > > Thanks! > Nunks > > ---------- > “Life beats down and crushes the soul and art reminds you that you have > one.” > > > - Stella Adler > -- ---------- “Life beats down and crushes the soul and art reminds you that you have one.” - Stella Adler
