Re: 2nd update on TOAST

Philip Warner wrote:
> At 11:09 6/07/00 +0200, Jan Wieck wrote:
> >
> >    No. It's all in the current CVS tree. I removed that patch
> >    already.
> >
>
> OK, I've updated from CVS and rebuilt & it worked. The, to be sure, I did a
> 'make distclean' then a 'make' & 'make install' again, and now postmaster
> wont start (SIGSEGV). I have rebuild with '-O0 -g', gone into gdb, but the
> process dies so I cant get a backtrace.

    Have the same symptom with a completely fresh cvs checkout.

> If anyone can give me some tips on tracking this down, I would appreciate
> it....

    Bruce  applied  a  patch  to configure.in yesterday. Read the
    comments from the cvslog. It tells that it triggers a bug  in
    the  Linux  kernels  fcntl(SETLK)  code  when  used with unix
    domain sockets, and that the bug is present in Linux  kernels
    <=  2.2.16. I'm running a 2.2.12 here, and so it exactly dies
    in pqcomm.c line 229 on fcntl() against the socket.

    Undefining  HAVE_FCNTL_SETLK  in  config.h  did  it  for   me
    temporary. Don't know how to deal with it finally.

    With this setup I did

        initdb
        createdb
        psql <megaview.sql
        pg_dump pgsql >megaview.dump

    In  the  dump  file,  the  first  2183  bytes look OK. What's
    following then looks like internal tables where pg_dump holds
    the info of the schema analyzing.

    And don't worry that the view is dumped as table with a later
    CREATE RULE.  That's correct this way.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #