[HACKERS] UnixWare 7.1.1b FS

2000-10-20 Thread Larry Rosenman
I got early access to the UnixWare 7.1.1b Feature Supplement UnixWare/OpenServer Development Kit (UDK FS for short). PostgreSQL 7.0.2 compiles CLEAN (ish...) and we can now support the C++ stuff. The 3.2 bug in int8.c is GONE. Question: Why do we (for UnixWare) force i486 optimization? A

[HACKERS] Re: [COMMITTERS] pgsql/doc (FAQ_MSWIN INSTALL_MSWIN)

2000-10-20 Thread Thomas Lockhart
Peter Eisentraut wrote: > OTOH, support for Windows NT with Cygwin is not "exceptional" compared to > any other supported system. You run configure; make; make install, with > GNU make and GCC. The only thing this INSTALL_WIN file does is to tell > people where to download Cygwin and cgyipc, whic

Re: [HACKERS] New build fails: cannot find postmaster.opts.default

2000-10-20 Thread Peter Eisentraut
Kevin O'Gorman writes: > I'm getting a complaint from pg_ctl that it cannot find > postmaster.opts.default. > > What am I missing? The postmaster.opts.default file. :-) Seriously, I'm thinking this check is not necessary, a missing file should be treated like an empty file. Objections? -- P

Re: [HACKERS] New build fails: cannot find postmaster.opts.default

2000-10-20 Thread Ross J. Reedstrom
On Fri, Oct 20, 2000 at 04:15:11PM -0700, Kevin O'Gorman wrote: > I've just built 7.1 from a slightly old point in the tree: > October 9. Regression tests pass, but postmaster won't > start. > > I'm getting a complaint from pg_ctl that it cannot find > postmaster.opts.default. > > What am I mis

[HACKERS] New build fails: cannot find postmaster.opts.default

2000-10-20 Thread Kevin O'Gorman
I've just built 7.1 from a slightly old point in the tree: October 9. Regression tests pass, but postmaster won't start. I'm getting a complaint from pg_ctl that it cannot find postmaster.opts.default. What am I missing? ++ kevin -- Kevin O'Gorman (805) 650-6274 mailto:[EMAIL PROTECTED] Pe

[HACKERS] Navigating time-warps in the CVS tree (was re the rule system)

2000-10-20 Thread Kevin O'Gorman
Tom Lane wrote: > I'm not sure whether to recommend that you work from current CVS sources > or not. A couple weeks ago that's what I would have said, but Vadim is > halfway through integrating WAL changes and I'm not sure how stable the > tip really is. You could try the tip, and if it blows up

Re: make depend (Re: [HACKERS] Coming attractions: VPATH build; makevariables issue)

2000-10-20 Thread Peter Eisentraut
Tom Lane writes: > Do you have an idea how much it'd bloat the tarball to do that? current depsincrease gzipped 7.1 MB 35591 bytes 0.5% unpacked29MB1309669 bytes 4% Should be okay... -- Peter Eisentraut [EMAIL

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Peter Eisentraut
Ross J. Reedstrom writes: > For example, no one seems to have commented on the -8% of inline > comments reported by Peter's c_count! Funny math, indeed. If you had actually done the math ;-) you would have noticed that the percentage of the inline comments is negative because those lines have bo

Re: [HACKERS] what is CVS?

2000-10-20 Thread Trond Eivind Glomsrød
Robert Kernell <[EMAIL PROTECTED]> writes: > > Kevin O'Gorman wrote: > > > > > > I've been unable to follow the directions > > > in the Programmer's Guide > > > for getting to the anonymous CVS server. > > > > > > I'm running RedHat 6.1, and CVS 1.10 which > > What is CVS? An open-source netw

Re: [HACKERS] is there a way to DROP foreign key constraint ?

2000-10-20 Thread Stephan Szabo
On Fri, 20 Oct 2000, Hannu Krosing wrote: > I'm unable to find the complementary function to > > ALTER TABLE t ADD FOREIGN KEY(id) REFERENCES pkt(pk); Currently, ALTER TABLE ... DROP table constraint definition doesn't exist. > I would try DROP TRIGGER, but I've also been unable to > find

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Ross J. Reedstrom
On Fri, Oct 20, 2000 at 01:30:25PM -0400, Bruce Momjian wrote: > I compute the code count with: > > find . -name \*.[chyl] | xargs cat| wc -l Right, that solves the problem others might be seeing, with the command line getting expanded and silently chopped off. For example, no one seems to

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Karel Zak
On Fri, 20 Oct 2000, Hannu Krosing wrote: > Peter Eisentraut wrote: > > > > Bruce Momjian writes: > > > > > FYI, it is 376k lines of C code, not bytes. > > > > How did you calculate that? I get this using c_count over all .c and .h > > files: > > > > 20903 lines had comments25.4 %

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Bruce Momjian
I compute the code count with: find . -name \*.[chyl] | xargs cat| wc -l -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.

[HACKERS] Re: [COMMITTERS] pgsql/doc (FAQ_MSWIN INSTALL_MSWIN)

2000-10-20 Thread Peter Eisentraut
Thomas Lockhart writes: > Hmm. It is a fact that M$Windows is not quite the same as *any* of the > other boxes we support. > We currently have a section in the printed/html docs covering installing > on M$ for client-side libraries, and we should move the installation > instructions for the serv

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Hannu Krosing
Peter Eisentraut wrote: > > Bruce Momjian writes: > > > FYI, it is 376k lines of C code, not bytes. > > How did you calculate that? I get this using c_count over all .c and .h > files: > > 20903 lines had comments25.4 % > 6603 comments are inline -8.0 % > 11911 lines were

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Bruce Momjian
> Bruce Momjian writes: > > > FYI, it is 376k lines of C code, not bytes. > > How did you calculate that? I get this using c_count over all .c and .h > files: > > 20903 lines had comments25.4 % > 6603 comments are inline -8.0 % > 11911 lines were blank 14.5 % >

[HACKERS] what is CVS?

2000-10-20 Thread Robert Kernell
> Kevin O'Gorman wrote: > > > > I've been unable to follow the directions > > in the Programmer's Guide > > for getting to the anonymous CVS server. > > > > I'm running RedHat 6.1, and CVS 1.10 which What is CVS? Bob Kernell Research Scientist Surface Validation Group AS&M, Inc. email: [EMAIL

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Peter Eisentraut
Bruce Momjian writes: > FYI, it is 376k lines of C code, not bytes. How did you calculate that? I get this using c_count over all .c and .h files: 20903 lines had comments25.4 % 6603 comments are inline -8.0 % 11911 lines were blank 14.5 % 7287 lines for prepro

Re: [HACKERS] Unable to access CVS server

2000-10-20 Thread Hannu Krosing
Kevin O'Gorman wrote: > > I've been unable to follow the directions > in the Programmer's Guide > for getting to the anonymous CVS server. > > I'm running RedHat 6.1, and CVS 1.10 which > comes with it. I get as far as entering > the 'postgresql' password, but it gets > rejected every time. >

Re: [HACKERS] to_char() dumps core

2000-10-20 Thread Karel Zak
On Fri, 20 Oct 2000, Tatsuo Ishii wrote: > In 7.0.2 > >select to_char(sum(n),'999') from t1; > > causes backend dump a core if n is a float/numeric ...data type AND if > sum(n) returns NULL. This seems due to a bad null pointer handling for > aruguments of pass-by-reference data types. I

Re: [HACKERS] Re: pg_dump docs

2000-10-20 Thread Vince Vielhaber
On Fri, 20 Oct 2000, Thomas Lockhart wrote: > Ah, the build has been failing for at least the last few days due to > small problems in new content. Since I receive ~700 logs of doc builds > each year (well, that is the annual rate but I've only stepped up to > twice daily since ~April), I get slo

[HACKERS] is there a way to DROP foreign key constraint ?

2000-10-20 Thread Hannu Krosing
I'm unable to find the complementary function to ALTER TABLE t ADD FOREIGN KEY(id) REFERENCES pkt(pk); I would try DROP TRIGGER, but I've also been unable to find a way to name the constraint ;( the built-in help is both inadequate and inconsistent 8<-8<-8<-8<

[HACKERS] Re: RE. COBOL FILES

2000-10-20 Thread Thomas Lockhart
Orlandi wrote: > > I am user of Microfocus Cobol Netexpress 3.1 and I use > IDXFORMAT " 4 " for my files. > I know that I can use the format Btrieve ANSI and to install Btrieve > in my Linux server with Format : IDXFORMAT " 6 " , and in the > case of Btrieve I can just recompile the programs, w

[HACKERS] to_char() dumps core

2000-10-20 Thread Tatsuo Ishii
In 7.0.2 select to_char(sum(n),'999') from t1; causes backend dump a core if n is a float/numeric ...data type AND if sum(n) returns NULL. This seems due to a bad null pointer handling for aruguments of pass-by-reference data types. I think just a simple null pointer checking at very top of

Re: make depend (Re: [HACKERS] Coming attractions: VPATH build; make variables issue)

2000-10-20 Thread Brook Milligan
Peter Eisentraut <[EMAIL PROTECTED]> writes: > What we could do is ship the dependencies (.deps/*.P) in the tarball. > That would require running an entire build before making a tarball, but it > would be a nice service to users. Hm. It might be handy for people not using gcc, s

Re: [HACKERS] Re: pg_dump docs

2000-10-20 Thread Thomas Lockhart
> [Not to list] Back on list; thanks though for protecting me from ridicule ;) > >For developers (-hackers developers, not application developers using > >the current release), the "current docs" correspond to the docs built > >nightly (actually twice a day), which reflect the current developmen

AW: AW: [HACKERS] Backup, restore & pg_dump

2000-10-20 Thread Zeugswetter Andreas SB
> > Yes, writes are only necessary when "too many dirty pages" > > are in the buffer pool. Those writes can be done by a page flusher > > on demand or during checkpoint (don't know if we need checkpoint, > > but you referred to doing checkpoints). > > How else to know from where in log to start

Re: [HACKERS] INHERITS doesn't offer enough functionality

2000-10-20 Thread Chris
> The point is: this is classic, but noone does it > like this if your really have a larger hierarchy of > classes. You'll not get any good performance, when > solving an association in your oo > program, because the framework has to query against > each table: 6 tables - 6 queries !!! :-(((