[BUGS] BUG #1748: Unique contraints cannot be added to long text fields

2005-07-02 Thread Greg Steffensen
The following bug has been logged online: Bug reference: 1748 Logged by: Greg Steffensen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.02 Operating system: Gentoo Linux Description:Unique contraints cannot be added to long text fields Details: I'm storing S

Re: [BUGS] BUG #1736: endless loop in PQconnectdb

2005-07-02 Thread Bruce Momjian
Karsten Desler wrote: > * Karsten Desler wrote: > > * Bruce Momjian wrote: > > > Yes, please --- the patch is at: > > > > > > http://archives.postgresql.org/pgsql-patches/2005-06/msg00486.php > > > > Thanks. > > I've applied the patch now, and I'll keep you posted. > > It doesn't seem to have

Re: [BUGS] BUG #1747: PostgreSQL 'hangs' after prolonged usage

2005-07-02 Thread Tom Lane
"Wojciech Sobczuk" <[EMAIL PROTECTED]> writes: > The only thing which helps then is > hard-restarting postgresql - and then it works fine for another 6 days. > Rebooting the machine has no influence on the performance so it seems to be > a postgresql issue. BTW, exactly what do you mean by "hard-

Re: [BUGS] BUG #1747: PostgreSQL 'hangs' after prolonged usage

2005-07-02 Thread Tom Lane
"Wojciech Sobczuk" <[EMAIL PROTECTED]> writes: > Please let me know if you're able to reproduce this bug - you just need to > put postgresql at a very high load for a long time No, otherwise we'd have heard a lot more complaints than yours. You'll need to provide sufficient information to let som

Re: [BUGS] BUG #1747: PostgreSQL 'hangs' after prolonged usage

2005-07-02 Thread Pawel Bernat
On Sat, Jul 02, 2005 at 02:12:42PM +0100, Wojciech Sobczuk wrote: > I have a very busy dual-RAID1 machine, doing tens up to hundreds of queries > per second. After around 6 days of running at that kind of a load > postgresql starts processing queries very very slowly (load jumps to 40 from > 2) wh

[BUGS] BUG #1746: libpq/libpq-fs.h not included in distribution

2005-07-02 Thread Lance Clifner
The following bug has been logged online: Bug reference: 1746 Logged by: Lance Clifner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows Description:libpq/libpq-fs.h not included in distribution Details: I started to implement larg

[BUGS] BUG #1747: PostgreSQL 'hangs' after prolonged usage

2005-07-02 Thread Wojciech Sobczuk
The following bug has been logged online: Bug reference: 1747 Logged by: Wojciech Sobczuk Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: FreeBSD 5.4-RELEASE Description:PostgreSQL 'hangs' after prolonged usage Details: Hello, I have a