Re: [BUGS] Oder by not working

2008-08-07 Thread Heikki Linnakangas
Heikki Linnakangas wrote: Unlike on some systems, in PostgreSQL "ORDER BY 1" means order by the constant value "1", not the first column. Try "ORDER BY name". Oh, that's of course not correct at all. "ORDER BY 1" does indeed mean order by first column. I don't know what I was thinking, --

[BUGS] BUG #4344: initdb -L timezone directory

2008-08-07 Thread Domingo Alvarez Duarte
The following bug has been logged online: Bug reference: 4344 Logged by: Domingo Alvarez Duarte Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: windows Description:initdb -L timezone directory Details: When specifing a non default locati

[BUGS] BUG #4345: ERROR: OUT OF MEMORY

2008-08-07 Thread Glaucio Pedro
The following bug has been logged online: Bug reference: 4345 Logged by: Glaucio Pedro Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Linux Description:ERROR: OUT OF MEMORY Details: Dear Fellow, I have been trying to restore a file throu

[BUGS] Re: BUG #4343: upper, lower, initcap do not work with umlaute? (important!)

2008-08-07 Thread valgog
On Aug 6, 5:06 pm, [EMAIL PROTECTED] ("paull") wrote: > The following bug has been logged online: > > Bug reference:      4343 > Logged by:          paull > Email address:     [EMAIL PROTECTED] > PostgreSQL version: 8.2? not sure > Operating system:   ubuntu > Description:        upper, lower, init

Re: [BUGS] BUG #4342: upper, lower, initcap do not work with umlaute?

2008-08-07 Thread valgog
On Aug 6, 4:48 pm, [EMAIL PROTECTED] ("paull") wrote: > The following bug has been logged online: > > Bug reference:      4342 > Logged by:          paull > Email address:     [EMAIL PROTECTED] > PostgreSQL version: 8.2? not sure > Operating system:   ubuntu > Description:        upper, lower, init

Re: [BUGS] Oder by not working

2008-08-07 Thread Blanco, Jose
So is there no way to make oder by work with names? -Original Message- From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2008 3:00 AM To: Blanco, Jose Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] Oder by not working Heikki Linnakangas wrote: > Unlike on

Re: [BUGS] BUG #4345: ERROR: OUT OF MEMORY

2008-08-07 Thread Tom Lane
"Glaucio Pedro" <[EMAIL PROTECTED]> writes: > I have been trying to restore a file through the pgAdmin (Version:1.8.2)and > the following message has been exhibited (although the metioned file´s size > is roughly 20kb): > "pg_restore [arquive] out of memory" 8.2.what? If it's pre-8.2.5, I'd ven

Re: [BUGS] BUG #4344: initdb -L timezone directory

2008-08-07 Thread Tom Lane
"Domingo Alvarez Duarte" <[EMAIL PROTECTED]> writes: > I expected initdb to use "-L" value to timezone too and for all other files > that is expected to be on share directory. -L only affects where initdb looks for its own input files; it has nothing to do with where the backend looks for the PGSH

[BUGS] Postgres Vacuum Password

2008-08-07 Thread Chris Schroter
Hi, Would you please tell me if there is a default password for the Postgres vacuum utility? Thank you, Chris Schroter -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Postgres Vacuum Password

2008-08-07 Thread John R Pierce
Chris Schroter wrote: Hi, Would you please tell me if there is a default password for the Postgres vacuum utility? there are no passwords for any programs, passwords are users to connect to databases, IF the appropriate line in pg_hba.conf specifies to use passwords. there are also no

Re: [BUGS] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-07 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > Gregory Stark <[EMAIL PROTECTED]> writes: >> "Tom Lane" <[EMAIL PROTECTED]> writes: >>> ... I'm not even sure how to fix it (the nasty case is >>> changing directions partway through the scan); let alone how to fix it in a >>> way that's obviously enough r

Re: [BUGS] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-07 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> Well, if you think it's easy, the best form of criticism is a patch. >> The change-of-direction problem seems to me to be messy --- not >> insoluble, but messy enough to need beta testing. > Hm, I must have misun

Re: [BUGS] Hmm, nodeUnique doesn't really support backwards scan too well

2008-08-07 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > Gregory Stark <[EMAIL PROTECTED]> writes: >> "Tom Lane" <[EMAIL PROTECTED]> writes: >>> Well, if you think it's easy, the best form of criticism is a patch. >>> The change-of-direction problem seems to me to be messy --- not >>> insoluble, but messy enough

Re: [BUGS] Oder by not working

2008-08-07 Thread Heikki Linnakangas
As Tom pointed out, the order depends on the locale. Blanco, Jose wrote: So is there no way to make oder by work with names? -Original Message- From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2008 3:00 AM To: Blanco, Jose Cc: pgsql-bugs@postgresql.org Su