[postgis-devel] Re: [postgis-users] pgsql2shp changing case of fieldnames

['strk@refractions.net']

Thanks Obe (or Regina?).
I've applied your patch, but I'm not sure about something:
would a DBF be legal if it contains attributes like
'LABEL' and 'label' in the same file ? This would be a valid
postgresql table, but is this true for .dbf ?

In case it isn't we should do a case-insensitive match where 
we check this (around line 2650). I left a TODO there:

     /*
      * TODO: check out if should be case-insensitive
      * here since we might be running in -k mode
      */

--strk;


On Fri, May 13, 2005 at 08:41:54AM -0400, Obe, Regina     DNDMIS wrote:
> I was working off of the cvs hourly build snapshot from the postgis site.
> Unfortunately I'm behind a firewall so don't think I can hit a cvs.  
> 
> I made a diff patch.  Attached is the file.  I hope I did it right.
> 
> Thanks,
> Regina
> 
> 
> -----Original Message-----
> From: 'strk at refractions.net' [mailto:strk at refractions.net] 
> Sent: Friday, May 13, 2005 3:26 AM
> To: Obe, Regina DNDMIS
> Subject: Re: [postgis-users] pgsql2shp changing case of fieldnames
> 
> 
> On Thu, May 12, 2005 at 08:27:57AM -0400, Obe, Regina     DNDMIS wrote:
> > I've made the change in my copy and it seems to work okay so far.  I'm 
> > going to test it a little more.  So I guess I just need to know how to 
> > send you the patch.
> 
> Are you working on a CVS snapshot ?
> If so use cvs diff and send me the output (should be small).
> If you have problems with that just send me the whole pgsql2shp.c file and
> I'll check the changes myself. Thanks.
> 
> --strk;
> 
> > 
> > Thanks,
> > Regina
> > 
> > -----Original Message-----
> > From: strk at refractions.net [mailto:strk at refractions.net]
> > Sent: Tuesday, May 10, 2005 2:42 PM
> > To: Obe, Regina DNDMIS
> > Cc: 'PostGIS Users Discussion'
> > Subject: Re: [postgis-users] pgsql2shp changing case of fieldnames
> > 
> > 
> > I've added the request in the HEAD branch TODO list.
> > If you will do it yourself sooner then us
> > we'll accept patches. Let me know if you plan to do it
> > and feel free to ask any info you might need for that.
> > 
> > --strk;
> > 
> > On Mon, May 09, 2005 at 04:02:46PM -0400, Obe, Regina     DNDMIS wrote:
> > > The old one I had was dated sometime in 2003 and was compiled under
> > > cygwin, but it still seemed to work when I upgraded to 8.0.  I think a 
> > > -k switch would be best.
> > > 
> > > The older version preserved the case that was in postgres so for
> > > situations where we needed UPPERCASE (standard shp behavior) we had to 
> > > create views that had the fields upper cased and dumped those out; so 
> > > this new version irradicates that need.  There are some situations 
> > > where it is convenient to keep the same case as postgres - e.g. it 
> > > makes it easier to swap out a postgis layer with a shape layer where 
> > > postgis is not feasible for a particular environment.  I'm assuming 
> > > mapserver is still case sensitive with field names in templates.
> > > 
> > > -----Original Message-----
> > > From: strk at refractions.net [mailto:strk at refractions.net]
> > > Sent: Monday, May 09, 2005 11:26 AM
> > > To: 'PostGIS Users Discussion'
> > > Subject: Re: [postgis-users] pgsql2shp changing case of fieldnames
> > > 
> > > 
> > > On Mon, May 09, 2005 at 10:18:52AM -0400, Obe, Regina     DNDMIS wrote:
> > > > I noticed the 3/31/05 build of pgsql2shp I have now automatically 
> > > > forces the output field names to upper case which normally would 
> > > > be a good thing. Unfortunately I've got some old mapserver maps 
> > > > that rely on the field names in the dbf being in lowercase.  Is 
> > > > there anyway to reverse this behavior e.g. with a switch or 
> > > > something of that sort so that I don't have to revert back to the 
> > > > older version of pgsql2shp?
> > > >  
> > > > Thanks,
> > > > Regina
> > > 
> > > Which version of pgsql2shp doesn't do that ?
> > > I guess we can revert the change back ... or add a -k switch to it 
> > > as
> > > well.
> > > 
> > > Does anyone see a problem with this ?
> > > 
> > > --strk;
> > > _______________________________________________
> > > postgis-users mailing list postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
>