[Babase] Query error?

Catherine Markham amarkham at princeton.edu
Thu Aug 24 22:21:09 EDT 2006


Karl,

I'm working at home at right now and it looks like I don't have the link 
to the online website.  If you're online, can you send me the address 
and I'll try to recreate the query error?

Thanks,
Catherine

Karl O. Pinc wrote:
> 
> On 08/24/2006 09:02:48 PM, Catherine Markham wrote:
>> Hi all,
>>
>> I have a question about the query below.  We were working in the new 
>> system this afternoon and Laurence wanted to select all the rows in 
>> repstats where a female was pregnant during 1999-2005.  What I tried was:
>>
>> create table play4 as
>> select * from repstats where state = 'P' and date > '1999-12-31' and 
>> date < '2006-01-01' order by date;
>>
>> This did give us an output which, as far as we could tell, seemed 
>> correct.  However, the system displayed a message saying there was a 
>> query error.
>>
>> Karl and Leah, do you see the mistake?
> 
> What was the error message?  That's the first question.
> 
> Unless your search path is set to put your personal schema
> first then you're trying to create a table in the babase
> schema and you don't have permissions to do so.  Qualify
> the table name with the schema.  (amarkham.play4)
> 
> Can you have a table name with a digit in it?
> 
> The select statement works, so it must be in the create table
> part if it's a syntax error.
> 
> 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