[Babase] Query error?

Karl O. Pinc kop at meme.com
Thu Aug 24 22:47:13 EDT 2006


On 08/24/2006 09:21:09 PM, Catherine Markham wrote:
> 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?

https://papio.biology.duke.edu/phpPgAdmin/

> 
> 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
> _______________________________________________
> 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



More information about the Babase mailing list