Re: [Qgis-developer] Postgres provider checks queries and refuses CTE

2012-07-10 Thread Giuseppe Sucameli
Hi, On Tue, Jul 10, 2012 at 5:10 PM, Vincent Picavet wrote: > The postgres provider apparently does a check on the input query and only > tolerates queries beginning with "SELECT". the so called "SELECT statement to vector layer" [1] was implemented in PG and SL providers respectively from Qgis

Re: [Qgis-developer] Postgres provider checks queries and refuses CTE

2012-07-10 Thread Sandro Santilli
+1 for dropping the filter -- trust the user ! --strk; On Tue, Jul 10, 2012 at 05:10:23PM +0200, Vincent Picavet wrote: > Hi, > The postgres provider apparently does a check on the input query and only > tolerates queries beginning with "SELECT". > > The more general SQL query form allows for qu

[Qgis-developer] Postgres provider checks queries and refuses CTE

2012-07-10 Thread Vincent Picavet
Hi, The postgres provider apparently does a check on the input query and only tolerates queries beginning with "SELECT". The more general SQL query form allows for queries not beginning with select, but still being valid, as it is the case for CTEs. The only way to have qgis load them is to wra