Partitions are not excluded in stored procedures - Mailing list pgsql-novice

From Ioannis Anagnostopoulos
Subject Partitions are not excluded in stored procedures
Date
Msg-id 4FCE2BD3.1020803@gmail.com
Whole thread Raw
List pgsql-novice
Hi there,

I came across the following problem. Say I have a select query that
given the appropriate where clauses it will only query the correct
partitioned tables and not all of them.  That can be examined by using
the EXPLAIN. However the same select query used in a stored procedure
will transverse all the tables regardless of the where clause parameters
passed by the user as variables of the stored procedure . Is there any
work around other than composing an EXECUTE "select ....."?

Kind Regards
Yiannis


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why would Postgres not show in my data connections?
Next
From: Ioannis Anagnostopoulos
Date:
Subject: Re: Partitions are not excluded in stored procedures