Re: [BUGS] BUG #8327: a bug of spgist index in a heavy write condition

2013-08-06 Thread 李海龙
My dear Tom Lane && pgsql-hackers Thanks very very much! I have modified the postgres source code that Tom lane fixed, and the origin phenomenon of that bug no longer appears in my old test case. Thanks again! Best Regards! at 2013-07-24 19:08, Andres Freund wrote: Hi, On 2013-07-24 10

Re: [BUGS] BUG #8366: getClob() stopped working from which version?

2013-08-06 Thread Kevin Grittner
"vaishu.sweet...@gmail.com" wrote: > I have a table with TEXT column in it.. When I used version > 8.3.21 previously, getClob() worked to retrieve the column's > data.. but now its not working.. getString() is working and I am > using that to retrieve the value. Please give the exact version of

Re: [BUGS] "with recursive" ignores side effects?

2013-08-06 Thread David Johnston
Fabien COELHO-3 wrote > The key issue for me is that table Foo is updated (as shown by the last > column), but although 'two' was updated to '*' by iteration 1, the last > iteration still sees the initial 'two' which does not exist anymore. > > Am I wrong somewhere? Or is this a subtle bug? My

[BUGS] "with recursive" ignores side effects?

2013-08-06 Thread Fabien
I have an unexpected issue with a side effects on a table which is ignored by a recursive query. I've tried to simplify the issue to a simple example, see the attached sql script. Version 1 results in: it / fid / stuff / foo full contents 0 | 0 | | {1:one,2:two} 1 | 1 | one | {

Re: [BUGS] BUG #8367: wrong example in 8.17.10

2013-08-06 Thread Tom Lane
koizumi...@minos.ocn.ne.jp writes: > In 8.17.10 "Constraints on Ranges" of PostgreSQL 9.2.4 Documentation, a > constraint will prevent the overlapping values in an example. > But in the example, range [2010-01-01 11:30, 2010-01-01 13:00) and range > [2010-01-01 14:45, 2010-01-01 15:45) do not over

[BUGS] BUG #8367: wrong example in 8.17.10

2013-08-06 Thread koizumistr
The following bug has been logged on the website: Bug reference: 8367 Logged by: KOIZUMI Satoru Email address: koizumi...@minos.ocn.ne.jp PostgreSQL version: 9.2.4 Operating system: MacOSX Description: In 8.17.10 "Constraints on Ranges" of PostgreSQL 9.2.4 Documentati

[BUGS] BUG #8366: getClob() stopped working from which version?

2013-08-06 Thread vaishu . sweety02
The following bug has been logged on the website: Bug reference: 8366 Logged by: developer Email address: vaishu.sweet...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: windows Description: I have a table with TEXT column in it.. When I used versi

[BUGS] BUG #8365: Two documentation suggestions

2013-08-06 Thread bughunt
The following bug has been logged on the website: Bug reference: 8365 Logged by: David Tonhofer Email address: bugh...@gluino.name PostgreSQL version: 9.2.4 Operating system: Linux Description: Suggestions for documentation: "http://www.postgresql.org/docs/9.2/stati