Re: [BUGS] libber library not found on RC1

2011-12-23 Thread stuartb81
I had this issue after installing 9.1 on Ubuntu 10.10. When i tried running pg_dump I'd get this error: "error while loading shared libraries: liblber-2.3.so.0: cannot open shared object file: No such file or directory" I got round this issue by copying a newer version of liblber and naming it l

Re: [BUGS] BUG #6351: ERROR: btree index keys must be ordered by attribute

2011-12-23 Thread Christian Rudolph
> But now that we allow it it'd be nice if it actually worked :-(. > Looking into the archives I see that we were mainly thinking about > the possibility of exclusion constraints naming the same column > more than once, which may explain why nobody tried using such an > index for queries. I'll see

Re: [BUGS] BUG #5578: postrgesql database crash

2011-12-23 Thread Robert Haas
On Thu, Dec 15, 2011 at 10:48 AM, pratikchirania wrote: > We have a similar issue with postgres 9.0.1 > Any ideas? > > I dint see any updates in the 9.1 release notes.. Has this issue been > addressed? I don't think we have enough information to address the issue here. Can you provide any more de

Re: [BUGS] BUG #6341: Packaging - virtual provides "postgres" without version

2011-12-23 Thread Robert Haas
On Thu, Dec 15, 2011 at 11:27 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6341 > Logged by:          Nelson Marques > Email address:      nelson-m-marq...@ext.ptinovacao.pt > PostgreSQL version: 8.4.10 > Operating system:   Red Hat Enterprise Linux 5 > D

Re: [BUGS] user names & non-ASCII

2011-12-23 Thread Robert Haas
On Thu, Dec 15, 2011 at 3:40 PM, Holec, JPH Software wrote: > I Have PostgreSQL server 8.4.9 on Linux, database utf-8 and Client app on > Windows (VC++ and libpq.dll). > I need to use user account with non-ASCII and PQconnectdb() with > options="client_encoding=WIN1250" doesn't work. I think you

Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-23 Thread Robert Haas
On Fri, Dec 16, 2011 at 3:43 AM, Hans-Henrik Fuxelius wrote: > It seems not possible to suppress to_timestamp from doing daylight > saving conversion, I have GPS timeseries that looks perfect in the > 'timestamp without time zone' save one value that wreck the whole time > serie, does that mean th

Re: [BUGS] BUG #6341: Packaging - virtual provides "postgres" without version

2011-12-23 Thread Tom Lane
Robert Haas writes: > On Thu, Dec 15, 2011 at 11:27 AM, wrote: >> Currently your binary distribution of PostgreSQL for Enterprise Linux has a >> virtual provides for 'postgresql' which has no version associated with it >> (there's good and bad things depending on usage regarding this >> methodol

Re: [BUGS] user names & non-ASCII

2011-12-23 Thread Heikki Linnakangas
On 23.12.2011 19:21, Robert Haas wrote: On Thu, Dec 15, 2011 at 3:40 PM, Holec, JPH Software wrote: I Have PostgreSQL server 8.4.9 on Linux, database utf-8 and Client app on Windows (VC++ and libpq.dll). I need to use user account with non-ASCII and PQconnectdb() with options="client_encoding=W