phpPgAdmin

Поиск
Список
Период
Сортировка
Искать

phpPgAdmin

От:
Carol Walter <walterc@indiana.edu>
Дата:
Hi, Guys,

Does any one here run Aqua Data Studio to produce database  
documentation?  My user really likes pretty pictures so I'd like to  
get this resolved, if possible.  I'm having a rather strange problem  
with it which quite possibly relates to my postgres configuration  
files.  I'm in an academic environment, so my setup may sound a  
little strange to those of you who are in the corporate world.  I  
have two instances of postgres running, one is the version that is  
running for students, the other that is running is in support of a  
faculty member's research.  I have one copy of Aqua Date Studio  
running.  I can go into Aqua Data Studio to the registered student  
server and ADS will draw pretty ERD's with appropriate relationships,  
so long as the table constraints are properly designed.  When I try  
to do the same thing with the other instance, it refuses to do the  
ERD's and all I get are boxes that contain the data elements.  I have  
run my script that creates all the tables for one of these databases  
in a database on each of the instances.  On the student server, it  
creates a proper ERD, but on the research server in doesn't.  The  
only thing that I can see that is different between the two databases  
is the ownership.  The files in my database on the academic server  
are owned by me, but the database on the research server says it's  
owned by postgres.  I can log into phpPgAdmin, though, as the  
appropriate user name and it will list the constraints.  ADS will  
list the constraint in the table tree under the tables but will not  
list them on the ERD page.

I'm sorry for the long question that might not even be relevant.   
I've contacted Aqua Fold support and they are no help.  They're  
suggestion was that I upgrade to the newest version. (They no longer  
have a free academic version and I don't want to do that.) Because I  
have just one copy of ADS running and one instance works and the  
other doesn't, it seems that an upgrade wouldn't do the job.

Thanks,
Carol Walter

Re: phpPgAdmin

От:
John DeSoi <desoi@pgedit.com>
Дата:

On Jul 27, 2007, at 10:05 AM, Carol Walter wrote:

> I can go into Aqua Data Studio to the registered student server and  
> ADS will draw pretty ERD's with appropriate relationships, so long  
> as the table constraints are properly designed.  When I try to do  
> the same thing with the other instance, it refuses to do the ERD's  
> and all I get are boxes that contain the data elements.  I have run  
> my script that creates all the tables for one of these databases in  
> a database on each of the instances.  On the student server, it  
> creates a proper ERD, but on the research server in doesn't.  The  
> only thing that I can see that is different between the two  
> databases is the ownership.


Is the PostgreSQL version the same for both server instances? If not,  
the system catalog information might have changed in some way between  
versions that is causing problems for ADS. You might also try setting  
the logging to the highest level and then generate your diagrams with  
ADS. Check to see if there are errors or any differences in the SQL  
statements executed.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

FAQ