Re: [HACKERS] 6.5 cvs: can't drop table

On Tue, 25 May 1999, Bruce Momjian wrote:

> Date: Tue, 25 May 1999 11:06:32 -0400 (EDT)
> From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
> To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
> Cc: hackers(at)postgreSQL(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
> Subject: Re: [HACKERS] 6.5 cvs: can't drop table
>
> I hate to say this, but I think we need postgres compiled with debugging
> symbols, -g, so we can see the parameters being passed to the functions.
>

No crashes with -O0 -g :-) I have egcs 1.12 release installed at this
machine as well as at home. I used the same optimization -O2 -mpentium
but at work postgres crashes while at home works like a charm.

btw,

just got new updates from cvs - a bunch of files !

Two problems:
1. at work:

make[3]: Entering directory /home/postgres/cvs/pgsql/src/backend/utils/mb'
gcc -I../../../include -I../../../backend -O2 -mpentium -Wall -Wmissing-prototypes -I../.. -DMULTIBYTE=KOI8 -c conv.c -o conv.o
conv.c: In function ig52mic':
conv.c:387: parse error before '
conv.c:392: parse error before lse'
conv.c:378: warning: 1' might be used uninitialized in this function
conv.c: At top level:
conv.c:422: parse error before }'
conv.c:423: warning: type defaults to nt' in declaration of '
conv.c:423: warning: data definition has no type or storage class
conv.c:424: parse error before }'
make[3]: *** [conv.o] Error 1
make[3]: Leaving directory /home/postgres/cvs/pgsql/src/backend/utils/mb'
make[2]: *** [submake] Error 2

2. at home:

postmaster.c: In function erverLoop':
postmaster.c:668: too few arguments to function ettimeofday'
postmaster.c:707: too few arguments to function ettimeofday'
postmaster.c:666: warning: unused variable z'
postmaster.c: In function oBackend':
postmaster.c:1512: too few arguments to function ettimeofday'
postmaster.c:1463: warning: unused variable z'
make[2]: *** [postmaster.o] Error 1
make[2]: Leaving directory /u/postgres/cvs/pgsql/src/backend/postmaster'

This problem I've seen already !

>
> > #0 0x80b6065 in equal ()
> > #1 0x80c7652 in pathorder_match ()
> > #2 0x80c7900 in better_path ()
> > #3 0x80c7863 in add_pathlist ()
> > #4 0x80bf551 in update_rels_pathlist_for_joins ()
> > #5 0x80c8b8b in gimme_tree ()
> > #6 0x80c8ae7 in geqo_eval ()
> > #7 0x80c99f2 in random_init_pool ()
> > #8 0x80c8c7b in geqo ()
> > #9 0x80bd6e6 in make_one_rel_by_joins ()
> > #10 0x80bd5ee in make_one_rel ()
> > #11 0x80c1e81 in subplanner ()
> > #12 0x80c1dff in query_planner ()
> > #13 0x80c2173 in union_planner ()
> > #14 0x80c1f55 in planner ()
> > #15 0x80e22e7 in pg_parse_and_plan ()
> > #16 0x80e240b in pg_exec_query_dest ()
> > #17 0x80e23cc in pg_exec_query ()
> > #18 0x80e3518 in PostgresMain ()
> > #19 0x80cc72c in DoBackend ()
> > #20 0x80cc26b in BackendStartup ()
> > #21 0x80cb9e7 in ServerLoop ()
> > #22 0x80cb573 in PostmasterMain ()
> > ---Type <return> to continue, or q <return> to quit---
> > #23 0x80a2999 in main ()
> > #24 0x806131e in _start ()
> > (gdb)
> >
> >
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83