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

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
>