[BUGS] BUG #7619: Query cost estimate appears to not use n_distinct setting

2012-10-23 Thread niko . kiirala
The following bug has been logged on the website: Bug reference: 7619 Logged by: Niko Kiirala Email address: niko.kiir...@mapvision.fi PostgreSQL version: 9.2.1 Operating system: Windows 7 SP 1 (64-bit) Description: I am working on a potentially large database table,

Re: [BUGS] BUG #7619: Query cost estimate appears to not use n_distinct setting

2012-10-23 Thread Craig Ringer
On 10/23/2012 06:46 PM, niko.kiir...@mapvision.fi wrote: > The following bug has been logged on the website: > > Bug reference: 7619 > Logged by: Niko Kiirala > Email address: niko.kiir...@mapvision.fi > PostgreSQL version: 9.2.1 > Operating system: Windows 7 SP 1 (64-bit) > D

[BUGS] Posrgresql for Suse linux 64-bit version on OS/390

2012-10-23 Thread Sree Krishna Priya Kuppa
Hi Team, Required a copy of PostgreSQL to install on z/linux i.e Suse Linux 64-bit on OS/390. Please suggest where to get the setup file. -- Sri Krishna Priya Kuppa Assistant Systems Engineer- Trainee IBM Center of Excellence (System Z), Corporate TEG Tata Consultancy Services Ph:- +91 44 67422

Re: [BUGS] BUG #7619: Query cost estimate appears to not use n_distinct setting

2012-10-23 Thread Tom Lane
niko.kiir...@mapvision.fi writes: > I am working on a potentially large database table, let's call it > "observation", that has a foreign key to table "measurement". Each > measurement is associated with either none or around five observations. In > this kind of situation, it is well known that the

Re: [BUGS] Posrgresql for Suse linux 64-bit version on OS/390

2012-10-23 Thread John R Pierce
On 10/23/12 4:26 AM, Sree Krishna Priya Kuppa wrote: Hi Team, Required a copy of PostgreSQL to install on z/linux i.e Suse Linux 64-bit on OS/390. Please suggest where to get the setup file. if suse doesn't provide that, you'll likely need to compile your own. -- john r pierce

[BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-23 Thread ghazel
The following bug has been logged on the website: Bug reference: 7620 Logged by: Greg Hazel Email address: gha...@gmail.com PostgreSQL version: 9.2.1 Operating system: Amazon Linux Description: array_to_json(ARRAY['foo', 100, true]) complains because arrays can't have

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-23 Thread Merlin Moncure
On Tue, Oct 23, 2012 at 6:32 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 7620 > Logged by: Greg Hazel > Email address: gha...@gmail.com > PostgreSQL version: 9.2.1 > Operating system: Amazon Linux > Description: > > array_to_json(ARRAY['f

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-23 Thread Merlin Moncure
On Tue, Oct 23, 2012 at 8:05 PM, Greg Hazel wrote: > On Oct 23, 2012, at 6:03 PM, Merlin Moncure wrote: > >> On Tue, Oct 23, 2012 at 6:32 PM, wrote: >>> The following bug has been logged on the website: >>> >>> Bug reference: 7620 >>> Logged by: Greg Hazel >>> Email address:

Re: [BUGS] Posrgresql for Suse linux 64-bit version on OS/390

2012-10-23 Thread Craig Ringer
On 10/23/2012 07:26 PM, Sree Krishna Priya Kuppa wrote: > Hi Team, > Required a copy of PostgreSQL to install on z/linux i.e Suse Linux > 64-bit on OS/390. Please suggest where to get the setup file. This isn't a bug report; consider asking on pgsql-general. See the bug reporting guidelines linked