Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-25 Thread mike
On Mon, 25 Aug 2003, Stephan Szabo wrote: > Date: Mon, 25 Aug 2003 00:43:56 -0700 (PDT) > From: Stephan Szabo <[EMAIL PROTECTED]> > To: mike <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] index not used afer VACUUM ANALYZE > > On Thu, 21 Aug 2003, mike wrote: > > > Hi, > > I hav

[BUGS] can't link the libpq.dll for bcc32.mak

2003-08-25 Thread Ping-Hua Shao
  Dear: I try to compile the libpq library (in 7.3.4 & 7.4 beta1 src folder) with bcc32.mak under bcc55 and bcb6, but have some problems when linked. The problems are about : 1._pqGethostbyname 2._pqStrerror can't referenced.   I think these 2 functions were new, maybe  we have to patch the ma

[BUGS] LOCK.tag( granuarity oflocks)

2003-08-25 Thread Sumaira Maqsood Ali
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set to invalid, if it is a page level lock the blockId is valid, while the tupleId is still invalid. Fi

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-25 Thread Stephan Szabo
On Mon, 25 Aug 2003, mike wrote: > On Mon, 25 Aug 2003, Stephan Szabo wrote: > > > Date: Mon, 25 Aug 2003 00:43:56 -0700 (PDT) > > From: Stephan Szabo <[EMAIL PROTECTED]> > > To: mike <[EMAIL PROTECTED]> > > Cc: [EMAIL PROTECTED] > > Subject: Re: [BUGS] index not used afer VACUUM ANALYZE > > > > O

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-25 Thread Stephan Szabo
On Thu, 21 Aug 2003, mike wrote: > Hi, > I hav a db as specified in nit.sql > flows has 763488 entries. > > After dropping/creating/loading the db and running auswert.sh I get > the attached result from query1.txt. > After 'VACUUM ANALYZE' I get the results from query2.txt > > As you can see, the

Re: [BUGS] problem with libpq/encrypted

2003-08-25 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: >> I believe we have a problem with libpq 7.3.3 with encryption. I >> currently don't have a 7.3.3/ssl system running, but this has been >> reported by Christian Ruediger Bahls, who traced it, and Dave Page. > This problem is happening with libpq 7.4 too