Re: [BUGS] BUG #3948: date/time functions returning wrong value

2008-02-11 Thread Magnus Hagander
Jorge Campins wrote: Dear All, I installed 8.2.6.2 and solved my problem. I set Windows time zone to "Caracas" and PostgreSQL "America/Caracas" and now they both give me the right time. WARNING: not only people in Venezuela but also people in Bolivia is affected by this problem. As you migh

Re: [BUGS] Vers. 8.3.0: "make check" fails dismally

2008-02-11 Thread imacat
On Wed, 06 Feb 2008 11:26:16 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Am Mittwoch, 6. Februar 2008 schrieb Mike Dowling: > >> Naively checking the build using "make check" (yes, gnu make, and as an > >> unprivaleged user) fails all tests. The app

Re: [BUGS] BUG #3948: date/time functions returning wrong value

2008-02-11 Thread Jorge Campins
Dear All, I installed 8.2.6.2 and solved my problem. I set Windows time zone to "Caracas" and PostgreSQL "America/Caracas" and now they both give me the right time. WARNING: not only people in Venezuela but also people in Bolivia is affected by this problem. As you might recall, Windows used

Re: [BUGS] BUG #3947: Unable to Initialize Data Cluster

2008-02-11 Thread Dave Page
On Feb 11, 2008 4:16 PM, Fusion Software (UK) Ltd <[EMAIL PROTECTED]> wrote: > > > OK this might be something. If I look at the Application event history it > has "Waiting for server startup", then "FATAL: unrecognized configuration > parameter "redirect_stderr" and finally "Timed out waiting for

Re: [BUGS] Adding new columns - bug

2008-02-11 Thread Gregory Stark
"Michael Andreasen" <[EMAIL PROTECTED]> writes: > There is nothing sepcial about the product table other than it has a couple > of trigger rules to post to other tables on updates of some fields (audit > log), nothing to cause this behavior. I have only noticed this happening of > this table, so I

Re: [BUGS] BUG #3947: Unable to Initialize Data Cluster

2008-02-11 Thread Dave Page
On Feb 11, 2008 3:11 PM, Fusion Software (UK) Ltd <[EMAIL PROTECTED]> wrote: > > > Glad you're on the case. Please keep me posted as we have a number of > installations coming up in the next couple of months and we'd much rather > use 8.3 if at all possible. Can you check one thing for me please

Re: [BUGS] BUG #3947: Unable to Initialize Data Cluster

2008-02-11 Thread Dave Page
On Feb 10, 2008 7:45 PM, Fusion Software (UK) Ltd <[EMAIL PROTECTED]> wrote: > > > If it would help I can always invite you to onto the desktop so you can see > for yourself what is happening? Not sure how to do that but I've seen the > facility for remote assistance on Vista. Alternatively you c

[BUGS] Postgres para Windows Vista

2008-02-11 Thread Fabián David Gutiérrez Rojas
Hola soy un estudiante de Ingeniería de sistemas y quisiera saber si ustedes tienen un parche de postgres para Windows Vista ya que el programa no se deja instalar en mi computador. Atentamente, FABIAN DAVID GUTIERREZ _ Invite

Re: [BUGS] Adding new columns - bug

2008-02-11 Thread Michael Andreasen
This happens in 6.1 and 6.2, not able to test 6.3 yet. Sorry typo... should be 8.x ofcourse. On 11/02/2008, Michael Andreasen <[EMAIL PROTECTED]> wrote: > > I have a found a bug when adding a new column to an existing table. This > happens in 6.1 and 6.2, not able to test 6.3 yet. > > This is

[BUGS] Adding new columns - bug

2008-02-11 Thread Michael Andreasen
I have a found a bug when adding a new column to an existing table. This happens in 6.1 and 6.2, not able to test 6.3 yet. This is the process I am doing; alter table product add column search_priority int default 0; update product set search_priority = 0; search_priority,count(*) from product g

Re: [BUGS] BUG #3948: date/time functions returning wrong value

2008-02-11 Thread Magnus Hagander
On Sun, Feb 10, 2008 at 11:22:53PM -0300, Alvaro Herrera wrote: > Magnus Hagander wrote: > > Tom Lane wrote: > > >> This does suggest that we'll need to revisit the win32_tzmap[] list > >> every so often? > > > > Seems so. It's the first time I've heard of a timezone being *added* and > > not ju

Re: [BUGS] BUG #3948: date/time functions returning wrong value

2008-02-11 Thread Magnus Hagander
On Sun, Feb 10, 2008 at 09:33:46PM -0500, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > I think what I conclude from this is that Windows TZ database is so > > bogus that we should avoid trying to rely on it -- I say if the user > > does not set "timezone" in postgresql.conf, ref