Re: [BUGS] BUG #4661: Installation

2009-02-16 Thread Craig Ringer
Thomas Waelde wrote: > checking test program... failed > configure: error: > Could not execute a simple test program. This may be a problem > related to locating shared libraries. Check the file 'config.log' > for the exact reason. This is unlikely to be a bug in Pg - it's known to compile and

Re: [BUGS] BUG #4660: float functions return -0

2009-02-16 Thread Tom Lane
"ITAGAKI Takahiro" writes: > We avoid -0 in float8um (unary minus), I wonder why we do that. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4657: mod() makes a mistake in calculation in v8.3

2009-02-16 Thread Tom Lane
"Fujii Masao" writes: > Why don't we backport this? > http://archives.postgresql.org/pgsql-committers/2008-04/msg00030.php See the thread in which it was decided not to apply that to 8.3. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)

Re: [BUGS] BUG #4658: copy problem

2009-02-16 Thread Euler Taveira de Oliveira
Brundle Fly escreveu: > This is ok in ubuntu, but in centos doesnt work?. > COPY query TO is only available in >= 8.2. Are you sure CentOS is using a 8.3 version too? If so, what is the error message? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing

[BUGS] BUG #4662: make failed using MinGW under WinXP

2009-02-16 Thread Pavel Golub
The following bug has been logged online: Bug reference: 4662 Logged by: Pavel Golub Email address: pavel.go...@gf.microolap.com PostgreSQL version: 8.4 Operating system: Windows XP SP3 Description:make failed using MinGW under WinXP Details: $ make We got an error

[BUGS] BUG #4661: Installation

2009-02-16 Thread Thomas Waelde
The following bug has been logged online: Bug reference: 4661 Logged by: Thomas Waelde Email address: tho...@waelde.de PostgreSQL version: 8.3.5 Operating system: Linux (Ubuntu 8.10) Description:Installation Details: Configring the installation as ./configure --pref

[BUGS] BUG #4660: float functions return -0

2009-02-16 Thread ITAGAKI Takahiro
The following bug has been logged online: Bug reference: 4660 Logged by: ITAGAKI Takahiro Email address: itagaki.takah...@oss.ntt.co.jp PostgreSQL version: 8.3.3 Operating system: Fedora 8 Description:float functions return -0 Details: Float8 versions of trunc(), ce

Re: [BUGS] BUG #4656: Indexes not used when comparing nextval() and currval() to integers

2009-02-16 Thread toruvinn
On Mon, 16 Feb 2009 10:37:27 +0100, Heikki Linnakangas wrote: You can read the value returned by currval into a host language variable and send it back as a ?. Wouldn't it be possible to do UPDATE booking_entries SET date = ? where id = (SELECT currval('booking_entries_id_seq'::regclass)); t

[BUGS] BUG #4659: Can't configure static postgresql with static openssl

2009-02-16 Thread Tomasz Kolaj
The following bug has been logged online: Bug reference: 4659 Logged by: Tomasz Kolaj Email address: m...@abp.pl PostgreSQL version: 8.3.6 Operating system: Windows XP (SP2) on Mingw32 Description:Can't configure static postgresql with static openssl Details: I want

Re: [BUGS] BUG #4656: Indexes not used when comparing nextval() and currval() to integers

2009-02-16 Thread Heikki Linnakangas
toruvinn wrote: On Mon, 16 Feb 2009 10:37:27 +0100, Heikki Linnakangas wrote: You can read the value returned by currval into a host language variable and send it back as a ?. Wouldn't it be possible to do UPDATE booking_entries SET date = ? where id = (SELECT currval('booking_entries_id_seq':

[BUGS] BUG #4658: copy problem

2009-02-16 Thread Brundle Fly
The following bug has been logged online: Bug reference: 4658 Logged by: Brundle Fly Email address: mindqua...@gmail.com PostgreSQL version: 8.3 Operating system: Linux Description:copy problem Details: bdsimple=# copy (select * from customer where customer_id>10) t

Re: [BUGS] BUG #4656: Indexes not used when comparing nextval() and currval() to integers

2009-02-16 Thread Heikki Linnakangas
Mathias Seiler wrote: I'm not sure if I'm doing something terribly wrong here, but I when I noticed a slowdown during a large transaction I dig into the problem and found that when I use this prepared statement: UPDATE booking_entries SET date = ? where id = currval('booking_entries_id_seq'::reg

[BUGS] BUG #4656: Indexes not used when comparing nextval() and currval() to integers

2009-02-16 Thread Mathias Seiler
The following bug has been logged online: Bug reference: 4656 Logged by: Mathias Seiler Email address: mathias.sei...@gmail.com PostgreSQL version: 8.3.6 Operating system: Debian Linux Lenny (testing) Description:Indexes not used when comparing nextval() and currval()

Re: [BUGS] Lost search_path after transaction fails

2009-02-16 Thread David Newall
Heikki Linnakangas wrote: > ecpg implicitly runs everything inside transactions. You don't need to > run START TRANSACTION, that's implicit. Therefore the "set > search_path" command is in fact run in the same transaction as the > failing insert, as also hinted by the warning "there is already a >