Re: [BUGS] pg_upgrade issues

2010-07-23 Thread depstein
I have encountered another problem with pg_upgrade, while migrating from 8.4 to 9.0 (beta2, as well as beta3) on Windows XP Pro. I have a table with a regclass column, which references other tables in the same database: CREATE TABLE common_inst.reg_asset ( asset_id integer NOT NULL, table_n

Re: [BUGS] BUG #5567: will not install

2010-07-23 Thread Denise Kanyuh
Alex, Yes -- I am aware that we are on an old release -- when you say - my hunch is they do not ship binaries for AIX (7.1). what binaries are you taking about --- we use the same installer and files on AIX 6.1 and it works -- it appears that there is something different in AIX 7.1 -- either

[BUGS] BUG #5569: Select in trigger don't retrive true record

2010-07-23 Thread Alessio
The following bug has been logged online: Bug reference: 5569 Logged by: Alessio Email address: a.burga...@gmail.com PostgreSQL version: 8.4.3 build1400 Operating system: Windows 2008 Web Description:Select in trigger don't retrive true record Details: Hi, My trigg

Re: [BUGS] BUG #5569: Select in trigger don't retrive true record

2010-07-23 Thread Pavel Stehule
Hello your trigger is AFTER or BEFORE trigger? Because BEFORE trigger is executed before new value is propagated to table. Regards Pavel Stehule 2010/7/23 Alessio : > > The following bug has been logged online: > > Bug reference:      5569 > Logged by:          Alessio > Email address:      a.b

[BUGS] BUG #5570: global hash %_SHARED does not work in the new version

2010-07-23 Thread Milen
The following bug has been logged online: Bug reference: 5570 Logged by: Milen Email address: m...@avangardsolutions.com PostgreSQL version: v9.0beta2 Operating system: Linux Description:global hash %_SHARED does not work in the new version Details: Hello, We can't

Re: [BUGS] BUG #5567: will not install

2010-07-23 Thread Stefan Kaltenbrunner
On 07/22/2010 07:51 PM, Denise Kanyuh wrote: Alex, Yes -- I am aware that we are on an old release -- any plans to upgrade? when you say - my hunch is they do not ship binaries for AIX (7.1). what binaries are you taking about --- we use the same installer and files on AIX 6.1 and it works

Re: [BUGS] BUG #5570: global hash %_SHARED does not work in the new version

2010-07-23 Thread Alex Hunsaker
On Fri, Jul 23, 2010 at 10:17, Milen wrote: > > The following bug has been logged online: > > Bug reference:      5570 > Logged by:          Milen > Email address:      m...@avangardsolutions.com > PostgreSQL version: v9.0beta2 > Operating system:   Linux > Description:        global hash %_SHARED

Re: [BUGS] BUG #5567: will not install

2010-07-23 Thread Stefan Kaltenbrunner
On 07/23/2010 07:24 PM, Stefan Kaltenbrunner wrote: On 07/22/2010 07:51 PM, Denise Kanyuh wrote: Alex, Yes -- I am aware that we are on an old release -- any plans to upgrade? when you say - my hunch is they do not ship binaries for AIX (7.1). what binaries are you taking about --- we use

Re: [BUGS] BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)

2010-07-23 Thread Alex Hunsaker
On Fri, Jul 16, 2010 at 18:04, Daniel Grace wrote: > However, in some circumstances Postgres will fail How exactly? this is what I get: => SELECT STRING_AGG(DISTINCT t::text order by t::text) FROM foo; string_agg abc (1 row) => SELECT STRING_AGG(DISTINCT t::text order by t::text

Re: [BUGS] page corruption after moving tablespace

2010-07-23 Thread Jeff Davis
On Thu, 2010-07-22 at 23:50 -0700, Jeff Davis wrote: > I think the simple fix would be to have copy_relation_data call > PageInit() if it's a new page. On second thought, why are PageSetLSN and PageSetTLI being called from log_newpage(), anyway? It says that all of the callers use smgr directly, r

Re: [BUGS] BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)

2010-07-23 Thread Daniel Grace
On Fri, Jul 23, 2010 at 10:42 AM, Alex Hunsaker wrote: > On Fri, Jul 16, 2010 at 18:04, Daniel Grace wrote: >> However, in some circumstances Postgres will fail > > How exactly? > > Maybe its so obvious I missed it? > Please see BUG #5564 -- I accidentally submitted this one before I was finishe

Re: [BUGS] BUG #5563: Odd behavior with aggregate_func(DISTINCT foo ORDER BY foo)

2010-07-23 Thread Alex Hunsaker
On Fri, Jul 23, 2010 at 12:19, Daniel Grace wrote: > Please see BUG #5564 -- I accidentally submitted this one before I was > finished typing the details. Ahh, sorry for the noise. I was just trolling for bug reports that had no replys yet :-) -- Sent via pgsql-bugs mailing list (pgsql-bugs@po

[BUGS] installing Postgres 9.0 beta 3 fails on windows 2003 32bit

2010-07-23 Thread Kasia Tuszynska
Hi, I am testing Postgres 9.0: I installed it on: - Win2008 64bit ( the 64bit version) - no problems -Win2003 32bit ( the 32bit version) - no problem on one machine, problem on another machine of the same configuration On the problem machine: Error: Problem running post-install step. Installation

Re: [BUGS] pg_upgrade issues

2010-07-23 Thread Bruce Momjian
depst...@alliedtesting.com wrote: > I have encountered another problem with pg_upgrade, while migrating > from 8.4 to 9.0 (beta2, as well as beta3) on Windows XP Pro. Wow, your testing of pg_upgrade has been excellent! I hope you can continue and test other areas of our system too. I am actually