[BUGS] win32 installer page in pgfoundry is wrong

2008-08-27 Thread Alvaro Herrera
Hi, There is an announcement at http://pgfoundry.org/projects/pginstaller/ titled Don't look here for announcements which contains an URL: http://www.postgresql.org/ftp/win32 This URL returns a 404. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQ

Re: [BUGS] BUG #4380: Comparison of OLD and NEW columns in trigger does not always work

2008-08-27 Thread Stephan Szabo
On Wed, 27 Aug 2008, Daryl Joubert wrote: > > The following bug has been logged online: > > Bug reference: 4380 > Logged by: Daryl Joubert > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.3 > Operating system: WinXP SP2 > Description:Comparison of OLD and N

Re: [BUGS] BUG #4381: Postgresql daemon won't stay in the foreground

2008-08-27 Thread Tom Wright
That did it (was set to silent_mode = on by default). Thank you very much. Tom Lane wrote: Tom Wright <[EMAIL PROTECTED]> writes: I'm starting it with "postgres -D ", and it immediately forks into the background Perhaps you have silent_mode set in the configuration file? AFAIK t

Re: [BUGS] BUG #4377: casting result of timeofday() to timestamp fails in some timezones

2008-08-27 Thread Todd A. Cook
Tom Lane wrote: In the meantime, why aren't you just using clock_timestamp()? timeofday() is deprecated. I am using clock_timestamp() now. The use of timeofday() was from the era when 8.0 was hot stuff. BTW, the word "deprecated" does not appear on the docs page where timeofday() is listed (

Re: [BUGS] BUG #4381: Postgresql daemon won't stay in the foreground

2008-08-27 Thread Tom Lane
Tom Wright <[EMAIL PROTECTED]> writes: > I'm starting it with "postgres -D ", and it immediately forks > into the background Perhaps you have silent_mode set in the configuration file? AFAIK the postmaster will never fork away from the caller unless that's been set in one way or another.

Re: [BUGS] BUG #4381: Postgresql daemon won't stay in the foreground

2008-08-27 Thread Tom Wright
I'm starting it with "postgres -D ", and it immediately forks into the background Is there something I can do to trap some debug output for you? Heikki Linnakangas wrote: Tom wrote: I want to run postgres under daemontools, but no matter what I do, postgres will not stay in the foreground

[BUGS] BUG #4382: there is an exagerate increase of execution times putting a 'case' condition in this update

2008-08-27 Thread Gianluca Buttarelli
The following bug has been logged online: Bug reference: 4382 Logged by: Gianluca Buttarelli Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.11 Operating system: linux Description:there is an exagerate increase of execution times putting a 'case' condition i

Re: [BUGS] BUG #4381: Postgresql daemon won't stay in the foreground

2008-08-27 Thread Heikki Linnakangas
Tom wrote: I want to run postgres under daemontools, but no matter what I do, postgres will not stay in the foreground... has anyone else seen this or know how to fix it? How are you starting it then? Just run "postgres -D ", and it will stay in foreground. PS. this is unlikely a bug. Please

[BUGS] BUG #4381: Postgresql daemon won't stay in the foreground

2008-08-27 Thread Tom
The following bug has been logged online: Bug reference: 4381 Logged by: Tom Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: FreeBSD 7.0-RELEASE-p3 Description:Postgresql daemon won't stay in the foreground Details: I want to run postgre

[BUGS] BUG #4380: Comparison of OLD and NEW columns in trigger does not always work

2008-08-27 Thread Daryl Joubert
The following bug has been logged online: Bug reference: 4380 Logged by: Daryl Joubert Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: WinXP SP2 Description:Comparison of OLD and NEW columns in trigger does not always work Details: When

Re: [BUGS] BUG #4379: failt to get system metrics fot terminal services : 87

2008-08-27 Thread Magnus Hagander
andre kallmeyer wrote: > The following bug has been logged online: > > Bug reference: 4379 > Logged by: andre kallmeyer > Email address: [EMAIL PROTECTED] > PostgreSQL version: PostgreSQL 8.0 > Operating system: windows xp > Description:failt to get system metrics fot

[BUGS] BUG #4379: failt to get system metrics fot terminal services : 87

2008-08-27 Thread andre kallmeyer
The following bug has been logged online: Bug reference: 4379 Logged by: andre kallmeyer Email address: [EMAIL PROTECTED] PostgreSQL version: PostgreSQL 8.0 Operating system: windows xp Description:failt to get system metrics fot terminal services : 87 Details: I ca