[BUGS] ERROR: btree: index item size 3048 exceeds maximum 2717

2000-11-01 Thread Dirk Lutzebaeck
ERROR: btree: index item size 3048 exceeds maximum 2717 This is on 7.0.2 while doing an INSERT. The INSERT aborts and returns this error. It just occurred now for the first time and now everytime. There are several indexes defined on this table. Should I rebuild them all? What is this? Regar

Re: [BUGS] ERROR: btree: index item size 3048 exceeds maximum 2717

2000-11-01 Thread Dirk Lutzebaeck
Dirk Lutzebaeck writes: > ERROR: btree: index item size 3048 exceeds maximum 2717 > > This is on 7.0.2 while doing an INSERT. The INSERT aborts and returns > this error. It just occurred now for the first time and now everytime. > There are several indexes defined on this table. Should I r

[BUGS]

2000-11-01 Thread Vasileiadis Spyros
I use postgres v.7.0 and I access through libzeos v.1.4.4 while testing an application I got the message pq_recvbuf: unexpected EOF on client connection there are two tables involved: create table thtm ( htmid serial primary key, htmname varchar(256) not null, next int4 not null);

[BUGS] RPM install weirdness & BugreportPage Bug

2000-11-01 Thread Thomas Linden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Today I tried to install postgresql 7.0.2 from RedHat-6.x rpm packages. These are the relevant rpm's I found: postgresql-7.0.2-2.i386.rpm postgresql-devel-7.0.2-2.i386.rpm postgresql-perl-7.0.2-2.i386.rpm postgresql-server-7.0.2-2.i386.rpm But u

[BUGS] Backend touches index not involved in update / NULL indexing

2000-11-01 Thread pgsql-bugs
Doug Mitchell ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Backend touches index not involved in update / NULL indexing Long Description I had some updates that were taking a few seconds each on a primary-keyed table with a

[BUGS] performace about your search engine

2000-11-01 Thread pgsql-bugs
P. Ashok Kumar ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description performace about your search engine Long Description You search engine takes long time to give results. Many times It's session is timed out. Sample Code No fi

Re: [BUGS] RPM install weirdness & BugreportPage Bug

2000-11-01 Thread Thomas Lockhart
> I suggest a little bit more investigation and testing before publishing > rpm packages, a rpm package must be installable unless it cannot find a > required package. if this is the case, then this package must be > available. Any other behavior is just a joke. Sorry about that, just my > 0.02$.

Re: [BUGS] Joins on over 10 tables returns unreliable results

2000-11-01 Thread Tom Lane
[EMAIL PROTECTED] writes: > Running Postgres version 7.01 on Redhat linux 6.2. When joining on > more than 10 tables not all of the expected results are returned. Do you get a query plan involving mergejoins for these queries? If so it's probably fixed for 7.0.3, please try that as soon as it's