Re: [BUGS] BUG #5620: PostgreSQL won't accept the word "user" as a valid column name

2010-08-14 Thread Stefan Kaltenbrunner
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

Re: [BUGS] BUG #5620: PostgreSQL won't accept the word "user" as a valid column name

2010-08-14 Thread Tom Lane
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 >

Re: [BUGS] BUG #5608: array_agg() consumes too much memory

2010-08-14 Thread Tom Lane
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

Re: [BUGS] BUG #5608: array_agg() consumes too much memory

2010-08-14 Thread Tom Lane
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