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

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

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:

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

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.