Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Jeremy Drake
On Sun, 1 Oct 2006, Jeremy Drake wrote: > On Mon, 2 Oct 2006, Magnus Hagander wrote: > > > If you do "build solution" it should build all project sin the correct > > order - there are dependency references set between them that should > > take care of this automatically. > > If I do build solution

Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Jeremy Drake
On Mon, 2 Oct 2006, Magnus Hagander wrote: > > This appears to not work out well. If I copy the generated > > files from bison from a linux box, then they are ok, but if I > > try to use ones generated using that version of bison, it > > does not compile. I'll look around for a different one. >

Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Jeremy Drake
On Mon, 2 Oct 2006, Tom Lane wrote: > Jeremy Drake <[EMAIL PROTECTED]> writes: > >> I grabbed flex and bison from GNUwin32 > >> (http://gnuwin32.sourceforge.net/packages/bison.htm) > > > This appears to not work out well. If I copy the generated files from > > bison from a linux box, then they ar

Re: [HACKERS] Win32 hard crash problem

2006-10-01 Thread Magnus Hagander
> IIRC there is no real SIGINT on Windows, so it can only come > from a postgres program. The windows shutdown could be > calling pg_ctl to stop the service, of course. Well, not quite that, but it will send a service command to the running pg_ctl (which is our "service supervisor"), which *will

Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Magnus Hagander
> > > That's on my TODO list to write, but I haven't had the > time yet. The > > > basic is that if you disable everything in the config.pl > file, you > > > can run with almost no external dependencies. You'll need > flex+bison > > > if buliding off CVS. > > > Oh, and it requires Visual C++

Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Tom Lane
Jeremy Drake <[EMAIL PROTECTED]> writes: >> I grabbed flex and bison from GNUwin32 >> (http://gnuwin32.sourceforge.net/packages/bison.htm) > This appears to not work out well. If I copy the generated files from > bison from a linux box, then they are ok, but if I try to use ones > generated using

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-10-01 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > ... place a limit on the number of transactions that can be live in a table > at once. Urk, well maybe, but ... > you could shrink all the visibility info to 1 byte if you > wanted to. ... 256 of 'em is surely not an acceptable limit.

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-10-01 Thread Jim C. Nasby
On Mon, Oct 02, 2006 at 10:52:48AM +0900, ITAGAKI Takahiro wrote: > Tom Lane <[EMAIL PROTECTED]> wrote: > > > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > > Dumb question... wouldn't getting down to 20 bytes buy us something? > > > > BTW, the apparently useless byte after the 27- or 23-byte hea

Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Jeremy Drake
On Sun, 1 Oct 2006, Jeremy Drake wrote: > On Sun, 1 Oct 2006, Magnus Hagander wrote: > > > > I was just trying to build using the src/tools/msvc scripts > > > on windows, and I was wondering if there were any > > > instructions on how to do this, what prerequisites there are, > > > where to get th

Re: [HACKERS] Select for update with outer join broken?

2006-10-01 Thread Tom Lane
Josh Berkus writes: >> But did it ever work against a release? The backend's test code for >> this was busted for awhile during 8.2devel. > No, because SQL-standard correct SELECT FOR UPDATE outer join is an 8.2 > feature. We didn't have it in 8.1. Josh, you don't know what you're talking abo

Re: [HACKERS] Select for update with outer join broken?

2006-10-01 Thread Josh Berkus
Tom, > But did it ever work against a release? The backend's test code for > this was busted for awhile during 8.2devel. No, because SQL-standard correct SELECT FOR UPDATE outer join is an 8.2 feature. We didn't have it in 8.1. -- Josh Berkus PostgreSQL @ Sun San Francisco -

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-10-01 Thread ITAGAKI Takahiro
Tom Lane <[EMAIL PROTECTED]> wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > Dumb question... wouldn't getting down to 20 bytes buy us something? > > BTW, the apparently useless byte after the 27- or 23-byte header > actually has some good use: in a table of up to 8 columns, you can > fit

[HACKERS] 8.2beta1 failure on IRIX

2006-10-01 Thread Steve Singer
I'm getting some failures in the regression tests on 8.2beta1 on IRIX. It looks like IRIX (or at least some versions) has a broken strtod. The float4 and float8 tests fail, I've attached a patch to tools/adt/float.c that fixes the problem along with the regression output. As a side note,could

Re: [HACKERS] Numeric overflow problem + patch

2006-10-01 Thread David Fetter
On Thu, Sep 28, 2006 at 11:16:56PM +0200, Martijn van Oosterhout wrote: > On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: > > David Fetter <[EMAIL PROTECTED]> writes: > > > ! DETAIL: A field with precision 4, scale 4 must have an absolute value > > > less than 1. > > > [ becomes ] > > >

Re: [HACKERS] Win32 hard crash problem

2006-10-01 Thread Andrew Dunstan
IIRC there is no real SIGINT on Windows, so it can only come from a postgres program. The windows shutdown could be calling pg_ctl to stop the service, of course. cheers andrew Joshua D. Drake wrote: > Magnus Hagander wrote: That log entry is the last (of consequence) entry before >>> the

Re: [HACKERS] Select for update with outer join broken?

2006-10-01 Thread Tom Lane
Josh Berkus writes: >> What SQL query is it complaining about, exactly? That error message has >> been there right along, but I seem to recall having moved the place >> where it's checked for since 8.1. > FYI, this was working using the snapshot from about a month ago. But did it ever work agai

Re: [HACKERS] Select for update with outer join broken?

2006-10-01 Thread Josh Berkus
Tom, > What SQL query is it complaining about, exactly? That error message has > been there right along, but I seem to recall having moved the place > where it's checked for since 8.1. It's from SpecJAppserver. I've requested the help of a java geek in extracting the query. FYI, this was wor

Re: [HACKERS] Win32 hard crash problem

2006-10-01 Thread Joshua D. Drake
Magnus Hagander wrote: >>> That log entry is the last (of consequence) entry before >> the machine says: >>> 2006-09-28 16:40:36.921 LOG: received fast shutdown request >> Oh? That's pretty interesting on a Windows machine, because >> AFAIK there wouldn't be any standard mechanism that might t

Re: [HACKERS] libedit broke in head

2006-10-01 Thread Joshua D. Drake
Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: >> I really don't get the libedit-preferred syntax? Why not just: > >> --with-libedit use BSD Libedit not GNU Readline >> --with-readline use GNU Readline not BSD Libedit >> --without-readline do not use GNU Readline nor BSD Lib

Re: [HACKERS] 8.2beta1 failure on IRIX

2006-10-01 Thread Tom Lane
[EMAIL PROTECTED] writes: > I'm getting some failures in the regression tests on 8.2beta1 on IRIX. > It looks like IRIX (or at least some versions) has a broken strtod. > The float4 and float8 tests fail, I've attached a patch to > tools/adt/float.c that fixes the problem along with the regression

Re: [HACKERS] Win32 hard crash problem

2006-10-01 Thread Magnus Hagander
> > That log entry is the last (of consequence) entry before > the machine says: > > 2006-09-28 16:40:36.921 LOG: received fast shutdown request > > Oh? That's pretty interesting on a Windows machine, because > AFAIK there wouldn't be any standard mechanism that might tie > into our homegrow

Re: [HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Magnus Hagander
> I was just trying to build using the src/tools/msvc scripts > on windows, and I was wondering if there were any > instructions on how to do this, what prerequisites there are, > where to get them, etc. I couldn't find any, but I may not > know the correct place to look. That's on my TODO li

[HACKERS] 8.2beta1 failure on IRIX

2006-10-01 Thread ssinger_pg
I'm getting some failures in the regression tests on 8.2beta1 on IRIX. It looks like IRIX (or at least some versions) has a broken strtod. The float4 and float8 tests fail, I've attached a patch to tools/adt/float.c that fixes the problem along with the regression output. As a side note,could

Re: [HACKERS] libedit broke in head

2006-10-01 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > I really don't get the libedit-preferred syntax? Why not just: > --with-libedituse BSD Libedit not GNU Readline > --with-readline use GNU Readline not BSD Libedit > --without-readline do not use GNU Readline nor BSD Libedit Well, the point i

Re: [HACKERS] [PATCHES] Generic Monitoring Framework with DTrace patch

2006-10-01 Thread Robert Treat
On Monday 24 July 2006 17:00, Robert Lor wrote: > Excellent! I'll submit a doc patch shortly. > > Regards, > -Robert > > Peter Eisentraut wrote: > >I've committed the dtrace patch. Some documentation would be nice now ... > Looking through -patches I don't see the doc patch, and outside of insta

[HACKERS] src/tools/msvc usage instructions

2006-10-01 Thread Jeremy Drake
I was just trying to build using the src/tools/msvc scripts on windows, and I was wondering if there were any instructions on how to do this, what prerequisites there are, where to get them, etc. I couldn't find any, but I may not know the correct place to look. Sorry if this is the wrong list fo