[BUGS] BUG #6334: initdb not working

2011-12-13 Thread Wilfried . Weiss
The following bug has been logged on the website: Bug reference: 6334 Logged by: Wilfried Weiss Email address: wilfried.we...@nsg.com PostgreSQL version: 9.1.2 Operating system: AIX 5300-12-04-1119 Description: I successfully compiled 9.1.2 using IBM xlc 9.0 and gnu m

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread John Lumby
(Horribly red face) All my fault.    It turns out I had applied a source-code change for some additional dtracing which I had merged forward from an older version but which was incorrect in V9.    After removing that it works fine. Really sorry about that John Lumby

Re: [BUGS] could not truncate directory "pg_subtrans": apparent wraparound

2011-12-13 Thread Robert Haas
On Sun, Dec 4, 2011 at 7:27 AM, MirrorX wrote: > hello to all, > > i found this error in the logs on the hot_standby server. this error > appeared only once a few days back and hasn't come up again. the version i > am using is 9.0.5 and the primary was loaded by restoring dump files > (previous ve

Re: [BUGS] BUG #6317: sequence error for pg_dump

2011-12-13 Thread Robert Haas
On Fri, Dec 2, 2011 at 4:48 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6317 > Logged by:          hua ming fei > Email address:      h...@alkheme.com > PostgreSQL version: 9.0.1 > Operating system:   Centos 5.5 > Description: > > use pg_dump when didn't

Re: [BUGS] BUG #6333: pgAdmin 14.1 - Listbox stupidities

2011-12-13 Thread Guillaume Lelarge
On Tue, 2011-12-13 at 15:17 +, dmigow...@ikoffice.de wrote: > The following bug has been logged on the website: > > Bug reference: 6333 > Logged by: Daniel Migowski > Email address: dmigow...@ikoffice.de > PostgreSQL version: 9.1.2 > Operating system: Windows 7 > Descripti

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread Tom Lane
John Lumby writes: > I do have other databases in my cluster which probably explains the different > datlastsysoid. No, it wouldn't. datlastsysoid only counts objects created during initdb. [ thinks for a bit ] The most likely explanation for the different datlastsysoid value is that the numb

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread John Lumby
Yes,  I'm definitely running 9.1.2 (on the output I sent earlier today). I've also tried again on yet another different system and get the same bug there. I do have other databases in my cluster which probably explains the different datlastsysoid. I am at a loss to explain what could be differ

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread Tom Lane
John Lumby writes: > Is your output different? Do you think you could post the output you get? Mine looks like yours, except no error. [ looks closer... ] Are you sure you're running a 9.1.2 server? The large difference in datlastsysoid seems like it could not have happened if you had product

[BUGS] BUG #6333: pgAdmin 14.1 - Listbox stupidities

2011-12-13 Thread dmigowski
The following bug has been logged on the website: Bug reference: 6333 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 9.1.2 Operating system: Windows 7 Description: I have a user group "ikofficeusers", and a user "ik" in my database

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-13 Thread John Lumby
Well,  thanks for trying it  -  but that is strange.   Yes,  my database is created with datcollate "C"  - the script displays that (see below). The only thing I can think of that might explain different outcome is if,  in your environment, the planner did not choose the index-access plan after