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
abug in the Linux kernels fcntl(SETLK) code when used with unix domain sockets, and that the bug is present
inLinux kernels <= 2.2.16. I'm running a 2.2.12 here, and so it exactly dies in pqcomm.c line 229 on fcntl()
againstthe 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_dumpholds 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 #