[BUGS] BUG #5891: Unique index is not unique

2011-02-17 Thread Alexander V. Chernikov
The following bug has been logged online: Bug reference: 5891 Logged by: Alexander V. Chernikov Email address: melif...@ipfw.ru PostgreSQL version: 8.4.5 Operating system: FreeBSD 7.3 Description:Unique index is not unique Details: Just in case if formatting is lost

[BUGS] BUG #5892: Restart Failed after WAL restore

2011-02-17 Thread Harsh Sinha
The following bug has been logged online: Bug reference: 5892 Logged by: Harsh Sinha Email address: harsh.si...@hp.com PostgreSQL version: 8.3.7 Operating system: Windows Description:Restart Failed after WAL restore Details: Hi, We have implemented Continuous Archiv

Re: [BUGS] timestamp issue

2011-02-17 Thread Tom Lane
Heikki Linnakangas writes: > On 17.02.2011 08:06, Sachin Srivastava wrote: >> postgres=# SELECT now() - '7 days' AS week_behind; >> ERROR: invalid input syntax for type timestamp with time zone: "7 days" >> Now, if '+' operator works with '7 days', why dint the '-' operator? Is >> this intentio

Re: [BUGS] BUG #5679: pgAdminIII 1.12.0 hangs

2011-02-17 Thread gunziptarball
I too am experiencing this problem, which has only appeared today. I have been running queries against million-record sized tables...so it was using probably a bunch of memory. My entire computer froze mid-work as I was typing in a query (not running it), and I had to hard-reboot...now i can't r