[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