Re: [HACKERS] Re: 7.1 RPMs

2001-04-15 Thread Tom Lane
Thomas Lockhart [EMAIL PROTECTED] writes: I'm not a big fan of the trend to fork off a mailing list anytime more than a few messages on a single topic come through. The synergy and cross-pollination that we get by having us all see various topics wrt development far outweigh the minor

Re: [HACKERS] Re: 7.1 RPMs

2001-04-15 Thread The Hermit Hacker
On Sun, 15 Apr 2001, Thomas Lockhart wrote: Do we need to start thinking about an RPM mailing list? Seems there is lots of traffic. The delete key is your friend. So is procmail, if you just can't stand to see the letters "R", "P", and "M" too close together ;) I'm not a big fan of the

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Nathan Myers
On Sun, Apr 15, 2001 at 01:17:15AM -0400, Vince Vielhaber wrote: Here's my response to the inaccurate article cmp produced. After chatting with Marc I decided to post it myself. ... Where do you get your info? Do you just make it up? PostgreSQL is not a product of Great Bridge and

[HACKERS] How to do the modular test

2001-04-15 Thread Werachart Jantarataeme
Hi pgsql-hackers, Could anyone advise me how to do modular test in any partial PostgreSQL's modules? I am interested in the PostgreSQL development. I have begun study the DBMS source code by developer documentation provided by postgresql.org especially internal.ps that is the best

Re: [HACKERS] NUMERIC type benchmarks

2001-04-15 Thread Mario Weilguni
Am Freitag, 13. April 2001 23:16 schrieben Sie: Tom Lane wrote: A more significant point is that you have presented no evidence to back up your claim that this would be materially faster than the existing type. I doubt that the extra pallocs are all that expensive. (I think it'd be far

[HACKERS] SQL

2001-04-15 Thread Sergio Pili
Hi, Sorry, per OOC... Somebody could tell me where I can find documentation online about SQL2 and SQL3 (especially the last). This the SQL3 approved finally? That match is between SQL92,SQL96,SQL99 and the SQL2 and SQL3? Thanks, Sergio ---(end of

Re: [HACKERS] Re: Hand written parsers

2001-04-15 Thread Bruce Guenter
On Fri, Apr 13, 2001 at 03:12:57AM -0400, Tom Lane wrote: I have some interest in proposals to switch to a better parser-generator tool than yacc ... There are tools to produce efficient top-down parsers as well. Those doing such parsers "by hand" may be interested in looking at PCCTS

[HACKERS] CRN article

2001-04-15 Thread Ned Lilly
Folks, By now, I imagine a number of people have seen the piece on the Computer Reseller News website about Great Bridge and PostgreSQL. While I think we're all happy to see the increased visibility for PostgreSQL (especially as compared to the Oracles of the world), it's fair to say the article

Re: [HACKERS] CRN article

2001-04-15 Thread The Hermit Hacker
So, to sum up ... the article did a good job of representing Great Bridge, did a great injustice (a slap in the face, so to say) to the PostgreSQL community as a whole, so Great Bridge has no intention of correcting the situation? Just to clarify your position, of course ... On Sun, 15 Apr

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread The Hermit Hacker
On Sat, 14 Apr 2001, Nathan Myers wrote: This is probably a good time to point out that this is the _worst_ _possible_ response to erroneous reportage. The perception by readers will not be that the reporter failed, but that PostgreSQL advocates are rabid weasels who don't appreciate

Re: [HACKERS] Re: 7.1 RPMs

2001-04-15 Thread Karl DeBisschop
Bruce Momjian wrote: Do we need to start thinking about an RPM mailing list? Seems there is lots of traffic. IIRC, this question was asked about 6 months ago, and the answer was RPM should be discussed on PostgreSQL-Ports. On the other hand, it seems in practice most people are unaware of

Re: [HACKERS] pg_dump compatibility with 7.0

2001-04-15 Thread Philip Warner
At 01:08 15/04/01 -0400, Tom Lane wrote: SFUNC1/STYPE1/INITCOND1 in 7.0 equate to SFUNC/STYPE/INITCOND in 7.1. There is no 7.1 equivalent to 7.0's SFUNC2/STYPE2/INITCOND2 It now outputs a warning to stderr as well as the dump file. --- those have to be saved/restored separately if you are

[HACKERS] Re: Fast Forward (fwd)

2001-04-15 Thread Mitch Vincent
To top it all off, their comments are broken -- I submitted mine and it displays Marc's again (until you click on the link of course).. *sigh* they must be using MySQL. :-) -Mitch - Original Message - From: "The Hermit Hacker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April

[HACKERS] The Current Release Docs

2001-04-15 Thread Mitch Vincent
The "Current Release Docs" on the PostgreSQL website still look 7.0.Xish.. Just an FYI... -Mitch ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] Re: Fast Forward (fwd)

2001-04-15 Thread Thomas Lockhart
*sigh* they must be using MySQL. :-) *rofl* ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Bruce Momjian
Here's my response to the inaccurate article cmp produced. After chatting with Marc I decided to post it myself. Since I know Ned reads this list, I formally request that he also insists PUBLICALLY that cmp correct their inaccuracies. I'm rather disappointed (for lack of a more

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Bruce Momjian
Here's my response to the inaccurate article cmp produced. After chatting with Marc I decided to post it myself. Since I know Ned reads this list, I formally request that he also insists PUBLICALLY that cmp correct their inaccuracies. I'm rather disappointed (for lack of a more

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Bruce Momjian
It will be harder than the original mailings, but I urge each who wrote to write again and apologize for attacking her. In a way, I think you are right .. I think the attack was aimed at the wrong ppl :( She obviously didn't get *any* of her information from ppl that belong *in* the Pg

Re: [HACKERS] NUMERIC type benchmarks - CORRECTED

2001-04-15 Thread Mark Butler
Mario Weilguni wrote: I tested that on a similar configuration (P-III 450) and got the same results. When the addition is removed from the loop and replaced with a simple assignment, the total execution time goes down to ~6.5 seconds. That means that the modified numeric is nearly twice as

[HACKERS] Int64 (long long) Supporting Compiler Requirement Status?

2001-04-15 Thread Mark Butler
There was a discussion once about using 64 bit long long compiler support to increase the size of the transaction ids to solve the wrap around problem. I understand that there is a different solution for this now. However, my question is: Are we to the point where int64's can be used in

Re: [HACKERS] NUMERIC type benchmarks - CORRECTED

2001-04-15 Thread Tom Lane
Mark Butler [EMAIL PROTECTED] writes: ... The correct numbers should be: Postgres PL/PGSQL original numeric:14.8 seconds Postgres PL/PGSQL modified numeric:14.0 seconds Postgres PL/PGSQL float8: 10.7 seconds GNU AWK:2.5 seconds Oracle

[HACKERS] Re: Hey guys, check this out.

2001-04-15 Thread Lincoln Yeoh
At 10:59 PM 14-04-2001 -0400, Lamar Owen wrote: http://www.crn.com/Sections/Fast_Forward/fast_forward.asp?ArticleID=25670 Marc will be pleased to note that the PostgreSQL project came out of the FreeBSD project, and is Great Bridge's database. Gotta love journalistic license. Reporter must

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Lamar Owen
Bruce Momjian wrote: Not that it shouldn't be fixed. I just don't get worked up over it. Well, in a way I regret bringing it to the attention of the community -- just in a small way. But at the same time I realized that I was not the right one at that time to craft a reply -- after all, I'm a

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Nathan Myers
On Sun, Apr 15, 2001 at 11:44:48AM -0300, The Hermit Hacker wrote: On Sat, 14 Apr 2001, Nathan Myers wrote: This is probably a good time to point out that this is the _worst_ _possible_ response to erroneous reportage. The perception by readers will not be that the reporter failed, but

Re: [HACKERS] Re: Hey guys, check this out.

2001-04-15 Thread Vince Vielhaber
On Mon, 16 Apr 2001, Lincoln Yeoh wrote: Maybe you guys should get some Great Bridge marketing/PR person to handle stuff like this. After reading Ned's comments I figured that's how it got that way in the first place. But that's just speculation. Vince. --

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Bruce Momjian
Here's my response to the inaccurate article cmp produced. After chatting with Marc I decided to post it myself. Since I know Ned reads this list, I formally request that he also insists PUBLICALLY that cmp correct their inaccuracies. I'm rather disappointed (for lack of a more

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread The Hermit Hacker
the thing that pissed me off the most, and set me off, was the totally blatant errors ... we've had other articles written, with a GB slant to them, that didn't get my feathers in a ruffle ... the fact that they *talked* with GB, got quotes from them and some of their partners, and *still* got

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Bruce Momjian
I wanted to comment on how we handled this article. Seems the author did not understand the company/open-source relationship. This is not a huge surprise. I have to explain it to my friends and relatives all the time. Now, our way of dealing with users who ask questions is to gently lead them

Re: [HACKERS] Fast Forward (fwd)

2001-04-15 Thread Bruce Momjian
You can tell people why they shouldn't feel a certain way, but preventing them from expressing their feelings is usually a bad thing, unless their expression is hurting other people. (Hurting my feelings is OK.) I usually sit back until everyone's cards/feelings are on the table, and

Re: [HACKERS] Re: Hey guys, check this out.

2001-04-15 Thread Tom Lane
Vince Vielhaber [EMAIL PROTECTED] writes: On Mon, 16 Apr 2001, Lincoln Yeoh wrote: Maybe you guys should get some Great Bridge marketing/PR person to handle stuff like this. After reading Ned's comments I figured that's how it got that way in the first place. But that's just speculation.

Re: [HACKERS] Re: Hey guys, check this out.

2001-04-15 Thread Nathan Myers
On Sun, Apr 15, 2001 at 10:05:46PM -0400, Vince Vielhaber wrote: On Mon, 16 Apr 2001, Lincoln Yeoh wrote: Maybe you guys should get some Great Bridge marketing/PR person to handle stuff like this. After reading Ned's comments I figured that's how it got that way in the first place.

[HACKERS] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)

2001-04-15 Thread Bruce Momjian
OK, looks like we have a Tru64 problem with 7.1 too. Can you tell us how to get a NAN value. Zero is not it. I see the following mentions of NAN in the code. Does NAN exist in one of your /usr/include files? include/port/qnx4.h:18:#ifndef NAN

[HACKERS] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)

2001-04-15 Thread Thomas Lockhart
OK, looks like we have a Tru64 problem with 7.1 too. Can you tell us how to get a NAN value. Zero is not it. I see the following mentions of NAN in the code. Does NAN exist in one of your /usr/include files? We had at least three reports of successful compilation on Tru64 4.0[dg] and

[HACKERS] Re: How to do the modular test

2001-04-15 Thread Thomas Lockhart
What I would like to know is, if I have changed some ot the modules, how can I use GNU gdb to debug the modified codes? You can run the backend directly from gdb: $ gdb postgres (set breakpoint) b routine_to_breakpoint (tell gdb to begin) run -D path_to_database (enter query at

[HACKERS] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)

2001-04-15 Thread Bruce Momjian
No, those don't do it. We need an actual NaN value. These are just flags, I think. There are two things I found from fp_class.h, FP_SNAN (a signaling NaN), and FP_QNAN (a quiet NaN). Don't know which you want: alphapc.ourservers.net grep FP_SNAN /usr/include/*

Re: [HACKERS] Int64 (long long) Supporting Compiler Requirement Status?

2001-04-15 Thread Tom Lane
Mark Butler [EMAIL PROTECTED] writes: However, my question is: Are we to the point where int64's can be used in mainstream code yet, or are there supported platforms that this will not work with? And if not, when (if ever) will such capability be standardized? I don't foresee ever being