PGAdmin3 v1.22.1

Ivan Novick

unread,

Mar 2, 2016, 4:38:04 AM3/2/16

to Greenplum Users

pgAdmin3 v 1.22.1, just released, has fixes to prevent warning messages when logging into GPDB.

Thank you Andreas Scherbaum for doing the patches and getting them accepted!

Cheers,

Ivan

Tim tim

unread,

Mar 3, 2016, 5:33:41 AM3/3/16

to Greenplum Users

Awesome! Thanks

среда, 2 марта 2016 г., 12:38:04 UTC+3 пользователь inovick написал:

Danilo Fortunato

unread,

Mar 5, 2016, 5:37:27 AM3/5/16

to gpdb-...@greenplum.org

A note for the users of Greenplum Database 4.2.
Obviously this does not affect the open source version of Greenplum Database.

Unfortunately versions 1.22.0 and 1.22.1 of pgAdmin III introduce a regression with Greenplum Database 4.2:

An error has occurred:

ERROR: function pg_get_function_result(oid) does not exist
LINE1: SELECT pr.oid, pr.xmin, pr.*, pg_get_function_result(pr.oid)...
^
HINT: No function matches the given name and argument types. You
may need to add explicit type casts.

pg_get_function_result was added in PostgreSQL 8.4, and it does not exist on Greenplum Database 4.2, which is based on PostgreSQL 8.2.15.

Users of Greenplum Database 4.2 can use pgAdmin 1.20.0 without any issue.

Regards,
Danilo

Da: Ivan Novick (ino...@pivotal.io)
Inviato: Mercoledì 2 Marzo 2016 10:38
A: Greenplum Users (gpdb-...@greenplum.org)
Oggetto: [gpdb-users] PGAdmin3 v1.22.1

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.
To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

Ivan Novick

unread,

Mar 5, 2016, 8:10:58 AM3/5/16

to Danilo Fortunato, Greenplum Users

Hi Danilo,

GPDB 4.2 is fully out of date and unsupported in favor of GPDB 4.3. Do you see the same issue with 4.3?

Cheers,

Ivan

Danilo Fortunato

unread,

Mar 5, 2016, 3:57:14 PM3/5/16

to Ivan Novick, Greenplum Users

Ivan,
I'm aware that GPDB 4.2 is out of support.
I haven't had the opportunity to use pgAdmin with GPDB 4.3 yet, but I believe I'll have it soon.

Regards,
Danilo

Da: Ivan Novick (ino...@pivotal.io)

Inviato: Sabato 5 Marzo 2016 14:10
A: Danilo Fortunato (danilo.fo...@gmail.com)
Cc: Greenplum Users (gpdb-...@greenplum.org)
Oggetto: Re: [gpdb-users] PGAdmin3 v1.22.1

Keaton Adams

unread,

Mar 5, 2016, 4:52:37 PM3/5/16

to Greenplum Users, ino...@pivotal.io

Hi Danilo,

The GPDB 4.2.x release reached end of general support on 2015-09-30. The support schedule for all Pivotal products can be found here:

https://support.pivotal.io/hc/en-us/articles/201143553-GPDB-software-End-of-Life-Cycle-EOL-policy

https://pivotal.io/support/lifecycle_policy

http://d1fto35gcfffzn.cloudfront.net/support/PivotalLifecycleMatrix.pdf

Thanks,

Keaton

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.

To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.

Cyrille Lintz

unread,

Mar 7, 2016, 3:26:14 AM3/7/16

to Keaton Adams, Greenplum Users, Ivan Novick

Hi,

On my VM with GPDB 4.3.7.0, I got the same error message:

Regards,

Cyrille

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

Andreas Scherbaum

unread,

Mar 7, 2016, 12:08:51 PM3/7/16

to Cyrille Lintz, Keaton Adams, Greenplum Users, Ivan Novick

Hi Cyrille,

how exactly can I reproduce this error? I tested pgAdminIII with the changes on GPDB and on HAWQ and I haven't seen this error on GPDB.

Regards,

Andreas

Andreas Scherbaum

Principal Software Engineer

GoPivotal Deutschland GmbH

Hauptverwaltung und Sitz: Am Kronberger Hang 2a, 65824 Schwalbach/Ts., Deutschland

Amtsgericht Königstein im Taunus, HRB 8433

Geschäftsführer: Andrew Michael Cohen, Paul Thomas Dacier

Danilo Fortunato

unread,

Mar 7, 2016, 4:37:05 PM3/7/16

to gpdb-...@greenplum.org

Andreas,
I suppose this error is shown as soon as you connect to GPDB, when pgAdmin tries to build the list of all database objects.

Which version of GPDB did you use in your tests ?

Does the pg_get_function_result(oid) exist in the GPDB you used in your tests ?

This can be verified by connecting with psql, getting the oid of any function:
select oid, * from pg_proc limit 10;
and trying to execute the function:
select pg_get_function_result(<nnnnn>);

Regards,
Danilo

Da: Andreas Scherbaum (asche...@pivotal.io)
Inviato: Lunedì 7 Marzo 2016 18:08
A: Cyrille Lintz (cli...@pivotal.io)
Cc: Keaton Adams, Greenplum Users, Ivan Novick (kad...@pivotal.io, gpdb-...@greenplum.org, ino...@pivotal.io)

Cyrille Lintz

unread,

Mar 7, 2016, 5:09:49 PM3/7/16

to Andreas Scherbaum, Keaton Adams, Greenplum Users, Ivan Novick

Hi Andreas,

I get this error when I navigate in the PgAdmin3 browser:

1. Click on a DB

2. Click on a schema

==> you will get the same error message

Regards,

Cyrille

Dante

unread,

Apr 25, 2016, 10:05:24 PM4/25/16

to Greenplum Users

Hi Everybody,
am new to the group.

IHave just installed pgadmin3 v1.22.1, on CentOS 7 with GPDB 4.3.7.3 build 2, and am getting the same error message.
Is there any update on this?

Thanks in advance

Danilo Fortunato

unread,

Apr 26, 2016, 5:24:08 PM4/26/16

to gpdb-...@greenplum.org

Dante,
I'm not aware of any update on this issue.
At the moment the best option with GPDB is to use pgAdmin 1.20.0.

Regards,
Danilo Fortunato

Da: Dante (dac.ma...@gmail.com)
Inviato: Martedì 26 Aprile 2016 04:05
A: Greenplum Users (gpdb-...@greenplum.org)
Oggetto: [gpdb-users] Re: PGAdmin3 v1.22.1

--

张义

unread,

Jun 16, 2016, 11:36:26 PM6/16/16

to Greenplum Users

I cannot create a function throuth pgadmin 3 sunccessfully. How should I handle this? thanks

在 2016年4月27日星期三 UTC+8上午5:24:08，Danilo Fortunato写道：

Andreas Scherbaum

unread,

Jun 17, 2016, 5:57:18 AM6/17/16

to 张义, Greenplum Users

Hello,

can you please describe the exact problem, and attach screenshots of the function window and the error message you see?