Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgmodeler ?

pgmodeler ?

From
stan
Date:
I apologize, as this is a bit off topic for this list.

pgmodeler got mention in a thread that I started a day or two ago, and it looks
like it might be very  useful

I am running on Ubuntu 18.04 (latest STABLE), and I found that there is a package,
which I downloaded. The idea is to import the project I am working on.

But, when I try to import it I get an error message about:

t says that the column pr.proisaag.

I don't want to spend a lot of time trying to get this package to work, if it is a
dead end. I am using Postgres 11 if that matters.

Has anyone gotten this to work If so, can anyone point me to a quick HOWTO to
import my existing project?


Thanks in advance.
-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin

Re: pgmodeler ?

From
stan
Date:
On Sun, Sep 01, 2019 at 06:30:23AM -0400, stan wrote:
> I apologize, as this is a bit off topic for this list.
> 
> pgmodeler got mention in a thread that I started a day or two ago, and it looks
> like it might be very  useful
> 
> I am running on Ubuntu 18.04 (latest STABLE), and I found that there is a package,
> which I downloaded. The idea is to import the project I am working on.
> 
> But, when I try to import it I get an error message about:
> 
> t says that the column pr.proisaag.
> 
> I don't want to spend a lot of time trying to get this package to work, if it is a
> dead end. I am using Postgres 11 if that matters.
> 
> Has anyone gotten this to work If so, can anyone point me to a quick HOWTO to
> import my existing project?
> 
This is the specific error message:

Could not execute the SQL command.
Message returned: ERROR: column pr.proisagg does not exist
LINE 1: ...namespace AS ns ON pr.pronamespace = ns.oid WHERE pr.proisag...
^
HINT: Perhaps you meant to reference the column

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin

Re: pgmodeler ?

From
Olivier Gautherot
Date:
On Sun, Sep 1, 2019 at 6:35 AM stan <stanb@panix.com> wrote:
On Sun, Sep 01, 2019 at 06:30:23AM -0400, stan wrote:
> I apologize, as this is a bit off topic for this list.
>
> pgmodeler got mention in a thread that I started a day or two ago, and it looks
> like it might be very  useful
>
> I am running on Ubuntu 18.04 (latest STABLE), and I found that there is a package,
> which I downloaded. The idea is to import the project I am working on.
>
> But, when I try to import it I get an error message about:
>
> t says that the column pr.proisaag.
>
> I don't want to spend a lot of time trying to get this package to work, if it is a
> dead end. I am using Postgres 11 if that matters.
>
> Has anyone gotten this to work If so, can anyone point me to a quick HOWTO to
> import my existing project?
>
This is the specific error message:

Could not execute the SQL command.
Message returned: ERROR: column pr.proisagg does not exist
LINE 1: ...namespace AS ns ON pr.pronamespace = ns.oid WHERE pr.proisag...
^
HINT: Perhaps you meant to reference the column

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin

Can you confirm the versions of pgModeler and PG? Pgmodeler 0.91 does not fully support PG 11.x and there is an update in preparation in 0.92 which should. You may want to givi it a try.

Cheers

Libre de virus. www.avast.com

Re: pgmodeler ?

From
Pavel Stehule
Date:
Hi

ne 1. 9. 2019 v 12:35 odesílatel stan <stanb@panix.com> napsal:
On Sun, Sep 01, 2019 at 06:30:23AM -0400, stan wrote:
> I apologize, as this is a bit off topic for this list.
>
> pgmodeler got mention in a thread that I started a day or two ago, and it looks
> like it might be very  useful
>
> I am running on Ubuntu 18.04 (latest STABLE), and I found that there is a package,
> which I downloaded. The idea is to import the project I am working on.
>
> But, when I try to import it I get an error message about:
>
> t says that the column pr.proisaag.
>
> I don't want to spend a lot of time trying to get this package to work, if it is a
> dead end. I am using Postgres 11 if that matters.
>
> Has anyone gotten this to work If so, can anyone point me to a quick HOWTO to
> import my existing project?
>
This is the specific error message:

Could not execute the SQL command.
Message returned: ERROR: column pr.proisagg does not exist
LINE 1: ...namespace AS ns ON pr.pronamespace = ns.oid WHERE pr.proisag...
^
HINT: Perhaps you meant to reference the column

looks like pgmodeler doesn't support  PostgreSQL 11. proisagg was replaced by prokind column


The application (pgmodeler) should be fixed.

Regards

Pavel
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


Re: pgmodeler ?

From
Thiemo Kellner
Date:

Quoting Olivier Gautherot <ogautherot@gautherot.net>:

This is the specific error message:

Could not execute the SQL command.
Message returned: ERROR: column pr.proisagg does not exist
LINE 1: ...namespace AS ns ON pr.pronamespace = ns.oid WHERE pr.proisag...
^
HINT: Perhaps you meant to reference the column

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin
 
Can you confirm the versions of pgModeler and PG? Pgmodeler 0.91 does not fully support PG 11.x and there is an update in preparation in 0.92 which should. You may want to givi it a try.
 
Actually, this is a known problem: https://github.com/pgmodeler/pgmodeler/issues/1281

Maybe you want to give the beta a shot: https://pgmodeler.io/download

Kind regards

Thiemo
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id: B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B
Attachment

Re: pgmodeler ?

From
Tony Shelver
Date:

<<<<<<<<<<<<<<<<<<<<<<
On Sun, 1 Sep 2019 at 13:45, Thiemo Kellner <thiemo@gelassene-pferde.biz> wrote:

Quoting Olivier Gautherot <ogautherot@gautherot.net>:

This is the specific error message:

Could not execute the SQL command.
Message returned: ERROR: column pr.proisagg does not exist
LINE 1: ...namespace AS ns ON pr.pronamespace = ns.oid WHERE pr.proisag...
^
HINT: Perhaps you meant to reference the column

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin
 
Can you confirm the versions of pgModeler and PG? Pgmodeler 0.91 does not fully support PG 11.x and there is an update in preparation in 0.92 which should. You may want to givi it a try.
 
Actually, this is a known problem: https://github.com/pgmodeler/pgmodeler/issues/1281

Maybe you want to give the beta a shot: https://pgmodeler.io/download
>>>>>>>>>>>>>>
I built 9.2 beta and have beeen using it quite successfully against pg11 for a while