Re: BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.
Date
Msg-id 8379.1261493303@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.  (Dave Page <dpage@pgadmin.org>)
Responses Re: BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.  (Ashish Anand <Ashish.The.Dev@gmail.com>)
Re: BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
Dave Page <dpage@pgadmin.org> writes:
> In 12 years of working with PG, I never noticed that directory
> required building manually (which is why it's not it any installer
> from EDB, or the community). Is there any reason for that?

To judge from the RPM examples, you'd probably need special actions
anyway.  The RPMs need to change the installed path.  I have these
steps in the Fedora/Red Hat specfile:

# Have to hack makefile to put correct path into tutorial scripts
sed "s|C=\`pwd\`;|C=%{_libdir}/pgsql/tutorial;|" < src/tutorial/Makefile > src/tutorial/GNUmakefile
make %{?_smp_mflags} -C src/tutorial NO_PGXS=1 all
rm -f src/tutorial/GNUmakefile

install -d -m 755 $RPM_BUILD_ROOT%{_libdir}/pgsql/tutorial
cp src/tutorial/* $RPM_BUILD_ROOT%{_libdir}/pgsql/tutorial

It looks to me like the unmodified Makefile builds the .sql files
on the assumption they will be used *in the source tree*.  So basically
no installer could use that as-is anyway.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Ashish Anand
Date:
Subject: Re: BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.
Next
From: "Kevin Grittner"
Date:
Subject: Re: OutOfMemory hibernate scroll with 2M records | Postgresql 8.4 DB