From kyle@actarg.com Tue Jun  27 15:22:49 2006
X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id E7FEB9FA5E6
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Jun 2006 12:22:49 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 07581-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Jun 2006 12:22:40 -0300 (ADT)
X-Greylist: delayed 14:52:15.137993 by SQLgrey-
Received: from tao.actarg.com (host25.actarg.com [209.180.91.25])
	by postgresql.org (Postfix) with ESMTP id 5D8EF9FA50D
	for <pgsql-sql@postgresql.org>; Tue, 27 Jun 2006 12:22:39 -0300 (ADT)
Received: from [192.168.2.5] (chi.actarg.com [192.168.2.5])
	by tao.actarg.com (8.13.1/8.13.1) with ESMTP id k5RFMFNT022495;
	Tue, 27 Jun 2006 09:22:15 -0600
Message-ID: <44A14D27.90301@actarg.com>
Date: Tue, 27 Jun 2006 09:22:15 -0600
From: Kyle Bateman <kyle@actarg.com>
User-Agent: Mozilla Thunderbird 1.0.6-1.1.fc3 (X11/20050720)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: phatcher@macys.com
CC: josh@agliodbs.com, pgsql-sql@postgresql.org
Subject: Schema management tool
Content-Type: multipart/alternative;
	boundary="------------030507050203050304000200"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/286
X-Sequence-Number: 25522

This is a multi-part message in MIME format.
--------------030507050203050304000200
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I just saw this very old post and thought I'd respond for the benefit of 
the list:

Patrick,

> Could someone give me some advice or point me to an article that would help
> manage views?  I have a view that I use in conjunction with other views,
> and since I have to drop the view and then recreate it, I'm force to drop
> and recreate all other views that the original view was used in.
> TIA

As I recall, the IT staff at Action Target, Inc. two years ago developed a 
non-free tool for this purpose.   They were planning to start a spin-off 
company to market PostgreSQL admin tools, but I don't know how far they got 
with the idea.   

Try contacting Action Target's webmaster to see if you can find anything out:
webmaster ( at ) actiontarget ( dot ) com



We have a free (GPL) tool called "wyseman" that is a framework for 
authoring schemas in postgres.  You create a meta-sql structure for each 
database object you want in the database.  Then you call wyseman to drop 
and/or re-create the object, along with all its dependencies.

This is a great tool for working on a live database.  You can maintain a 
pristine, authoritative definition of your schema, and still migrate 
your live database along as you make changes to the design.  When you 
want to modify a section of the schema that is deep within the tree of 
dependencies, wyseman will take care of dropping, rebuilding, and 
granting permissions on all the necessary objects in order to get into 
the part you want to change.

Wyseman also takes care of building a "data dictionary" where you can 
query for things like printable titles, and pop-up helps for tables and 
columns in multiple languages.  This is a nice layer to put on top of 
postgres and just under your ERP.

These tools are accessible on wyatterp.com.  Due to lack of time, I have 
not kept current software in the download area.  We are using much later 
stuff in-house.  But I would be happy to share more recent versions if 
there is any interest out there.  It would be particularly helpful if 
anyone were willing to help maintain the website and (currently a sad 
excuse for) documentation.

There is also a run-time library (wylib) for rapid construction of ERP 
applications.  We have about 30 applications built in the framework that 
run our entire business.

Kyle Bateman
Action Target Inc.


--------------030507050203050304000200
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
I just saw this very old post and thought I'd respond for the benefit
of the list:<br>
<br>
<pre><font face="Arial, Helvetica, sans-serif">Patrick,

&gt; Could someone give me some advice or point me to an article that would help
&gt; manage views?  I have a view that I use in conjunction with other views,
&gt; and since I have to drop the view and then recreate it, I'm force to drop
&gt; and recreate all other views that the original view was used in.
&gt; TIA

As I recall, the IT staff at Action Target, Inc. two years ago developed a 
non-free tool for this purpose.   They were planning to start a spin-off 
company to market PostgreSQL admin tools, but I don't know how far they got 
with the idea.   

Try contacting Action Target's webmaster to see if you can find anything out:
webmaster ( at ) actiontarget ( dot ) com</font></pre>
<br>
<br>
We have a free (GPL) tool called "wyseman" that is a framework for
authoring schemas in postgres.&nbsp; You create a meta-sql structure for
each database object you want in the database.&nbsp; Then you call wyseman
to drop and/or re-create the object, along with all its dependencies.<br>
<br>
This is a great tool for working on a live database.&nbsp; You can maintain
a pristine, authoritative definition of your schema, and still migrate
your live database along as you make changes to the design.&nbsp; When you
want to modify a section of the schema that is deep within the tree of
dependencies, wyseman will take care of dropping, rebuilding, and
granting permissions on all the necessary objects in order to get into
the part you want to change.<br>
<br>
Wyseman also takes care of building a "data dictionary" where you can
query for things like printable titles, and pop-up helps for tables and
columns in multiple languages.&nbsp; This is a nice layer to put on top of
postgres and just under your ERP.<br>
<br>
These tools are accessible on wyatterp.com.&nbsp; Due to lack of time, I
have not kept current software in the download area.&nbsp; We are using much
later stuff in-house.&nbsp; But I would be happy to share more recent
versions if there is any interest out there.&nbsp; It would be particularly
helpful if anyone were willing to help maintain the website and
(currently a sad excuse for) documentation.<br>
<br>
There is also a run-time library (wylib) for rapid construction of ERP
applications.&nbsp; We have about 30 applications built in the framework
that run our entire business.<br>
<br>
Kyle Bateman<br>
Action Target Inc.<br>
<br>
</body>
</html>

--------------030507050203050304000200--



From josh@agliodbs.com Tue Jun  27 16:26:17 2006
X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id D1A279FA502
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Jun 2006 13:26:17 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 61703-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 27 Jun 2006 13:26:07 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from outmail128141.authsmtp.com (outmail128141.authsmtp.com
	[62.13.128.141])
	by postgresql.org (Postfix) with ESMTP id EE4E09FA61D
	for <pgsql-sql@postgresql.org>; Tue, 27 Jun 2006 13:26:05 -0300 (ADT)
Received: from [192.168.1.102] (dsl081-245-111.sfo1.dsl.speakeasy.net
	[64.81.245.111]) (authenticated bits=0)
	by squirrel.dmpriest.net.uk (8.13.6/8.13.6/Kp) with ESMTP id
	k5RGPoHo023823; Tue, 27 Jun 2006 17:25:51 +0100 (BST)
Message-ID: <44A15C1E.1000201@agliodbs.com>
Date: Tue, 27 Jun 2006 09:26:06 -0700
From: Josh Berkus <josh@agliodbs.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Kyle Bateman <kyle@actarg.com>
CC: phatcher@macys.com, pgsql-sql@postgresql.org
Subject: Re: Schema management tool
References: <44A14D27.90301@actarg.com>
In-Reply-To: <44A14D27.90301@actarg.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Server-Quench: 99d8cafa-05f9-11db-b770-001185d377ca
X-AuthRoute: OCdyZgscClZWXQAX IioPECZaRkMuIRha BAIHMQpCJFdJDkVH
	aBkdDEdVdwdEHQ8R AmEBWVFeVV8/X2dr YwtPbwFYfEtPXhpo
	VUpMXVIcTwAKdnxe fkEeUBp6dQYIf353 K09rCngIDRIraEZ4
	FEdJFGxSN3oyb2cf TUBYdgJcdVdJeRgW Ox4dAXkdAjZfMycx
	Vwo6OTk+MDBSLjgd XgYKKTpF
X-Authentic-SMTP: 61633136333939.squirrel.dmpriest.net.uk:1.55/Kp
X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse
X-Virus-Status: No virus detected - but ensure you scan with your own
	anti-virus system!
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/287
X-Sequence-Number: 25523

Kyle,

Nice to hear from you guys again!  Action Target was one of the pioneers 
of production open source in manufacturing; nice to know that you're 
still doing well with it.

--Josh