Thread: [GENERAL] Regarding creating pgpointcloud extension.
Hi,
I have been trying to get pgpointcloud running on greenplum 5.0 database.
This might seem like a convoluted topic to discuss on this mailing list, but
the reason I am asking here is that Greenplum 5 is based on postgres 8.4
and pgpointcloud requires at least postgres 9.0 it seems. So I am wondering:
how does one figure out which postgres 9.0 features in particular does
pgpointcloud depend on? Is there any not-so-difficult way of figuring out
those differences/requirements?
If this is not the correct mailing list for this question, can you kindly direct me
to the right one?
The error I get on Greenplum 5.0 is:
create extension pointcloud;
*ERROR: syntax error at or near "NOT"*
Thanks in advance,
Nandish
Nandish Jayaram <njayaram@pivotal.io> writes: > I have been trying to get pgpointcloud running on greenplum 5.0 database. > This might seem like a convoluted topic to discuss on this mailing list, but > the reason I am asking here is that Greenplum 5 is based on postgres 8.4 > and pgpointcloud requires at least postgres 9.0 it seems. [ scratches head... ] The whole concept of extensions came in with PG 9.1. So unless Greenplum cherry-picked that feature from later, I don't understand how you didn't get something more like this: =# create extension foo; ERROR: syntax error at or near "extension" LINE 1: create extension foo; ^ > So I am wondering: > how does one figure out which postgres 9.0 features in particular does > pgpointcloud depend on? You could try feeding the extension's SQL file directly to psql (in a scratch database so you can clean up easily). If, as is considered good practice, it starts with something like this: -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION cube" to load this file. \quit then you'll need to delete that; but the rest of it should be regular SQL, and you can see what's failing. regards, tom lane
Thank you Tom. I have already started running queries from the corresponding extension. Let's see how far I get! :)
Regards,
Nandish
On Thu, Jul 13, 2017 at 1:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Nandish Jayaram <njayaram@pivotal.io> writes:
> I have been trying to get pgpointcloud running on greenplum 5.0 database.
> This might seem like a convoluted topic to discuss on this mailing list, but
> the reason I am asking here is that Greenplum 5 is based on postgres 8.4
> and pgpointcloud requires at least postgres 9.0 it seems.
[ scratches head... ] The whole concept of extensions came in with PG 9.1.
So unless Greenplum cherry-picked that feature from later, I don't
understand how you didn't get something more like this:
=# create extension foo;
ERROR: syntax error at or near "extension"
LINE 1: create extension foo;
^
> So I am wondering:
> how does one figure out which postgres 9.0 features in particular does
> pgpointcloud depend on?
You could try feeding the extension's SQL file directly to psql (in a
scratch database so you can clean up easily). If, as is considered
good practice, it starts with something like this:
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION cube" to load this file. \quit
then you'll need to delete that; but the rest of it should be regular
SQL, and you can see what's failing.
regards, tom lane