From: Craig Ringer <craig@postnewspapers.com.au>
To: LaboRecherche <nomail@altranx.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using SKYLINE command on PostgreSQL
Date: Sun, 08 Aug 2010 11:35:24 +0800
Message-ID: <4C5E25FC.9080303@postnewspapers.com.au> (raw)
In-Reply-To: <i3c4a7$j6r$1@speranza.aioe.org>
References: <i3c4a7$j6r$1@speranza.aioe.org>
On 05/08/10 00:26, LaboRecherche wrote:
>
>
> Hello,
>
> I have just installed version 8.4 of PostGresql (on a Windows machine)
> in order to use SKYLINE command, but it seems that I get an error each
> time I try to use this command.
>
> Is there a specific plugin to install to add SKYLINE command ? Can you
> help me on this point to get this command working ?
All I can find with a quick Google search for "SKYLINE postgresql" is
references to someone's masters thesis, plus a bit of mailing list
discussion.
There's no indication it was ever proposed and discussed as a serious
patch to the core of PostgreSQL, let alone applied. Have a look at this
thead, including follow-ups.
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00192.php
The masters thesis page does contain a patch against PostgreSQL 8.3:
http://skyline.dbai.tuwien.ac.at/
but this is something you have to apply to the source code, then compile
PostgreSQL into usable binaries. That's trivial on Linux, but I don't
recommend you try it on Windows, as compiling software on Windows is
much more complex.
They say they're porting the patch to 8.4devel, but I suspect that since
8.4 has been out for ages and 9.0 is almost released, they've probably
lost interest and dropped the work.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: craig@postnewspapers.com.au, nomail@altranx.com
Subject: Re: Using SKYLINE command on PostgreSQL
In-Reply-To: <4C5E25FC.9080303@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox