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 will do...
As regards colons in column names: while I am by no means an experienced SQL guy, AFAICT the various GIS tools I am using all seem (so far) to be functioning correctly on databases with those column names.
Sorry, but colons aren't a avalid part of an SQL identifier.
A <regular identifier> is a character string, up to 128 characters long, that consists only of letters, digits, and underscore characters. It must begin with a letter.
In standard-conforming SQL 'addr:city' only works as a delimited identifier:
A <delimited identifier> is a character string, up to 128 characters long, surrounded by a pair of double quote marks. (The delimiting double quotes aren't part of the <identifier>, so they're not included in the calculation of its size.) Two consecutive double quotes within the character string (i.e., "") represent one double quote mark; together, they count as one character when calculating the size of the <identifier>.
A <delimited identifier> is case sensitive. That is, uppercase and lowercase letters within a <delimited identifier> are not interchangeable;
This smells like open streetmap ... must have been SQL gurus that designed that schema :-/
Slot names can be locked? I've never heard of that. How?
IIRC I got a package lock violation when naming the dao-class' slot "type" to mirror the SQL column name. I will go back and look again - only spent 2 seconds kludging around it, as I ran into the colon problem on the same table....
This seems wrong. The symbol 'type' only causes lock-problems when you try to bind its function value. Are you shure you didn't:
(defclass foo () ((type :accessor type)))
??? That _would_ try to create a function '(type instance)' and trigger the package lock violation error.
HTH Ralf Mattes
Thanks again for the help!
-jm
postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
-- --- John Morrison --- john.nmi.morrison@gmail.com
postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel