Project

General

Profile

Actions
Copy link

Bug #2737

closed

Exception when attributeName contains SQL keywords

Added by Chad Burt almost 18 years ago. Updated almost 13 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Duane Costa
Category:
datamanager
Target version:
DataManager 1.1.0
Start date:
01/19/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2737

Description

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

Actions
Copy link

Also available in: Atom PDF