pgmodeler ?

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

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
--
Olivier Gautherot
https://www.linkedin.com/in/ogautherot/

<https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail&gt;
Libre
de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail&gt;
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

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

https://dba.stackexchange.com/questions/238903/postgresql-11-error-column-p-proisagg-does-not-exist

The application (pgmodeler) should be fixed.

Regards

Pavel

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

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