Package Details: pgmodeler 3:1.0.0_alpha-1

Git Clone URL: https://aur.archlinux.org/pgmodeler.git (read-only, click to copy)
Package Base: pgmodeler
Description: PostgreSQL Database Modeler: an open source CASE tool for modeling PostgreSQL databases
Upstream URL: https://pgmodeler.io
Licenses: GPL3
Submitter: Carlinix
Maintainer: marco44
Last Packager: marco44
Votes: 47
Popularity: 0.000491
First Submitted: 2014-01-04 05:32 (UTC)
Last Updated: 2022-04-11 14:37 (UTC)

Latest Comments

marco44 commented on 2021-12-21 14:45 (UTC)

Fixed the checksum. I suppose the original 0.9.4 has been overwritten on the site, the checksum is a bit different.

Shizumi commented on 2021-11-21 18:15 (UTC) (edited on 2021-11-21 19:32 (UTC) by Shizumi)

Just an FYI, 0.9.4-beta1 more-or-less breaks enums currently (dev is aware). If you use enums in your models, stick with 0.9.3 or 0.9.4-beta for now.

https://github.com/pgmodeler/pgmodeler/issues/1588

mariano.martin commented on 2020-10-16 18:56 (UTC)

Could you please bump to v0.9.3-beta1? https://github.com/pgmodeler/pgmodeler/releases/tag/v0.9.3-beta1

lots of good stuff, also support for generated columns. Thanks!

mardiros commented on 2020-03-15 15:26 (UTC)

And now it works...

==> Creating package "pgmodeler"...
  -> Generating .PKGINFO file...
  -> Generating .BUILDINFO file...
  -> Generating .MTREE file...
  -> Compressing package...
==> Leaving fakeroot environment.
==> Finished making: pgmodeler 3:0.9.2-1 (Sun 15 Mar 2020 04:25:29 PM CET)

mardiros commented on 2020-03-15 13:12 (UTC)

I currently have an issue on my new laptop to install it (fresh archlinux install).

I've shorten some part with ... because lots of line are identicals.

make[1]: Entering directory '/home/guillaume/.cache/yay/pgmodeler/src/pgmodeler-0.9.2/crashhandler'
make[1]: Warning: File '../.qmake.stash' has modification time 2729 s in the future                                                                                                                                                                                              /usr/bin/qmake -o Makefile crashhandler.pro CONFIG+=release PREFIX=/usr CONFDIR=/etc/pgmodeler PRIVATEBINDIR=/usr/bin DOCDIR=/usr/share/doc/pgmodeler SAMPLESDIR=/usr/share/doc/pgmodeler NO_UPDATE_CHECK=AURdoesthis 'QMAKE_CXXFLAGS_RELEASE+=-march=x86-64 -mtune=generic -O2 -
pipe -fno-plt -D_FORTIFY_SOURCE=2'                                                                                                                                                                                                                                               make[1]: Warning: File '../.qmake.stash' has modification time 2729 s in the future
/usr/bin/qmake -o Makefile crashhandler.pro CONFIG+=release PREFIX=/usr CONFDIR=/etc/pgmodeler PRIVATEBINDIR=/usr/bin DOCDIR=/usr/share/doc/pgmodeler SAMPLESDIR=/usr/share/doc/pgmodeler NO_UPDATE_CHECK=AURdoesthis 'QMAKE_CXXFLAGS_RELEASE+=-march=x86-64 -mtune=generic -O2 -pipe -fno-plt -D_FORTIFY_SOURCE=2'

...

make[1]: Warning: File '../.qmake.stash' has modification time 2728 s in the future                                                                                                                                                                                              /usr/bin/qmake -o Makefile crashhandler.pro CONFIG+=release PREFIX=/usr CONFDIR=/etc/pgmodeler PRIVATEBINDIR=/usr/bin DOCDIR=/usr/share/doc/pgmodeler SAMPLESDIR=/usr/share/doc/pgmodeler NO_UPDATE_CHECK=AURdoesthis 'QMAKE_CXXFLAGS_RELEASE+=-march=x86-64 -mtune=generic -O2 -
pipe -fno-plt -D_FORTIFY_SOURCE=2'                                                                                                                                                                                                                                               make[1]: Warning: File '../.qmake.stash' has modification time 2728 s in the future                                                                                                                                                                                              

...

/usr/bin/qmake -o Makefile crashhandler.pro CONFIG+=release PREFIX=/usr CONFDIR=/etc/pgmodeler PRIVATEBINDIR=/usr/bin DOCDIR=/usr/share/doc/pgmodeler SAMPLESDIR=/usr/share/doc/pgmodeler NO_UPDATE_CHECK=AURdoesthis 'QMAKE_CXXFLAGS_RELEASE+=-march=x86-64 -mtune=generic -O2 -pipe -fno-plt -D_FORTIFY_SOURCE=2'
make[1]: Warning: File '../.qmake.stash' has modification time 2704 s in the future
/usr/bin/qmake -o Makefile crashhandler.pro CONFIG+=release PREFIX=/usr CONFDIR=/etc/pgmodeler PRIVATEBINDIR=/usr/bin DOCDIR=/usr/share/doc/pgmodeler SAMPLESDIR=/usr/share/doc/pgmodeler NO_UPDATE_CHECK=AURdoesthis 'QMAKE_CXXFLAGS_RELEASE+=-march=x86-64 -mtune=generic -O2 -pipe -fno-plt -D_FORTIFY_SOURCE=2'
make[1]: /usr/bin/qmake: Argument list too long
make[1]: *** [Makefile:244: Makefile] Error 127
make[1]: Leaving directory '/home/guillaume/.cache/yay/pgmodeler/src/pgmodeler-0.9.2/crashhandler'
make: *** [Makefile:313: sub-crashhandler-make_first-ordered] Error 2
==> ERROR: A failure occurred in build().
    Aborting...
Error making: pgmodeler


marco44 commented on 2020-03-01 07:32 (UTC)

Woops. Fixed.

gash commented on 2020-03-01 07:26 (UTC)

checksum error

pejas commented on 2018-03-23 09:36 (UTC)

Please update "Upstream URL" to https://pgmodeler.io/ current one is dead. BR

Marcel_K commented on 2017-12-17 17:58 (UTC)

My bad, sorry for the confusion: I thought you talked about a runtime error, but as you said, it's only a compile-time issue.

marco44 commented on 2017-12-17 12:13 (UTC)

What for, as that's just interesting for people recompiling ?

There is no point in recompiling for those who have a working pgmodeler, is it ?

Marcel_K commented on 2017-12-17 12:11 (UTC)

Please update pkgrel, too, you create a different package now.

marco44 commented on 2017-12-17 09:22 (UTC)

It looks like a bug in QT 5.10.

It seems other projects have the same issue:

https://github.com/QupZilla/qupzilla/issues/2515

I reported this to QT, as I couldn't find it in their bugzilla. https://bugreports.qt.io/browse/QTBUG-65251

And added duct tape in the PKGBUILD, so it should build now :)

tlvince commented on 2017-12-14 16:52 (UTC)

I'm running into the following compile error: "error: no matching function for call to ‘QToolButton::setShortcut(QLatin1String)’" https://gist.github.com/tlvince/e4e988e6a5d8caecf55d831991f54691. This is compiling against qt5 versions in extra as of today (5.10.0).

Any ideas?

marco44 commented on 2016-11-15 11:48 (UTC)

dimytch: PKGBUILD updated

dimytch commented on 2016-11-14 09:56 (UTC) (edited on 2016-11-14 09:57 (UTC) by dimytch)

PKGBUILD:36 need to be patch -p1 < ../patch_no_check_update.diff

marco44 commented on 2016-08-04 16:58 (UTC)

Well, it's this bug: https://github.com/pgmodeler/pgmodeler/issues/845 It will be fixed in next version (and is fixed in git head, so it should work with the pgmodeler-git package)

ASPIRIN commented on 2016-08-04 16:23 (UTC)

Hi cousinm, sorry, I don't know about this... I seen something similar on forums for other version...

marco44 commented on 2016-08-04 16:08 (UTC)

Hi ASPIRIN… is this bug reported upstream ?

ASPIRIN commented on 2016-08-04 15:54 (UTC) (edited on 2016-08-04 15:56 (UTC) by ASPIRIN)

For fix error (in version 0.8.2) with last comma in create table edit file "usr/local/share/pgmodeler/schemas/sql/table.sch". Replace line "%if %not {constr-sql-disabled} %then [,] $br %end" to "%if %not {constr-sql-disabled} %and {constraints} %then [,] %end"

marco44 commented on 2016-06-01 16:28 (UTC)

Hi, This message is obsolete. I forgot to remove it. I corrected this and will push this correction when there is a new pgmodeler release. For your XML error, see my message from 2016-05-02 05:59

mrechte commented on 2016-05-31 17:46 (UTC)

Hello, At package install I have the message: ==> NOTE: Please re-login to include PGMODELER in your PATH. ==> NOTE: You can load by hand with: $ source /etc/profile.d/pgmodeler.sh ;). However there is no such script in profile.d Starting pgmodeler produces: [5] src/xmlparser.cpp (198) void XMLParser::readBuffer() [ERR_LIBXMLERR] Error while interpreting XML buffer at line 0 column 0. Message generated by the parser: No declaration for attribute connect_timeout of element connection . [4] src/xmlparser.cpp (122) void XMLParser::loadXMLBuffer(const QString&) [ERR_LIBXMLERR] Error while interpreting XML buffer at line 0 column 0. Message generated by the parser: No declaration for attribute connect_timeout of element connection . [3] src/xmlparser.cpp (91) void XMLParser::loadXMLFile(const QString&) [ERR_LIBXMLERR] Error while interpreting XML buffer at line 0 column 0. Message generated by the parser: No declaration for attribute connect_timeout of element connection . [2] src/baseconfigwidget.cpp (181) void BaseConfigWidget::loadConfiguration(const QString&, std::map<QString, std::map<QString, QString> >&, const std::vector<QString>&) [ERR_LIBXMLERR] Error while interpreting XML buffer at line 0 column 0. Message generated by the parser: No declaration for attribute connect_timeout of element connection . [1] src/connectionsconfigwidget.cpp (143) virtual void ConnectionsConfigWidget::loadConfiguration() [ERR_LIBXMLERR] Error while interpreting XML buffer at line 0 column 0. Message generated by the parser: No declaration for attribute connect_timeout of element connection . [0] src/configurationform.cpp (119) void ConfigurationForm::loadConfiguration() [ERR_CONFIG_NOT_LOADED] Impossible de charger un ou plusieurs fichiers de configuration! Veuillez vérifier que les fichiers existent bien dans le dossier de configuration et qu'ils ne soient pas corrompus pour éviter que l'erreur ne se produise à nouveau au prochain lancement! Thanks

davidmcinnis commented on 2016-05-03 01:59 (UTC) (edited on 2016-05-04 02:29 (UTC) by davidmcinnis)

That got it working. Thanks, -Dave

marco44 commented on 2016-05-02 05:59 (UTC)

Hi, that's a bug in the configuration parser of pgmodeler. Edit your connections.conf and remove the connect_timeout attribute.

davidmcinnis commented on 2016-05-02 03:03 (UTC)

I ERR_LIBXMLERR at startup: http://pastebin.com/BNJs8arL

mixedCase commented on 2016-01-15 21:10 (UTC)

I did try and it didn't work. But the new build does. Thanks.

marco44 commented on 2016-01-15 10:55 (UTC)

Did you try to rebuild it ? Anyway the 0.8.2-beta is out, I'll upgrade the package

mixedCase commented on 2016-01-14 22:08 (UTC)

I'm getting this after I updated: pgmodeler: error while loading shared libraries: libpgmodeler_ui.so.1: cannot open shared object file: No such file or directory

Jauch commented on 2015-11-20 13:56 (UTC)

Ok. Apparently, problem solved. I don't know what, but I was missing something from base-devel... Reinstalling (and installing missing packages enabled the installation of pgmodeler (it is compiling at this moment) :)

marco44 commented on 2015-11-20 13:02 (UTC)

Ok, so not coming from pg_config.

Jauch commented on 2015-11-20 13:00 (UTC) (edited on 2015-11-20 13:02 (UTC) by Jauch)

pg_config BINDIR = /usr/bin DOCDIR = /usr/share/doc/postgresql HTMLDIR = /usr/share/doc/postgresql INCLUDEDIR = /usr/include PKGINCLUDEDIR = /usr/include/postgresql INCLUDEDIR-SERVER = /usr/include/postgresql/server LIBDIR = /usr/lib PKGLIBDIR = /usr/lib/postgresql LOCALEDIR = /usr/share/locale MANDIR = /usr/share/man SHAREDIR = /usr/share/postgresql SYSCONFDIR = /etc/postgresql PGXS = /usr/lib/postgresql/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/usr' '--mandir=/usr/share/man' '--datadir=/usr/share/postgresql' '--sysconfdir=/etc' '--with-gssapi' '--with-libxml' '--with-openssl' '--with-perl' '--with-python' 'PYTHON=/usr/bin/python2' '--with-tcl' '--with-pam' '--with-system-tzdata=/usr/share/zoneinfo' '--with-uuid=e2fs' '--enable-nls' '--enable-thread-safety' 'CFLAGS=-march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong' 'LDFLAGS=-Wl,-O1,--sort-common,--as-needed,-z,relro' 'CPPFLAGS=-D_FORTIFY_SOURCE=2' CC = gcc CPPFLAGS = -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong CFLAGS_SL = -fpic LDFLAGS = -L../../../src/common -Wl,-O1,--sort-common,--as-needed,-z,relro -Wl,--as-needed -Wl,-rpath,'/usr/lib',--enable-new-dtags LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgcommon -lpgport -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm VERSION = PostgreSQL 9.4.5 No where I am seeing the /usr/include/libpq folder...

Jauch commented on 2015-11-20 13:00 (UTC)

I'v been using yaourt to install. I'll try the 'classical AUR way' to see if the outcome is different anyway :)

marco44 commented on 2015-11-20 12:57 (UTC)

Is pg_config in the path (of the user you are using to compile pgmodeler). If yes, does it return the correct paths ?

Jauch commented on 2015-11-20 12:56 (UTC)

Hello. I have libpq and the headers installed. But they aren't in $PATH My $PATH is like this: /usr/local/sbin:/usr/local/bin:/usr/bin:/usr/lib/jvm/default/bin:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl The headers are in /usr/include and /usr/include/libpq and the library is in /usr/lib But adding this to $PATH do not change the error.

marco44 commented on 2015-11-20 10:40 (UTC)

Weird. I guess pgmodeler makes a call to pg_config to get information about libpq. Can you check it is in your path ?

Jauch commented on 2015-11-20 10:23 (UTC)

Hello :) Installation is failing with: ==> Starting build()... Project ERROR: libpq development package not found libpqxx and postgresql-libs are installed What am I doing wrong? :) Cheers! Jauch

marco44 commented on 2015-07-01 10:17 (UTC)

Yes, just what I told you: I had no idea there was a /usr/bin/pgmodeler and a /usr/local/bin/pgmodeler. I just uploaded a new version.

JohnRobson commented on 2015-07-01 09:54 (UTC)

I installed manually, is "/usr/local/bin/pgmodeler" and works. But when I installed this package before, was "/usr/bin/pgmodeler" and this file tried to open "/opt/pgmodeler/pgmodeler", but the folder was empty.

marco44 commented on 2015-07-01 09:03 (UTC)

(and try running directly /usr/local/bin/pgmodeler). If this works, I'll just link /usr/bin/pgmodeler to /usr/local/bin/pgmodeler)

marco44 commented on 2015-07-01 09:00 (UTC)

I think I'm starting to understand :) My path starts with /usr/local/bin, so I never use /usr/bin/pgmodeler, but /usr/local/bin/pgmodeler. Can you check that your path has /usr/bin before /usr/local/bin ?

JohnRobson commented on 2015-07-01 08:53 (UTC)

The file "/usr/bin/pgmodeler" was linked to this empty folder (/opt/pgmodeler), maybe you also need to check this file. Tks.

marco44 commented on 2015-07-01 06:16 (UTC)

/opt/pgmodeler is just a something I forgot to remove when I took over the package. It is empty, everything should go in /usr/local/bin... The beta1 has been released 17 hours ago. I'm going to upload a new version, without this empty /opt/pgmodeler.

JohnRobson commented on 2015-07-01 01:26 (UTC)

The manual installation install in these paths, not in "/opt/pgmodeler", maybe the problem is in the link to "/opt/pgmodeler" /usr/local/bin/pgmodeler /usr/local/bin/pgmodeler-cli /usr/local/lib/pgmodeler /usr/local/lib/pgmodeler/bin ... /usr/local/share/pgmodeler https://paste.debian.net/271832/

marco44 commented on 2015-05-17 08:57 (UTC)

Hi fzerorubigd, Can you tell me a bit more about this ? What are the unused files ? How did you detect them ? And what do you mean by "nothing is shown"? I can start pgmodeler here, even though I have a message warning me about a permission problem.

marco44 commented on 2015-05-17 08:55 (UTC)

Hi markusin. I can't reproduce your problem, from a fresh install. I don't even have the "Project WARNING: qmake spec does not announce the compiler family. Guessed gcc." at the beginning. There must be something peculiar with your machine, I don't know what though :(

markusin commented on 2015-05-08 09:41 (UTC)

Trying to compile pgmodeler 0.8.1_alpha1-1 using yaourt getting immediate problems: src/exception.cpp:19:24: fatal error: QApplication: No such file or directory Full error log is: http://pastebin.com/t29qAJf6 Do I need to modify something in PKGBUILD?

fzerorubigd commented on 2015-05-07 11:22 (UTC)

some un-used file inside this package. and also after upgrading to alpha-1, nothing is shown after executing the app.

marco44 commented on 2015-03-04 13:52 (UTC)

Took over this orphaned package, and upgraded to 0.8.0

marco44 commented on 2015-03-02 16:05 (UTC)

0.8.0 is out.

marco44 commented on 2015-02-19 17:00 (UTC)

It seems this bug is solved in git: https://github.com/pgmodeler/pgmodeler/pull/545

fzerorubigd commented on 2015-02-19 16:19 (UTC)

Exact same problem with @rkmax , any idea?

rkmax commented on 2015-02-10 19:21 (UTC)

Error on build() src/relationshipwidget.cpp: En el constructor ‘RelationshipWidget::RelationshipWidget(QWidget*)’: src/relationshipwidget.cpp:164:13: error: ambiguous overload for ‘operator=’ (operand types are ‘QStringList’ and ‘<lista inicializador dentro de llaves>’) tab_labels={ "", rel_attribs_tbw->tabText(ATTRIBUTES_TAB), rel_attribs_tbw->tabText(CONSTRAINTS_TAB), ^ src/relationshipwidget.cpp:164:13: nota: los candidatos son: In file included from /usr/include/qt/QtCore/qvariant.h:44:0, from /usr/include/qt/QtCore/qvariantanimation.h:40, from /usr/include/qt/QtCore/qpropertyanimation.h:37, from /usr/include/qt/QtCore/QtCore:8, from /usr/include/qt/QtWidgets/QtWidgetsDepends:3, from /usr/include/qt/QtWidgets/QtWidgets:3, from src/baseobjectwidget.h:28, from src/relationshipwidget.h:28, from src/relationshipwidget.cpp:19: /usr/include/qt/QtCore/qstringlist.h:66:18: nota: QStringList& QStringList::operator=(const QList<QString>&) QStringList &operator=(const QList<QString> &other) ^ /usr/include/qt/QtCore/qstringlist.h:69:18: nota: QStringList& QStringList::operator=(QList<QString>&&) QStringList &operator=(QList<QString> &&other) ^ /usr/include/qt/QtCore/qstringlist.h:53:7: nota: QStringList& QStringList::operator=(const QStringList&) class QStringList : public QList<QString> ^ /usr/include/qt/QtCore/qstringlist.h:53:7: nota: QStringList& QStringList::operator=(QStringList&&) Makefile:10221: fallo en las instrucciones para el objetivo 'obj/relationshipwidget.o' make[1]: *** [obj/relationshipwidget.o] Error 1 make[1]: se sale del directorio '/tmp/yaourt-tmp-julian/aur-pgmodeler/src/pgmodeler-0.8.0-beta/libpgmodeler_ui' Makefile:267: fallo en las instrucciones para el objetivo 'sub-libpgmodeler_ui-make_first-ordered' make: *** [sub-libpgmodeler_ui-make_first-ordered] Error 2

ffuugoo commented on 2014-10-18 16:55 (UTC)

Oh, man, I'm sorry. I got previous email, put it on a list, and... completely forgot about it. Will do it in a minutes. :3

marco44 commented on 2014-10-18 16:39 (UTC)

Hi, nothing to do for alpha2, except change version and update md5sum…

marco44 commented on 2014-10-09 07:31 (UTC)

alpha2 is out :)

Cif commented on 2014-08-15 22:05 (UTC)

Thanks cousinm, that hint helps :)

marco44 commented on 2014-08-08 07:47 (UTC)

Ok, found the cause of /usr/lib/qt/bin/uic: symbol lookup error: /usr/lib/qt/bin/uic: undefined symbol: _ZN7QString13toUtf8_helperERKS_ It's because of /etc/profile.d/pgmodeler.sh of previous package... uic was dynamically linking to pgmodeler libs instead of QT libs, which put this mess. I uninstalled the previous pgmodeler, and unset LD_LIBRARY_PATH, and I could compile.

ffuugoo commented on 2014-07-28 15:19 (UTC)

Hi, Cif. As I cannot reproduse it at all, I tried to google your error, but unfortunatelly I found nothing, that could help me to help you. You, probably, should open an issue in pgmodeler tracker: https://github.com/pgmodeler/pgmodeler/issues. Sorry. :/

Cif commented on 2014-07-25 11:36 (UTC)

Got this error while building: /usr/lib/qt/bin/uic: symbol lookup error: /usr/lib/qt/bin/uic: undefined symbol: _ZN7QString13toUtf8_helperERKS_

ffuugoo commented on 2014-07-23 21:27 (UTC)

Thx, geosam. :3

geosam commented on 2014-07-23 19:44 (UTC)

PKGBUILD of version 0.8.0-alpha, is: https://gist.github.com/samtux/3eb62ab49b77bab54588

marco44 commented on 2014-06-06 14:11 (UTC)

Hi, This package has been out of date for a very long time now. Could you upgrade it ? (or orphan it, but upgrading it would be much cooler :) )

dimytch commented on 2014-04-11 17:28 (UTC)

curl: (22) The requested URL returned error: 404 Not Found Actual download point for source packages now is https://github.com/pgmodeler/pgmodeler/releases

Carlinix commented on 2014-04-02 23:35 (UTC)

In Response to edoantonioco: Yes, the update is comming soon, I need to test some improvements and suggestions (by marsam).

edoantonioco commented on 2014-04-02 23:16 (UTC)

Is this going to be updated?

marsam commented on 2014-02-09 16:21 (UTC)

Hi, thanks for packaging pgmodeler. I just want to suggest to don't include `pgmodeler.vas', because it sets $LD_LIBRARY_PATH [1] globally, and this, is REALLY A BAD PRACTICE[2][3], and currently breaks all the packages which use qt-base. PD: I'm going to file and issue in pgmodeler, but I think you should fix the PKGBUILD. Greetings. [1] https://github.com/pgmodeler/pgmodeler/blob/master/pgmodeler.vars#L29 [2] http://www.cc.dtu.dk/?page_id=304 [3] http://xahlee.info/UnixResource_dir/_/ldpath.html