Re: [postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread Marijn Haverbeke
> I would be happy with any mechanism at all which would enable me to > cope with such non-conforming databases.  What's the Right Thing to > do? The problem is that Postmodern went with a 'simplify Lisp symbols to get credible SQL names' scheme that assumes those credible SQL names are not escape

Re: [postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread John Morrison
On Tuesday 14 June 2011, r...@tuxteam.de wrote: > Sorry, but colons aren't a avalid part of an SQL identifier. I would be happy with any mechanism at all which would enable me to cope with such non-conforming databases. What's the Right Thing to do? > This smells like open streetmap ... must hav

Re: [postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread rm
On Tue, Jun 14, 2011 at 08:33:34AM -0400, John Morrison wrote: > On Tuesday 14 June 2011, Marijn Haverbeke wrote: > > If colons are safe in SQL field names, you can change > > s-sql::to-sql-name to leave them intact (there seems to already by an > > exception for * characters). > > Thanks, and wil

Re: [postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread Zach Beane
John Morrison writes: > On Tuesday 14 June 2011, Marijn Haverbeke wrote: >> If colons are safe in SQL field names, you can change >> s-sql::to-sql-name to leave them intact (there seems to already by an >> exception for * characters). > > Thanks, and will do... > > As regards colons in column nam

Re: [postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread John Morrison
On Tuesday 14 June 2011, Marijn Haverbeke wrote: > If colons are safe in SQL field names, you can change > s-sql::to-sql-name to leave them intact (there seems to already by an > exception for * characters). Thanks, and will do... As regards colons in column names: while I am by no means an exper

Re: [postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread Marijn Haverbeke
> A trip into the debugger leads me to believe that the slot name > |addr:city| in the dao-class defclass gets rewritten as "addr_city", If colons are safe in SQL field names, you can change s-sql::to-sql-name to leave them intact (there seems to already by an exception for * characters). > p.s.,

[postmodern-devel] using dao-class on database with column names like "addr:city"

2011-06-14 Thread John Morrison
Hi All; Sorry if this is a dumb newbie question. I have a PostGIS database with column names that are rather unfortunate (and created not by me but by/via many different bits of GIS software, and they sadly seem not to have mechanisms to specify rewriting of column names on the fly during the wor