[Babase] Query trouble

Catherine Markham amarkham at princeton.edu
Thu Mar 19 17:18:20 EDT 2009


Hi Karl,

It was the caps in the column names that messed me up.  After reading 
your comments, I changed everything to lower case and the query worked 
perfectly.  Thanks!

Catherine

Karl O. Pinc wrote:
> 
> On 03/18/2009 08:24:01 PM, Catherine Markham wrote:
>> Hi all,
>>
>> Has anyone ever got the SQL error code that a column in their table 
>> does not exist?  Two tables that I recently created in my schema are 
>> having the same query problem, but other (older) tables in my schema 
>> and the Babase tables work great with comparable queries.
>>
>> Any thoughts?  Would any other info help to figure out what the 
>> problem is?
> 
> Are you qualifying the column names with the table name and the
> table name with the schema name?  There may be another table
> with the same name in another schema that's confusing it.
> There's a "search path", but I forget what it's called.
> If you're using the ppa sql popup window it's in the window
> somewhere.
> 
> Do you have any upper case in the column names?
> If so you may need to enclose
> the names of the columns in single quotes 'tablename.colname' or
> just 'colname'.  Using upper case is not a good idea.
> 
>>
>> Thanks - I'm definitely stumped since I know the query structure 
>> itself works in other tables (leading me to believe it is something 
>> funky with these tables).
>>
>> Catherine
>>
>> P.S. Specific example resulting in the same error message from a 
>> simplified query here:
>>
>> SQL error:
>>
>> ERROR:  column tempcode.grp does not exist
>>
>> In statement:
>> select tempcode.grp from tempcode
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
> 
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase


More information about the Babase mailing list