User 6cb834d88c
01-09-2005 15:40:48
Versions: Mac OS X 10.4.2, Postgresql 8.0.3, jcman 3.1
I'm trying to import records from an SD file. Each record has a data header with a field name of (for example) 'gumby'. If the field name is all-uppercase or all-lowercase, the import succeeds -- the values in the structure table are non-null. If the field name is mixed-case, the values in the structure table are null.
Here are examples of usage:
In all cases, all structures are imported successfully. But in the last case only, all values for structure.imported_gumby are null.
In all cases, the Postgresql data type for structure.imported_gumby is 'text'.
What am I doing wrong? Thanks for the help.
I'm trying to import records from an SD file. Each record has a data header with a field name of (for example) 'gumby'. If the field name is all-uppercase or all-lowercase, the import succeeds -- the values in the structure table are non-null. If the field name is mixed-case, the values in the structure table are null.
Here are examples of usage:
| Quote: |
| # This works: jcman a structure sample_lowercase.sdf --connect "imported_gumby=gumby" # This works: jcman a structure sample_uppercase.sdf --connect "imported_gumby=GUMBY" # This does not work: jcman a structure sample_titled.sdf --connect "imported_gumby=Gumby" |
In all cases, the Postgresql data type for structure.imported_gumby is 'text'.
| Quote: |
| jcman t structure ... 21 imported_gumby text |