Ticket #962 (closed defect: fixed)

Opened 6 years ago

Last modified 3 years ago

Postgresql field count wrong

Reported by: cfis@… Owned by: warmerdam
Priority: high Milestone: 1.6.1
Component: OGR_SF Version: unspecified
Severity: normal Keywords:
Cc:

Description 

Load tiger data into schema A in a postgres database.
Load tiger data into schema B in a postgres database.

The next time ogr connect to postgresql it will double the number of fields for
each table - say entitynames.

The right solution is for each Postgresql layer know which schema it belongs to
and then add that to the SELECT statement at line 271 of ogrpgtablelayer.

The quick hack solution is to add DISTINCT to the select statement.  I have
checked the quick hack in.

Change History

Changed 3 years ago by rouault

  • status changed from new to closed
  • resolution set to fixed
  • milestone set to 1.6.1

The described issue has probably be fixed since a few releases, but when actually trying to test it, I discovered there was a remaining bug somehow related to that.

Fixed in trunk in r16119, in branches/1.6 in r16120 and test adjusted in r16121

Note: See TracTickets for help on using tickets.