Re: Outer joins and Seq scans

Hi,

Le lundi 29 octobre 2007, Tom Lane a écrit :
> Is there any chance you can apply the one-line
> patch shown here:
> http://archives.postgresql.org/pgsql-committers/2007-10/msg00374.php
>
> If rebuilding packages is not to your taste, possibly a down-rev to
> 8.2.4 would be the easiest solution.

The debian package for PostgreSQL uses a .tar.gz of the upstream code along
with a debian/patches/ directory with ordered patches files
(##-whatever.patch). Just adding the given file into this directory before to
building the package should do.

The operations to issue should look like this:
$ apt-get source postgresql-8.2
$ tar xzf postgresql-8.2_8.2.5.orig.tar.gz
$ cd postgresql-8.2-8.2.5
$ zcat ../postgresql-8.2_8.2.5-1.diff.gz |patch -p1
$ cp make_outerjoininfo.patch debian/patches/60-make_outerjoininfo.patch
$ debuild -us -uc

This will give you a new package for postgresql, which you can even tweak the
version number to your taste by editing debian/changelog and adding (for
example) a postgresql-8.2 (8.2.5.1-1) entry, just before the debuild step.

Hope this helps,
--
dim