Re: FREE ERD TOOL for POSTGRES ??? - Mailing list pgsql-general

Hi Eric,

There is also a list of ERD Tools which work with PostgreSQL at :

http://techdocs.postgresql.org/oresources.php#erdtools

:-)

Regards and best wishes,

Justin Clift


Nick Fankhauser wrote:
>
> If you have the primary & foreign key constraints set up, dbvisualizer works
> nicely. You'll need to have a JVM & the jdbc driver on your workstation, and
> set up the database for tcp/ip access. (Al of which is much simpler than it
> sounds.)
>
> -NickF
>
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Eric Webber
> > Sent: Monday, March 04, 2002 12:02 PM
> > To: lxp-general@commandprompt.com; pgsql-general@postgresql.org
> > Subject: [GENERAL] FREE ERD TOOL for POSTGRES ???
> >
> >
> > ERD tool for POSTGRES
> >
> > I checked the FAQ on this and was wondering what is the most
> > easy to use ERD tool for POSTGRES, that is free, and can print
> > out a diagram of the data model.  I liked ERWIN in the past
> > but not sure it works with POSTGRES.  A tool with Round Trip
> > engineering would be nice, but most important concern right now
> > is simply being able to print out diagram of model and not have
> > to install a ton of software to do it.
> >
> > warmest regards,
> >
> > Eric Sean Webber
> >
> >
> > ---- On 22 Feb 2002 04:31:11, Joshua Drake (jd@commandprompt.com) wrote:
> >
> > > Hello,
> > >
> > > Just use an HTML form to post the data. Then use the include statement
> > > and variables.
> > >
> > >
> > > J
> > > On Thu, 2002-02-21 at 16:26, Eric Webber wrote:
> > > >
> > > >
> > > > Lets say I just want to update a record,
> > > > how would I do that with LXP, I have gotten
> > > > selects to work fine with the include, but what is the
> > > > way to do updates, inserts and deletes ?
> > > > do I have to do anything special ?
> > > >
> > > > regards,
> > > >
> > > > Eric Sean Webber
> > > >
> > > >
> > > >
> > > > ________________________________________________
> > > > Get your own "800" number
> > > > Voicemail, fax, email, and a lot more
> > > > http://www.ureach.com/reg/tag
> > > >
> > > >
> > > > ---- On Thu, 21 Feb 2002, Joshua D. Drake (jd@commandprompt.com)
> > > wrote:
> > > >
> > > > > > RedHat 2.4.7-10 #1 to be exact.
> > > > > >
> > > > >
> > > > > Well first upgrade to the 2.4.9 kernel of redhat if you can :)
> > > > >
> > > > > > Now the problem is Error 6: Connection
> > > > > > to persistent SQL database failed.
> > > > >
> > > > > This sounds like the database LXP is looking for has not been
> > > created in
> > > > > PostgreSQL..
> > > > >
> > > > > John?
> > > > >
> > > > >
> > > > > >
> > > > > > this despite the sql_example select statement
> > > > > > working fine manually via psql client.
> > > > > >
> > > > > > not sure what is wrong now.
> > > > > >
> > > > > > tried just about everything I could
> > > > > > think of in the lxp.conf file, and restarted
> > > > > > httpd each time after changing lxp.conf,
> > > > > > and still cannot get sql_example.lxp to
> > > > > > work.
> > > > > >
> > > > > > regards,
> > > > > >
> > > > > > Eric Sean Webber
> > > > > >
> > > > > > ________________________________________________
> > > > > > Get your own "800" number
> > > > > > Voicemail, fax, email, and a lot more
> > > > > > http://www.ureach.com/reg/tag
> > > > > >
> > > > > >
> > > > > > ---- On Wed, 20 Feb 2002, John Worsley (jlx@commandprompt.com)
> > > wrote:
> > > > > >
> > > > > > > On Wed, 20 Feb 2002, Eric Webber wrote:
> > > > > > > >used the install script.
> > > > > > > >Everything is as you indicate below
> > > > > > > >except the exact line it used was:
> > > > > > > >
> > > > > > > ><IfDefine HAVE_PYTHON>
> > > > > > > >LoadModule python_module      modules/mod_python.so
> > > > > > > >LoadModule lxp_module         lib/apache/liblxp.so
> > > > > > > ></IfDefine>
> > > > > > > >
> > > > > > > >why it put it there I have no idea, also
> > > > > > > >the there is no libexec like in yours.
> > > > > > >
> > > > > > > Yes, this is what I was afraid of:  you're using RH 7.x, right?
> > > ;)
> > > > > > For
> > > > > > > some reason, their apxs distribution installs things a bit
> > > > > > peculiarly.
> > > > > > >
> > > > > > > Just change that block to:
> > > > > > >
> > > > > > > <IfDefine HAVE_PYTHON>
> > > > > > > LoadModule python_module      modules/mod_python.so
> > > > > > > </IfDefine>
> > > > > > > LoadModule lxp_module         lib/apache/liblxp.so
> > > > > > >
> > > > > > > I think in the future we're just going to manually modify this
> > > file
> > > > > > > rather
> > > > > > > than trust apxs. ;)
> > > > > > >
> > > > > > > Regards,
> > > > > > > Jw.
> > > > > > > --
> > > > > > > John Worsley - Lead Programmer / Web Developer, Command Prompt,
> > > Inc.
> > > > > > > TheLinuxReview | Resources for Linux Users |
> > > > > > > http://www.thelinuxreview.com/
> > > > > > > (503) 736-4609 | jlx@commandprompt.com |
> > > > > > webmaster@thelinuxreview.com
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > lxp-general mailing list
> > > > > > > lxp-general@commandprompt.com
> > > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general
> > > > > > >
> > > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > lxp-general mailing list
> > > > > > lxp-general@commandprompt.com
> > > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general
> > > > > >
> > > > >
> > > > > --
> > > > > --
> > > > > <COMPANY>CommandPrompt  - http://www.commandprompt.com  </COMPANY>
> > > > > <PROJECT>TheLinuxReview - http://www.TheLinuxReview.com </PROJECT>
> > > > > <WEBMASTER>LDP          - http://www.linuxdoc.org       </WEBMASTER>
> > > > > --
> > > > >
> > > > > _______________________________________________
> > > > > lxp-general mailing list
> > > > > lxp-general@commandprompt.com
> > > > > https://secure.linuxports.com/mailman/listinfo/lxp-general
> > > > >
> > > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> > ________________________________________________
> > Get your own "800" number
> > Voicemail, fax, email, and a lot more
> > http://www.ureach.com/reg/tag
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi