Re: [HACKERS] test beta build

Yes, I see those regularly too, and are related to bison issues. --- Christopher Kings-Lynne wrote: It all built and passes regressions for me on freebsd/alpha, I got this though: gcc -pipe -O -Wall

Re: [HACKERS] logging stuff

--On Tuesday, August 05, 2003 16:27:55 -0400 Tom Lane [EMAIL PROTECTED] wrote: Josh Berkus [EMAIL PROTECTED] writes: From my perspective, we could really use a delimiter between the fields of log output which is unlikely to appear within those fields instead of parsing by character count,

Re: [HACKERS] test beta build

Christopher Kings-Lynne [EMAIL PROTECTED] writes: gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error -I ./../include -I. -I../../../../src/include -DMAJOR_VERSION=3 -DMINOR_VERSIO N=0 -DPATCHLEVEL=0 -DINCLUDE_PATH=\/home/chriskl/local/include\ -c -o preproc.o

Re: [HACKERS] problem with RH7.3 Pg7.3.4 binaries

Hi there, I have a RedHat 7.3 machine that can build the 7.3.4 RPMs if required - it only contains RPMs from the vanilla CD or from updates.redhat.com. I've just done a test build and everything seems OK except that the C compiler is passed the -mcpu=i686 flag - I'm guessing I need to somehow

[HACKERS] 7.4Beta1: Compile Failure: UnixWare 7.1.3UP2

cc -O -K inline -g -I../../../../src/include -I/usr/local/include -c -o printtup.o printtup.c UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled UX:acomp: ERROR: printtup.c, line 94: undefined struct/union member: _shutdown UX:acomp: WARNING: printtup.c, line 94:

Re: [HACKERS] Release changes

OK, I moved them both to the object section, next to each other. --- Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Why is this not together with the mention that dollar signs are *not* allowed

Re: [HACKERS] win32 porting in 7.4

No, win32 was delayed for 7.5. --- Jinqiang Han wrote: hi, Tom and Momjian I wonder if 7.4 will have win32 porting£¿ I checkout source from cvs. I only find win32 makefile for client.

[HACKERS] new psql \d command

Hi guys (tom), Just reminding people that there was a question regarding my changes to psql's \d command. I'm not sure if everyone wanted all the identifier names double quoted or not... And are people happy with the layout in general? Also, I think it'd be nice if my recent patch to use the

[HACKERS] When did we get to be so fast?

I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me 8333 inserts per second. That seems very high. I remember

Re: [HACKERS] new psql \d command

Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: It just seemed complex to figure out which operators needed parens and which didn't. The fact that the first attempt was wrong doesn't improve my faith in that code one bit ;-). I don't want pg_dump invoking it, even as an option.

Re: [HACKERS] changes to support logging

Andrew Dunstan [EMAIL PROTECTED] writes: I've noticed an inconsistency in calls to gettimeofday(): sometimes it is passed a struct tz (which is ignored) as the second argument, and sometimes NULL as the second argument. My understanding is that the second argument is basically useless

Re: [HACKERS] Thread-safe configuration option appears to

-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 4:29 PM To: Peter Eisentraut Cc: Lee Kindness; Larry Rosenman; PostgreSQL Development Subject: Re: [HACKERS] Thread-safe configuration option appears to Peter Eisentraut wrote:

[HACKERS] regression test failure

When I run the regression tests against current sources, I get failures because bison-generated error messages use parse error, not syntax error. I vaguely recall running into this issue before I left for the summer -- did we resolve it? [EMAIL PROTECTED] neil]$ uname -a FreeBSD arch.wavefire.com

Re: [HACKERS] truncate all?

On Wed, 2003-08-06 at 04:39, Andreas wrote: At 17:55 05.08.2003, Josh Berkus wrote: I also don't think that outside of your particular case that there's much demand for it; I would like to believe that there is a need for efficient unit-testing (unit-tests can be seen as a kind of

Re: [HACKERS] Problem building contrib/array in current CVS

Bruno Wolff III [EMAIL PROTECTED] writes: gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I../../src/include -c array_iterator.c -o array_iterator.o array_iterator.c:30: utils/fmgroids.h: No such file or directory make: *** [array_iterator.o] Error 1 This suggests a

Re: [HACKERS] Problem building contrib/array in current CVS

On Thu, Aug 07, 2003 at 13:11:32 -0500, Bruno Wolff III [EMAIL PROTECTED] wrote: I just (with the last half hour) grabbed a fresh copy of 7.4 from CVS and got an error when building contrib/array: gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I../../src/include -c

Re: [HACKERS] When did we get to be so fast?

Bruce Momjian wrote: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me 8333 inserts per second. That seems very high.

Re: [HACKERS] regression test failure

Bruce Momjian [EMAIL PROTECTED] writes: Strange. I know we check for bison = 1.875, and you have that, and so do I, but I don't see those regression failures. Is it possible you have old bison output files from an older bison release? I think the check is only a warning though; and the only

Re: [HACKERS] 7.4beta1 build problem on unixware

Hi Tom, I have NI_NUMERICHOST defined in netdb.h I too can provide an account on my machine(s) if you need a few On Thu, 7 Aug 2003, Tom Lane wrote: Date: Thu, 07 Aug 2003 10:46:47 -0400 From: Tom Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list [EMAIL PROTECTED]

Re: [HACKERS] build on unixware 713

I've filed a bug with the folks I know that work on the compilers. workaround for now is to --enable-debug. LER --On Thursday, August 07, 2003 19:50:21 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: The SCO compilers are notoriously buggy for the past 10-15 years.

Re: [HACKERS] 7.4beta1 build problem on unixware

--On Thursday, August 07, 2003 10:46:47 -0400 Tom Lane [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] writes: I've just tried the cvs on uw 7.13. It fails on compiling hba.c: UX:acomp: ERROR: hba.c, line 651: undefined symbol: AI_NUMERICHOST UX:acomp: ERROR: hba.c, line 1237: undefined symbol:

Re: [HACKERS] Thread-safe configuration option appears to

Bruce Momjian writes: First get your own platforms enabled for the existing thread flag, and we can revisit this when most/all our platforms are supported. We want to avoid confusion of having things work for some platforms and not others with no way to communicate that to the users. Yes,

Re: [HACKERS] new psql \d command

Christopher Kings-Lynne [EMAIL PROTECTED] writes: It might be a bit risky getting pg_dump to use it though? I definitely don't want pg_dump using the pretty-print stuff ;-). I'm neutral on whether to use it in psql's \d commands. regards, tom lane

[HACKERS] 7.4beta compile warning

Hi all, I had these during the compilation: gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -c -o execScan.o execScan.c execScan.c: In function `tlist_matches_tupdesc': execScan.c:199: warning: unused variable `att_tup' In file included from preproc.y:6278:

[HACKERS] 7.4beta1 build problem on unixware

Hi, I've just tried the cvs on uw 7.13. It fails on compiling hba.c: UX:acomp: ERROR: hba.c, line 651: undefined symbol: AI_NUMERICHOST UX:acomp: ERROR: hba.c, line 1237: undefined symbol: AI_NUMERICHOST gmake[3]: *** [hba.o] Error 1 gmake[2]: *** [libpq-recursive] Error 2 gmake[1]: *** [all]

[HACKERS] threads/UnixWare

In src/port, we have in threads.c: /* * Wrapper around getpwuid() or getpwuid_r() to mimic POSIX getpwuid_r() * behaviour, if it is not available. */ int pqGetpwuid(uid_t uid, struct passwd * resultbuf, char *buffer, size_t buflen, struct passwd ** result) { #if

Re: [HACKERS] Correlation in cost_index()

Sean Chittenden [EMAIL PROTECTED] writes: Hrm, after an hour of searching and reading, I think one of the better papers on the subject can be found here: http://www.cs.ust.hk/faculty/dimitris/PAPERS/TKDE-NNmodels.pdf Interesting paper, but I don't see the connection to index order correlation?

Re: [HACKERS] new psql \d command

Well for me it's the difference between this: australia=# \d affiliates_transactions View public.affiliates_transactions Column| Type | Modifiers --+--+--- affiliate_id | integer | date |

[HACKERS] test

ignore ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [HACKERS] When did we get to be so fast?

Bruce Momjian [EMAIL PROTECTED] writes: I was just testing the threaded ecpg, and ran some performance tests. Without using threads, I am seeing 100,000 inserts of a single word into a simple table take 12 seconds: CREATE TABLE test_thread(message TEXT); giving me 8333 inserts per

[HACKERS] Testing gateway

In theory, the news2mail gateway is back in place ... ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])