[BUGS] BUG #2610: Installation error

2006-09-10 Thread Petrutiu Radu Calin
The following bug has been logged online: Bug reference: 2610 Logged by: Petrutiu Radu Calin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Xp Embedded Description:Installation error Details: I have a Windows Xp Embedded just for

[BUGS] BUG #2611: 2 instalation probs: invalid directory and user account creation

2006-09-10 Thread Paul Suckling
The following bug has been logged online: Bug reference: 2611 Logged by: Paul Suckling Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4-1 Operating system: Windows XP Description:2 instalation probs: invalid directory and user account creation Details: I u

[BUGS] BUG #2612: Strange behavior of incremented_by

2006-09-10 Thread Sven Kirsten
The following bug has been logged online: Bug reference: 2612 Logged by: Sven Kirsten Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: SusSE 9.1 and Debian 3.1 Description:Strange behavior of incremented_by Details: Hello, I have created

[BUGS] bitmap index scan problem?

2006-09-10 Thread stig erikson
hi we have a table with some 30M records. running PG8.1.4. on linux. when we run with enable_bitmapscan true, PG begins by doing a bitmap index scan plus a BitmapAnd. when we run with enable_bitmapscan false, PG finds a better index directly and chooses a much better plan. below is some data

[BUGS] Strange behavior of incremented_by

2006-09-10 Thread skirsten
Hello, I have created a table with a serial value. There is a rule watching to that table and reporting changes to a another table. If I make a insert to the table the serial value is incremented by the double value of the incremented_by value form the _id_seq sequence table. Environment: SELECT

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Chris Browne
[EMAIL PROTECTED] ("Michael Hoffmann") writes: > The following bug has been logged online: > > Bug reference: 2608 > Logged by: Michael Hoffmann > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.2 > Operating system: AIX 5.3 > Description:dblink compile fails

Re: [BUGS] bitmap index scan problem?

2006-09-10 Thread Tom Lane
stig erikson <[EMAIL PROTECTED]> writes: > the question is simply why the planner is not smart enough to skip the bitmap > scan if normal operation is faster. Probably because it hasn't got good statistics about the distribution of "bid": > -> Bitmap Index Scan on bid_index (co

Re: [BUGS] BUG #2611: 2 instalation probs: invalid directory and user account creation

2006-09-10 Thread Magnus Hagander
> Problem 1) > > During installation I chose to install the software to > > C:\PostgreSQL\8.1\ > > I have ActivePerl installed (5.8.7), and at the "Enable > procedural languages" step I selected both "PL/pgsql" and "PL/perl". > > I got to the installing step, and everything was progressing >

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] ("Michael Hoffmann") wrote: > The following bug has been logged online: > > Bug reference: 2608 > Logged by: Michael Hoffmann > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.2 > Operating system: AIX 5.3 > Description

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Tom Lane
Christopher Browne <[EMAIL PROTECTED]> writes: > +SHLIB_LINK += $(filter -lssl -lcrypto -lssleay32 -leay32, $(LIBS)) Done, but it's really pretty ugly. I am thinking it'd make more sense for Makefile.global to define a macro for the libraries libpq depends on ... regards,

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Tom Lane
I wrote: > Done, but it's really pretty ugly. I am thinking it'd make more sense > for Makefile.global to define a macro for the libraries libpq depends > on ... I went ahead and did this as per discussion here: http://archives.postgresql.org/pgsql-bugs/2006-08/msg00200.php Please see if I manag

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Tom Lane): > I wrote: >> Done, but it's really pretty ugly. I am thinking it'd make more sense >> for Makefile.global to define a macro for the libraries libpq depends >> on ... > > I went ahead and did this as per discussion here: > http://archives.postgresql.org/pgsql-bu