Re: [BUGS] BUG #5899: Memory corruption when running psql

2011-03-07 Thread Dave Page
On Mon, Mar 7, 2011 at 5:20 PM, SandraA wrote: > I am also having this problem.  I used the One-Click installer provided by > EnterpriseDB to install PostgreSQL 9.0.3.  Is there a fix for the bug? There is a fix in QA. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake Enterprise

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-07 Thread Euler Taveira de Oliveira
Em 07-03-2011 16:53, Owen Jacobson escreveu: psql:repro.sql:2: ERROR: must be member of role "commented_role" to comment upon it This isn't a bug; let say it is a limitation (and a documented one [1]). Unfortunately only the role, superuser or its members can add/drop comments. [1] http://w

Re: [BUGS] BUG #5919: released zipped files have problem

2011-03-07 Thread Dave Page
On Tue, Mar 8, 2011 at 1:32 AM, Jacob Lee wrote: > > The following bug has been logged online: > > Bug reference:      5919 > Logged by:          Jacob Lee > Email address:      jacobswel...@yahoo.com > PostgreSQL version: 9.0.3 > Operating system:   windows XP > Description:        released zippe

Re: [BUGS] BUG #5920: SQL function are probably "overoptimized"

2011-03-07 Thread Itagaki Takahiro
On Tue, Mar 8, 2011 at 12:49, Matyas Novak wrote: > Bug reference:      5920 > > create or replace function f2 () returns void volatile language sql as > $$ >  select f1(tmp) from (values ('aa'), ('bb')) _tmp(tmp); > $$; > select f2(); > > As a result, only one row appears in table a, although two

[BUGS] BUG #5920: SQL function are probably "overoptimized"

2011-03-07 Thread Matyas Novak
The following bug has been logged online: Bug reference: 5920 Logged by: Matyas Novak Email address: lo...@centrum.cz PostgreSQL version: 9.0.1 Operating system: linux Description:SQL function are probably "overoptimized" Details: create table a(a integer); create o

Re: [BUGS] BUG #5916: PGAdmin crash

2011-03-07 Thread Allan E. Registos
Thanks for that, I will do that. Sorry for the inconvenience it made. - Original Message - From: "Kevin Grittner" To: pgsql-bugs@postgresql.org, "Allan Registos" Sent: Tuesday, March 8, 2011 12:03:19 AM Subject: Re: [BUGS] BUG #5916: PGAdmin crash "Allan Registos" wrote: > When

[BUGS] BUG #5919: released zipped files have problem

2011-03-07 Thread Jacob Lee
The following bug has been logged online: Bug reference: 5919 Logged by: Jacob Lee Email address: jacobswel...@yahoo.com PostgreSQL version: 9.0.3 Operating system: windows XP Description:released zipped files have problem Details: the oneclick installer version has

[BUGS] BUG #5918: SummarizeOldestCommittedSxact assertion failure

2011-03-07 Thread YAMAMOTO Takashi
The following bug has been logged online: Bug reference: 5918 Logged by: YAMAMOTO Takashi Email address: y...@mwd.biglobe.ne.jp PostgreSQL version: 9.1devel Operating system: NetBSD Description:SummarizeOldestCommittedSxact assertion failure Details: running 05d93c3

Re: [BUGS] Hung Vacuum in 8.3

2011-03-07 Thread Mark Kirkwood
On 08/03/11 13:03, Mark Kirkwood wrote: On 08/03/11 12:55, Mark Kirkwood wrote: On 23/02/11 10:18, Mark Kirkwood wrote: On 23/02/11 00:26, Greg Stark wrote: It's also possible there's a bug of course. If someone was using that buffer and somehow failed to notify the vacuum that they were done

Re: [BUGS] Hung Vacuum in 8.3

2011-03-07 Thread Greg Stark
On Mon, Mar 7, 2011 at 11:55 PM, Mark Kirkwood wrote: >  stuff   |   23957 | 2011-03-08 06:02:02.659159+13 | VACUUM ANALYZE; > For what it's worth VACUUM ANALYZE does have to take an additional lock to update the statistics. It should rarely cause any problems but it is a possibility. When you d

Re: [BUGS] Hung Vacuum in 8.3

2011-03-07 Thread Mark Kirkwood
On 08/03/11 12:55, Mark Kirkwood wrote: On 23/02/11 10:18, Mark Kirkwood wrote: On 23/02/11 00:26, Greg Stark wrote: It's also possible there's a bug of course. If someone was using that buffer and somehow failed to notify the vacuum that they were done it would wait for a very long time (fore

Re: [BUGS] Hung Vacuum in 8.3

2011-03-07 Thread Mark Kirkwood
On 23/02/11 10:18, Mark Kirkwood wrote: On 23/02/11 00:26, Greg Stark wrote: It's also possible there's a bug of course. If someone was using that buffer and somehow failed to notify the vacuum that they were done it would wait for a very long time (forever?). However if vacuum eventually conti

[BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-07 Thread Owen Jacobson
Salut, I'm making use of database-side comments to document the oddities and intended uses for various database symbols. While this is mostly going well, it's falling down a bit for documenting role objects. For the record, I'm running the EnterpriseDB Postgres 9.0.3 package on OS X 10.6 as well a

Re: [BUGS] BUG #5899: Memory corruption when running psql

2011-03-07 Thread SandraA
I am also having this problem. I used the One-Click installer provided by EnterpriseDB to install PostgreSQL 9.0.3. Is there a fix for the bug? -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5899-Memory-corruption-when-running-psql-tp3398967p3412773.html Sent from

Re: [BUGS] Missing Bug-Report #5904?

2011-03-07 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > Now for the Problem: There is a problem with the translation of the > english word "March" to the german "März". Instead of "März" i get > "MäRz" (with uppercase "r"). > You can reproduce it as follow: > # SET lc_time = "de_DE.UTF-8"; > # SELECT

Re: [BUGS] Corrupted index on 9.0.3 streaming hot standby

2011-03-07 Thread Robert Haas
On Mon, Mar 7, 2011 at 9:15 AM, Jakub Ouhrabka wrote: > for the archives: the root cause is locale. Both linux/debian servers were > set to the same locale (cs_CZ.UTF-8) but there is slightly different > definition of this locale on those systems - once numbers are before letters > and another tim

Re: [BUGS] BUG #5916: PGAdmin crash

2011-03-07 Thread Kevin Grittner
"Allan Registos" wrote: > When I press the SQL query, the whole pgadmin will close. > Although, it works previously. You might have a better chance of getting the attention of the right people if you post to the pgadmin-support list. Even then, you probably need to provide more information fo

Re: [BUGS] pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()

2011-03-07 Thread Tom Lane
I wrote: > So yeah, something is pretty hosed here, but I don't think it's > pg_stat_reset's fault ... Oh, I see the problem: pgstat_recv_tabstat isn't bothering to initialize those fields in a new entry. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@

Re: [BUGS] pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()

2011-03-07 Thread Tom Lane
Itagaki Takahiro writes: > Some of pg_stat_all_tables.vacuum_count, autovacuum_count, analyze_count > and autoanalyze_count will be filled with garbages after pg_stat_reset(). > Not all of the tables, but some of tables had corrupted counters. > It looks we access freed memory. 9187201950435737471

Re: [BUGS] Corrupted index on 9.0.3 streaming hot standby

2011-03-07 Thread Jakub Ouhrabka
Hi, for the archives: the root cause is locale. Both linux/debian servers were set to the same locale (cs_CZ.UTF-8) but there is slightly different definition of this locale on those systems - once numbers are before letters and another time numbers are after letters. Then the index appears t

[BUGS] pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()

2011-03-07 Thread Itagaki Takahiro
Some of pg_stat_all_tables.vacuum_count, autovacuum_count, analyze_count and autoanalyze_count will be filled with garbages after pg_stat_reset(). Not all of the tables, but some of tables had corrupted counters. It looks we access freed memory. 9187201950435737471 is 7F7F7F7F7F7F7F7F filled by CLO