Re: [BUGS] BUG #5571: global hash %_SHARED is not declared as global in the new version

2010-07-26 Thread Alvaro Herrera
Excerpts from Alex Hunsaker's message of lun jul 26 12:55:34 -0400 2010: > On Mon, Jul 26, 2010 at 03:58, mile wrote: > > To reproduce this use the following function: > > > > create or replace function perl_shared() returns void as $$ > > use strict; > > elog(INFO, $_SHARED{'stuff'}); > > $_SHARE

Re: [BUGS] BUG #5572: Error Trying to connec from Crystal Reports to Sever PostgreSQL

2010-07-26 Thread Kevin Grittner
"Tizziano Perea" wrote: > PostgreSQL version: 8.2.17 > Operating system: CentOS 5.4 > Description:Error Trying to connec from Crystal Reports to > Sever > I,ve been install Crystal Reports 11 in a WinXP machine, and when > i tried to connect to PostgreSQL (CentOS

Re: [BUGS] BUG #5571: global hash %_SHARED is not declared as global in the new version

2010-07-26 Thread Alex Hunsaker
On Mon, Jul 26, 2010 at 03:58, mile wrote: > To reproduce this use the following function: > > create or replace function perl_shared() returns void as $$ > use strict; > elog(INFO, $_SHARED{'stuff'}); > $_SHARED{'stuff'} = '1'; > for my $k (keys %_SHARED) > { >    elog(INFO, $k); > } > $$ languag

Re: [BUGS] page corruption after moving tablespace

2010-07-26 Thread Jeff Davis
On Thu, 2010-07-22 at 23:50 -0700, Jeff Davis wrote: > I was investigating some strange page corruption today in which the page > was completely zeroed except for the LSN and TLI. > I see that this was added to the 9.0 open items list, but it affects versions 8.3 and later. I should have indicat

Re: [BUGS] pg_upgrade issues

2010-07-26 Thread Bruce Momjian
Alvaro Herrera wrote: > Excerpts from depstein's message of lun jul 26 08:05:24 -0400 2010: > > > I just want to note that one reason regclass may be used in user tables (as > > opposed to, say, regtype) is that in PL/pgSQL trigger procedures there is a > > special variable TG_RELID, which provi

[BUGS] BUG #5572: Error Trying to connec from Crystal Reports to Sever PostgreSQL

2010-07-26 Thread Tizziano Perea
The following bug has been logged online: Bug reference: 5572 Logged by: Tizziano Perea Email address: tizzia...@gmail.com PostgreSQL version: 8.2.17 Operating system: CentOS 5.4 Description:Error Trying to connec from Crystal Reports to Sever PostgreSQL Details: Re

Re: [BUGS] pg_upgrade issues

2010-07-26 Thread Alvaro Herrera
Excerpts from depstein's message of lun jul 26 08:05:24 -0400 2010: > I just want to note that one reason regclass may be used in user tables (as > opposed to, say, regtype) is that in PL/pgSQL trigger procedures there is a > special variable TG_RELID, which provides a convenient reference to th

Re: [BUGS] pg_upgrade issues

2010-07-26 Thread Bruce Momjian
Robert Haas wrote: > On Sat, Jul 24, 2010 at 11:37 PM, Bruce Momjian wrote: > >> I am inclined to prevent pg_upgrade from migrating any database that > >> uses any of these reg* data types, and document this restriction. ?I > >> probably could allow regtype because that pg_type is preserved. > > >

[BUGS] BUG #5571: global hash %_SHARED is not declared as global in the new version

2010-07-26 Thread mile
The following bug has been logged online: Bug reference: 5571 Logged by: mile Email address: m...@avangardsolutions.com PostgreSQL version: v9.0beta3 Operating system: Linux Description:global hash %_SHARED is not declared as global in the new version Details: We ar

Re: [BUGS] pg_upgrade issues

2010-07-26 Thread Robert Haas
On Sat, Jul 24, 2010 at 11:37 PM, Bruce Momjian wrote: >> I am inclined to prevent pg_upgrade from migrating any database that >> uses any of these reg* data types, and document this restriction.  I >> probably could allow regtype because that pg_type is preserved. > > I have applied the attached

Re: [BUGS] pg_upgrade issues

2010-07-26 Thread Bruce Momjian
depst...@alliedtesting.com wrote: > > Bruce Momjian wrote: > > > depst...@alliedtesting.com wrote: > > > > I am trying to obtain a binary dump of a small test database where > > > > this issue could be reproduced, but so far, no luck. At present, > > the > > > > least such database is 1.5 GB compre

Re: [BUGS] pg_upgrade issues

2010-07-26 Thread depstein
> Bruce Momjian wrote: > > depst...@alliedtesting.com wrote: > > > I am trying to obtain a binary dump of a small test database where > > > this issue could be reproduced, but so far, no luck. At present, > the > > > least such database is 1.5 GB compressed and contains a lot of > > > proprietary i