[PostGIS] #2045: pgsql2shp should not require temp table creation privs when dumping a query

[PostGIS]

#2045: pgsql2shp should not require temp table creation privs when dumping a query
----------------------------------+-----------------------------
  Reporter:  strk                 |      Owner:  stefanpetrea
      Type:  enhancement          |     Status:  closed
  Priority:  medium               |  Milestone:  PostGIS Fund Me
 Component:  utils/loader-dumper  |    Version:  master
Resolution:  fixed                |   Keywords:  gsoc
----------------------------------+-----------------------------
Changes (by Darafei Praliaskouski <me@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"a57ccdcaccaceb74534024c795fabd51989ef69e/git"
 a57ccdca/git]:
 {{{#!CommitTicketReference repository="git"
 revision="a57ccdcaccaceb74534024c795fabd51989ef69e"
 pgsql2shp: avoid temp tables for query dumps

 Describe query exports with a zero-row derived relation and scan the same
 derived relation directly instead of materializing the query into a
 temporary table. This lets low-privilege and read-only-compatible query
 dumps proceed without TEMP privileges while preserving the existing table
 export path.

 Add a dumper regression that revokes TEMP on the regression database and
 exports a SELECT query with a trailing semicolon.

 Closes #2045
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2045#comment:18>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.