[eml-dev] [Bug 2737] New: - Exception when attributeName contains SQL keywords

[bugzilla-daemon@ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2737

           Summary: Exception when attributeName contains SQL keywords
           Product: EML
           Version: 2.0.1
          Platform: Macintosh
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: datamanager
        AssignedTo: tao at nceas.ucsb.edu
        ReportedBy: cburt at msi.ucsb.edu
         QAContact: eml-dev at ecoinformatics.org


A dataset I'm working with has columns named "group" and "order". When trying
to import the dataset into a sql database using the DataManager library I get
this exception:

SQLException: ERROR: syntax error at or near "group"

The library has a problem with columns named after SQL keywords. While group
may be easier to avoid, order would not when storing taxonomic info. There is a
large list of reserved keywords for postgres including Year, Datestamp, etc
that I haven't yet tested.

Here is a link to the problem dataset:
http://sbcdata.lternet.edu/catalog/metacat?action=read&qformat=sbclter&docid=knb-lter-sbc.17.2&displaymodule=entity&entitytype=dataTable&entityindex=1