Re: [BUGS] BUG #6572: The example of SPI_execute is bogus

2012-04-04 Thread Hitoshi Harada
ound tcount parameter is said to be applied to even INSERT. I believe people think that parameter is to limit memory consumption when returning tuples thus it'd be applied for only SELECT or DML with RETURNING. So I'm +1 for non-fix but redefine the behavior. Who wants to limit the numbe

[BUGS] BUG #6172: DROP EXTENSION error without CASCADE

2011-08-21 Thread Hitoshi Harada
The following bug has been logged online: Bug reference: 6172 Logged by: Hitoshi Harada Email address: umi.tan...@gmail.com PostgreSQL version: 9.1RC1 Operating system: Windows7 Description:DROP EXTENSION error without CASCADE Details: On pure-installed RC1

[BUGS] BUG #6139: LIMIT doesn't return correct result when the value is huge

2011-08-01 Thread Hitoshi Harada
The following bug has been logged online: Bug reference: 6139 Logged by: Hitoshi Harada Email address: umi.tan...@gmail.com PostgreSQL version: 8.2+ Operating system: Any Description:LIMIT doesn't return correct result when the value is huge Details: db1=# s

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

2010-08-13 Thread Hitoshi Harada
gt; are only aggregates that have "internal" for aggtranstype. So, is it better to generalize as it adds ALLOCSET_DEFAULT_INITSIZE if the transtype is internal, rather than specifying individual function OID as the patch stands? Regards, -- Hitoshi Harada -- Sent via pgsql-bugs mailin

Re: [BUGS] BUG #5123: bug in window function "last_value"

2009-10-16 Thread Hitoshi Harada
the correct answers, since the default window frame runs > from first row to current row.  If you don't like them, you may need > to specify a different window frame. > >                        regards, tom lane > And it's well-documented. See http://www.postgresql.org/docs

Re: [BUGS] BUG #5025: Aggregate function with subquery in 8.3 and 8.4.

2009-09-01 Thread Hitoshi Harada
bbb | f| bbb ccc | t| (3 rows) So the 1. ROW(...) construction seems not valid. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: &