Re: [GENERAL] tool for DB design

2005-12-05 Thread William Bug
Hi Nikolay,Were you able to get any closer to your objective on this email thread?I spent quite a bit of time researching the web on this question back in June - Is there an Open Source option for doing "round trip" data modeling for PostgreSQL?As far as the E-R or UML diagramming, Dia and Umbrello

Re: [GENERAL] Inheritance vs. LIKE - need advice

2005-08-10 Thread William Bug
Once again, many many thanks Jeff for taking the time to think through these issues and provide your well-informed comments & opinions! On Aug 10, 2005, at 4:09 PM, Jeff Davis wrote: William Bug wrote: As you say, both LIKE & INHERIT are a bit anemic and unnecessary, since w

[GENERAL] Inheritance vs. LIKE - need advice

2005-08-04 Thread William Bug
Hi All, Sorry to bring up the topic of PostgreSQL inheritance again, but after going through the archives and Google results, I still don't have a clear sense of whether my plan to implement a schema I'm working on is the preferred way to go. First, I'd like to find out if the way I'm thi

[GENERAL] Inheritance vs. LIKE - need advice

2005-08-01 Thread William Bug
Dear pgsql-general moderators, I sent this post out over the weekend. Is there a reason why it is not getting posted to the list? Many thanks for your assistance. I really need some advice on this issue from people with experience using both inheritance mechanisms in PostgreSQL. Cheers,

Re: [GENERAL] Tool for database design documentation?

2005-07-31 Thread William Bug
I use a combination of the gnome-based diagraming application Dia (http://www.gnome.org/projects/dia/) and the tedia2sql diagram-to-DDL SQL translation script, which is written in Perl (http://tedia2sql.tigris.org/).It's a bit awkward, but:    1) Dia is a wonderful, open source diagramming tool I c