On 08/14/2010 02:14 AM, Samuel Marinov wrote:
The following bug has been logged online:
Bug reference: 5620
Logged by: Samuel Marinov
Email address: samuel.mari...@gmail.com
PostgreSQL version: 9.0b4
Operating system: Ubuntu Linux 10.04 64-bit
Description:PostgreSQL
Stefan Kaltenbrunner writes:
> On 08/14/2010 02:14 AM, Samuel Marinov wrote:
>> ERROR: syntax error at or near "user"
>> LINE 1: create table ftp (user varchar, password varchar);
> not sure why you consider this a bug - but "user" is a reserved word in
> PostgreSQL and the SQL-Standard (see
>
Hitoshi Harada writes:
> 2010/8/14 Itagaki Takahiro :
>> 2010/8/10 Tom Lane :
>>> Eventually it might be nice to have some sort of way to specify the
>>> estimate to use for any aggregate function --- but for a near-term
>>> fix maybe we should just hard-wire a special case for array_agg in
>>> co
Hitoshi Harada writes:
> 2010/8/14 Itagaki Takahiro :
>> The attached patch is the near-term fix; it adds ALLOCSET_DEFAULT_INITSIZE
>> bytes to memory assumption.
>>
>> We might need the same adjustment for string_agg(), that consumes
>> 1024 bytes for the transit condition. array_agg() and strin