Re: [BUGS] BUG #2649: wish: provide multi-row INSERT with VALUES

2006-09-25 Thread Harald Armin Massa
Maciej,this feature is scheduled for PostgreSQL 8.2 and allready in the release notes of that release, coming most likely eoty.HaraldOn 9/24/06, Maciej Pilichowski <[EMAIL PROTECTED]> wrote: The following bug has been logged online:Bug reference:  2649Logged by:  Maciej PilichowskiEmai

Re: [BUGS] BUG #2648: I can not create table name with capital and small characters

2006-09-25 Thread Harald Armin Massa
Asaf,this is not a bug. To use identifier names (identfiers = column-names, table-names, view-names...) with capital and small characters, you need to doublequote those names.So you can do select "Asaf" from "Avraham" but not select Asaf from Avraham. This behaviour is documented and intended.Best

Re: [BUGS] BUG #2644: pgadmin III foreign key

2006-09-25 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Massimiliano Citterio > Sent: 22 September 2006 09:21 > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #2644: pgadmin III foreign key > > > The following bug has been logged online: > > Bu

Re: [BUGS] BUG #2648: I can not create table name with capital and small characters

2006-09-25 Thread Harald Armin Massa
Asaf,SQL-92 states that identifiers [for dictionary objects] are limited to 128 characters and are case-insensitive (unless delimited by double quotes), because they are automatically translated into uppercase by the system.Standards are SQL-92, SQL-99 and SQL-2003, done by ISO and other standardiz

Re: [BUGS] Out of memory error during large hashagg

2006-09-25 Thread Casey Duncan
On Sep 24, 2006, at 8:59 AM, Tom Lane wrote: Casey Duncan <[EMAIL PROTECTED]> writes: seed | st_id | 164656 I ran analyze after this, but the results were roughly the same. What's the statistics target set to, and did you try increasing it? Can we see the rest of the pg_sta

Re: [BUGS] Out of memory error during large hashagg

2006-09-25 Thread Tom Lane
Casey Duncan <[EMAIL PROTECTED]> writes: > I haven't tried increasing the stats target. What would be a suitable > value to try? Try 100 (instead of the default 10) ... you can go as high as 1000, though hopefully that's overkill. regards, tom lane -

[BUGS] BUG #2651: 8.2 - beta 1 does now compile with Sun Studio 11

2006-09-25 Thread Remy Beaumont
The following bug has been logged online: Bug reference: 2651 Logged by: Remy Beaumont Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 - beta 1 Operating system: Solaris 10 on T2000 Description:8.2 - beta 1 does now compile with Sun Studio 11 Details: When

[BUGS] Alertbox: 6 Ways to Fix a Confused Information Architecture

2006-09-25 Thread Jakob Nielsen
Jakob Nielsen's Alertbox for September 25 is now online at: > http://www.useit.com/alertbox/ia.html Summary: When your website's users consistently go to the wrong sections, you have many options for getting users back on track, from better labels to clearer structure. -

Re: [BUGS] BUG #2651: 8.2 - beta 1 does now compile with Sun Studio 11

2006-09-25 Thread Tom Lane
"Remy Beaumont" <[EMAIL PROTECTED]> writes: > When we try to compile 8.2 - beta 1 on a T2000 wth Sun Studio 11, the build > fails at the following file: > make[5]: Entering directory > `/usr/home/remy/postgresql-8.2beta1/src/backend/utils/adt' > /opt/SUNWspro/bin/cc -Xa -xtarget=ultraT1 -fast -I.