Thanks Guillaume.
On which version of PostegreSQL have you done the test ?
If your test, as I suppose, has been done on a version of PostgreSQL more recent than 8.2.15, than this bug could only arise with older versions of PostgreSQL, and it have already been fixed (I found several references in the change log of pgAdmin regarding constraints).
Another possibility is that the pg_catalog of PostgreSQL has changed since version 8.2.15, or that Greenplum uses the pg_catalog in a different way from PostgreSQL regarding the primary key contraints.
Danilo.
Da: Guillaume Lelarge
<guillaume@lelarge.info> (
guillaume@lelarge.info)
Inviato: Domenica 8 Marzo 2015 10:42
A: Danilo Fortunato (
danilo.fortunato.2@gmail.com)
Cc: Pgadmin-support@postgresql.org (
pgadmin-support@postgresql.org)
Oggetto: Re: [pgadmin-support] Table DDL scripts generated by pgAdmin incorrectly show the constraint name using the implicit index name (on Greenplum).