[postgis-tickets] [PostGIS] #3060: loader_load_staged_data relying on undefined behaviour when generating column lists
PostGIS
trac at osgeo.org
Thu May 12 11:49:38 PDT 2016
#3060: loader_load_staged_data relying on undefined behaviour when generating
column lists
-----------------------------+---------------------------
Reporter: gibreel | Owner: robe
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 2.3.0
Component: tiger geocoder | Version: 2.1.x
Resolution: fixed | Keywords: loader
-----------------------------+---------------------------
Changes (by robe):
* status: new => closed
* resolution: => fixed
Comment:
I've fixed this already since I ran into the same issue logged in #3347
when I had a lot of tables. I ended up ordering by ordinal_position
instead of column name at r14317 (and other branches)
```
ORDER BY ordinal_position
```
The reason is that the names might actually change but sequence of order
is more important.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3060#comment:5>
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.
More information about the postgis-tickets
mailing list