Hi list, I'm trying to do some partitioning on a table but I have a problem with constraint exclusion. Here the following code : https://gist.github.com/1038133 (this code is just an example to explain the problem) As you can see I declare a fake immutable function in order to make constraint exclusion work even if the function is not immutable at all. On Postgres 9.1beta2 when i run this code the first select will use contraint exclusion but the second will not. This apparently has something to do with the size of the array returned by the fake immutable function. Is there a way to force the use of constraint exclusion no matter the size of the array used in the check constraint ? Regards. -- Sylvain -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
