Re: [pmapper-users] PostGIS Queries

2007-11-08 Thread Kyle Wilcox
Awesome catch, thanks. All working now. Armin Burger wrote: > Kyle > > I enabled the DEBUG for the layers and I discovered the problem with > your data definition when applying the query directly on the table: > > You specified 'USING UNIQUE gid' but gid is not unique after the joining > sinc

Re: [pmapper-users] PostGIS Queries

2007-11-08 Thread Armin Burger
Kyle I enabled the DEBUG for the layers and I discovered the problem with your data definition when applying the query directly on the table: You specified 'USING UNIQUE gid' but gid is not unique after the joining since you multiply it with the joins. If you specify 'USING UNIQUE pid' then ev