Thread: Visual Modeling programs
Anyone know of any visual modelling apps (like CA's ERWin ) that work well with pg? I Have been using erwin but just discovered it isn't creating my pk, fk or unique constraints. I am using the odbc v3.0 target repository option in erwin. Thanks, Morgan
TheKompany is going to release a new program called "Data Architect". It will be released this month. Looks pretty decent, check out: http://www.thekompany.com/products/dataarchitect/index.php3?dhtml_ok=1 -Ryan Mahoney At 04:27 PM 7/12/01 -0400, Morgan Curley wrote: >Anyone know of any visual modelling apps (like CA's ERWin ) that work well >with pg? >I Have been using erwin but just discovered it isn't creating my pk, fk or >unique constraints. >I am using the odbc v3.0 target repository option in erwin. > >Thanks, >Morgan > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
> Anyone know of any visual modelling apps (like CA's ERWin ) that work well > with pg? > I Have been using erwin but just discovered it isn't creating my pk, fk or > unique constraints. > I am using the odbc v3.0 target repository option in erwin. Dbdesigner. Open source. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> Anyone know of any visual modelling apps (like CA's ERWin ) that work well > with pg? > I Have been using erwin but just discovered it isn't creating my pk, fk or > unique constraints. > I am using the odbc v3.0 target repository option in erwin. Dbdesigner. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Hi, There are a few tools which may do this for you, listed at : http://techdocs.postgresql.org/oresources.php#erdtools Hope they are useful. :) Regards and best wishes, Justin Clift Bruce Momjian wrote: > > > Anyone know of any visual modelling apps (like CA's ERWin ) that work well > > with pg? > > I Have been using erwin but just discovered it isn't creating my pk, fk or > > unique constraints. > > I am using the odbc v3.0 target repository option in erwin. > > Dbdesigner. Open source. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
Morgan Curley wrote: > > Anyone know of any visual modelling apps (like CA's ERWin ) that work well > with pg? > I Have been using erwin but just discovered it isn't creating my pk, fk or > unique constraints. > I am using the odbc v3.0 target repository option in erwin. Morgan, I had some success using ERWin with pgsql for ER diagrams. Details are hazy now, but try telling ERwin it is an Informix schema. I was importing (from a sql dump, not via odbc). Regards, Ed Loehr
It looks like they aren't quite ready for a full release yet, and may not even be ready to save changes made to the table schema, based on what I read at http://dbdesigner.sourceforge.net/. It does look promising though. Bruce Momjian <pgman%candle.pha.pa.us@interlock.lexmark.com> on 07/12/2001 05:39:29 PM To: Morgan Curley <mcurley%e4media.com@interlock.lexmark.com> cc: pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley Sheldahl/Lex/Lexmark) Subject: Re: [GENERAL] Visual Modeling programs > Anyone know of any visual modelling apps (like CA's ERWin ) that work well > with pg? > I Have been using erwin but just discovered it isn't creating my pk, fk or > unique constraints. > I am using the odbc v3.0 target repository option in erwin. Dbdesigner. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Is it possible for the COPY command to warn about duplicate key violations (and not insert them...) but still proceed inserting the rows that do not cause a violation? If not, what is the quickest way to deal with this problem? TIA! -Ryan Mahoney --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
On Fri, Jul 13, 2001 at 09:40:24AM -0400, Ryan Mahoney <ryan@paymentalliance.net> wrote: > Is it possible for the COPY command to warn about duplicate key violations > (and not insert them...) but still proceed inserting the rows that do not > cause a violation? If not, what is the quickest way to deal with this problem? You could copy the data into a temporary table and then insert just run record from a set with the same key into the real table.
On Fri, Jul 13, 2001 at 11:01:28AM -0500, Bruno Wolff III <bruno@wolff.to> wrote: > On Fri, Jul 13, 2001 at 09:40:24AM -0400, > Ryan Mahoney <ryan@paymentalliance.net> wrote: > > Is it possible for the COPY command to warn about duplicate key violations > > (and not insert them...) but still proceed inserting the rows that do not > > cause a violation? If not, what is the quickest way to deal with this problem? > > You could copy the data into a temporary table and then insert just > run record from a set with the same key into the real table. As Ryan pointed out to me, I bolixed up the grammer in my response. You can do want you want using copy to load a temporary table that doesn't have a unique key constraint and then use insert to insert data from a select on the temporary table using the distinct on clause to pick one record from a set of records with the same key.