Re: [BUGS] BUG #2420: NetBSD doesn't need float8-small-is-zero regression

2006-05-05 Thread Kris Jurka
Bruce Momjian wrote: Thanks for the feedback. Patch attached, so NetBSD >= 3.0 will not use float8-small-is-zero. The buildfarm seems to think this is a bad idea. http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=gazelle&dt=2006-05-05%2016:30:00 Kris Jurka ---(end of

Re: [BUGS] BUG #2420: NetBSD doesn't need float8-small-is-zero regression

2006-05-05 Thread Bruce Momjian
Thanks for the feedback. Patch attached, so NetBSD >= 3.0 will not use float8-small-is-zero. I assume m68k is also fixed. If not, we will hear about it. Applied to CVS HEAD and 8.1.X. --- Simon Burge wrote: > > The fo

Re: [BUGS] Insert failure on serial

2006-05-05 Thread Alvaro Herrera
Warren Seltzer wrote: > PostgreSQL 8.1.3 on i686-pc-mingw32 > Windows XP SP2 > > Summary of Insert failure (There IS NO DUPLICATE KEY): > depot_development=# INSERT INTO line_items ("order_id", "product_id", > "quantity", > "unit_price") VALUES(1, 2, 2, 989.99); > ERROR: duplicate key violates

[BUGS] Insert failure on serial

2006-05-05 Thread Warren Seltzer
Title: Message PostgreSQL 8.1.3 on i686-pc-mingw32 Windows XP SP2   Summary of Insert failure (There IS NO DUPLICATE KEY): depot_development=# INSERT INTO line_items ("order_id", "product_id", "quantity", "unit_price") VALUES(1, 2, 2, 989.99);ERROR:  duplicate key violates unique constraint

[BUGS] BUG #2420: NetBSD doesn't need float8-small-is-zero regression test resultmap entry

2006-05-05 Thread Simon Burge
The following bug has been logged online: Bug reference: 2420 Logged by: Simon Burge Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: NetBSD 3.0/i386 Description:NetBSD doesn't need float8-small-is-zero regression test resultmap entry Detai

[BUGS] ERROR: out of memory, running aggregate query

2006-05-05 Thread Casey Duncan
I have the following query which ran fine on 7.4 and fails consistently now that I've upgraded to 8.1.3. Here is the query and the plan (I can't explain analyze because of the memory error): prod=> explain select count(*) from prod-> (select st_id from sd prod(>group by st_id having cou

[BUGS] question on PostgreSQL\8.0\pgAdmin III

2006-05-05 Thread Tang, Guo
HI, I am having a question on using your backup tool pg_dump.exe. to automate the backup, but everytime it will prompt up with password. but no matter how, I could not overcome. is there any way to use this tool without having that password prompt. I tried to put into perl. but perl does n

[BUGS] ERROR: out of memory, running insert/select

2006-05-05 Thread Casey Duncan
Here's another memory error I can reliably reproduce on postgres 8.1.3. This is on a different server, but with the same postgresql config as my previous report. It was running a script to upgrade a snapshot of a production database to the latest schema version for testing. Eventually we wi

[BUGS] Front-end Oracle Forms 6i with back-end Postgresql

2006-05-05 Thread Monjoor Khayer
Hello, I am Khayer from Bangladesh. I am trying to build an application regarding Front-end Oracle Forms 6i with Postgresql back-end. But I cannot make List of Value from Form Builder..because the table names or column names not showing. Could you please help in any way. my e-mail: [EMAIL P

[BUGS] BUG #2419: could not reattach to shared memory

2006-05-05 Thread Andy Male
The following bug has been logged online: Bug reference: 2419 Logged by: Andy Male Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows 2003 Server (standard) SP1 Description:could not reattach to shared memory Details: FULL ERROR IN WI

[BUGS] BUG #2421: problem in installing postgres at last stage

2006-05-05 Thread Sathiyaseelan
The following bug has been logged online: Bug reference: 2421 Logged by: Sathiyaseelan Email address: [EMAIL PROTECTED] PostgreSQL version: postgresql-8.1 Operating system: windows xp(sp2) Description:problem in installing postgres at last stage Details: Hi, When

[BUGS] BUG #2422: Memory leak from Savepoints when using foreign keys

2006-05-05 Thread Tim Baumgartner
The following bug has been logged online: Bug reference: 2422 Logged by: Tim Baumgartner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: 1. Win2000, 2. Suse 10.0, x86_64-unknown-linux-gnu, compiled by GCC 4.0.2 20050901 (prerelease) Description: