[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