Re: [ADMIN] Visual data model creation / maintenance tools

2005-03-08 Thread Bearden Barnes
Is degree of "not free" a consideration? If so, you might exclude option 1, ERwin. If not, you might add Sybase PowerDesigner to your list. ErWin and PD are in the same category as far as cost goes. After those two, cost becomes less of an issue. --Bearden -Original Message- From: S

Re: [ADMIN] help!!!!!!

2005-03-08 Thread Postgres Admin
You're php install isn't finding the postgresql libs it needs. When you do the ./configure --with-pgsql check the output of the config run, and you'll see something like: checking for PostgreSQL support... no You may want to set include flags when compiling CPPFLAGS=-I/usr/local/pgsql/inc

Re: [ADMIN] where I can find ???

2005-03-08 Thread Michael Fuhr
On Wed, Mar 09, 2005 at 07:03:40AM +0700, dedy wrote: > I'm searching about PostgreSQL server 8.0 stable version. > but I can't find it, > May be all of you could tell me the link or url to download it Are you looking for source code or a pre-built package? You can get source code from the Postg

[ADMIN] where I can find ???

2005-03-08 Thread dedy
Hello all, Can you help me please? I'm searching about PostgreSQL server 8.0 stable version. but I can't find it, May be all of you could tell me the link or url to download it Thank you very much Dedy Styawan NB: I'm sorry if my english is very bad |. . |L /| .

[ADMIN] Visual data model creation / maintenance tools

2005-03-08 Thread Sam Hahn
I am interested in what people here think are good tools (free or not) for creating / maintaining a pg data model. A layout view for relationships is preferred (with selectable levels of detail, eg. fields, keys). I would like it to have knowledge of pg datatypes, but this isn't a nogo item, so lon

[ADMIN] graphical tools

2005-03-08 Thread Joel Fradkin
I have seen this question a few times and still have not found a tool that lets me edit the schema. I have pgadminIII which I like, I also have tried a few other tools some are not free, but none seem to allow me to just change the type of a field from say char to varchar etc. Is there a tool (even

Re: [ADMIN] Too many clients----A big problem for my team

2005-03-08 Thread Steve Crawford
>I work with postgresql 8.0 version. I have a team of 14 > developers. When all the team connects the DB i see this error very > very frequently which is a severe problem for me and team all the > day. The error is: > > Please report this exception: java.sql.SQLException: FATAL: sorry,

Re: [ADMIN] help!!!!!!

2005-03-08 Thread Scott Marlowe
On Sat, 2005-03-05 at 08:09, francis feh wrote: > i work with php and postgres,but i have a problem.when i > whrite my program in php with postgres function (pg_connect for > esample),the browser told me that is undefined function ,it's very > strange because i compil the php source with su

Re: [ADMIN] Postgres schema comparison.

2005-03-08 Thread Matteo Beccati
Hi, I have the wonderful job of re-synch'ing all the schemas out there not conforming to the master. I've looked everywhere for something that will help doing this. I'm specifically looking for a way to do a sumcheck or something similar on tables and/or schema as a whole to be able to do a table

Re: [ADMIN] [SQL] Postgres schema comparison.

2005-03-08 Thread Stef
Jim Buttafuoco mentioned : => I use dblink to attach to both databases and query pg_namespace, pg_class, pg_attribute ... to get the diffs. See => attached as an example. look for the dblink_connect lines to specify your database. You will need to install => contrib/dblink. I used this with 7