Can anybody recommend any software for creating UML
diagrams and generating the SQL necessary to create
the database? Dia?

__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

Thu, 7 Nov 2002 13:05:49 -0800 (PST)
CSN <cool_screen_name90001@yahoo.com>
Database design software
Yes, I know of a good one. The pricing is a bit different. The price is 
on the hourly used
basis. The cost is $100/ hour. But its an excellent system. It also 
makes coffee, attends
meetings and stuff. Its called John Doe the DBA.

Oh...it also has a builtin speech recognition and synthesizer feature...

CSN wrote:

>Can anybody recommend any software for creating UML
>diagrams and generating the SQL necessary to create
>the database? Dia?
>
>__________________________________________________
>Do you Yahoo!?
>U2 on LAUNCH - Exclusive greatest hits videos
>http://launch.yahoo.com/u2
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>  
>




Thu, 07 Nov 2002 13:28:47 -0800
Medi Montaseri <medi.montaseri@intransa.com>
Re: Database design software
You try Oracle JDeveloper on otn.oracle.com 
regards
Haris Peco
On Thursday 07 November 2002 09:05 pm, CSN wrote:
> Can anybody recommend any software for creating UML
> diagrams and generating the SQL necessary to create
> the database? Dia?
>
> __________________________________________________
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive greatest hits videos
> http://launch.yahoo.com/u2
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


Thu, 7 Nov 2002 22:30:43 +0000
snpe <snpe@snpe.co.yu>
Re: Database design software
What is the command to launch a trace
i try postmaster -i -D .... -d 10 >logfile
but the file is create but nothing are in why?
thanks


Fri, 08 Nov 2002 09:42:35 +0100
Florian Litot <flitot@besancon.sema.slb.com>
command
On 8 Nov 2002 at 9:42, Florian Litot wrote:

> What is the command to launch a trace
> i try postmaster -i -D .... -d 10 >logfile
> but the file is create but nothing are in why?

Try postmaster -i -D .... -d 10 >logfile 2>&1

HTH


Bye
 Shridhar

--
MIT:	The Georgia Tech of the North


Fri, 08 Nov 2002 14:44:06 +0530
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: command
yes it's good but can i have the date with each line?

At 10:14 08/11/02, Shridhar Daithankar wrote:
>On 8 Nov 2002 at 9:42, Florian Litot wrote:
>
> > What is the command to launch a trace
> > i try postmaster -i -D .... -d 10 >logfile
> > but the file is create but nothing are in why?
>
>Try postmaster -i -D .... -d 10 >logfile 2>&1
>
>HTH
>
>
>Bye
>  Shridhar
>
>--
>MIT:    The Georgia Tech of the North
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


Fri, 08 Nov 2002 11:03:56 +0100
Florian Litot <flitot@besancon.sema.slb.com>
Re: command
Use syslog... It's documented on the website and in the
manual... Assuming you are running on Linux then adding/editing:

 syslog = 1 # range 0-2
 syslog_facility = 'LOCAL0'
 syslog_ident = 'postgres'

to $PGDATA/postgresql.conf and:

 local0.*			/var/log/postgresql

to /etc/syslog.conf and then doing:

 /etc/init.d/syslog restart
 /etc/init.d/postgresql restart

should give you the log you're looking for at:

 /var/log/postgresql

I'll leave it to you to translate this to your flavour of UNIX (or
Linux)... 

Lee.

Florian Litot writes:
 > yes it's good but can i have the date with each line?
 > At 10:14 08/11/02, Shridhar Daithankar wrote:
 > >On 8 Nov 2002 at 9:42, Florian Litot wrote:
 > > > What is the command to launch a trace
 > > > i try postmaster -i -D .... -d 10 >logfile
 > > > but the file is create but nothing are in why?
 > >Try postmaster -i -D .... -d 10 >logfile 2>&1

Fri, 8 Nov 2002 10:13:58 +0000
Lee Kindness <lkindness@csl.co.uk>
Re: command
On 8 Nov 2002 at 11:03, Florian Litot wrote:

> yes it's good but can i have the date with each line?

Err.. I don't think so. Sounds like a good addition to me.

Any ideas?

Bye
 Shridhar

--
Absentee, n.:	A person with an income who has had the forethought to remove	
himself from the sphere of exaction.		-- Ambrose Bierce, "The Devil's 
Dictionary"


Fri, 08 Nov 2002 15:44:26 +0530
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: command
nobody know if it is possible to have the date in th e same time eache line ?

At 11:14 08/11/02, Shridhar Daithankar wrote:
>On 8 Nov 2002 at 11:03, Florian Litot wrote:
>
> > yes it's good but can i have the date with each line?
>
>Err.. I don't think so. Sounds like a good addition to me.
>
>Any ideas?
>
>Bye
>  Shridhar
>
>--
>Absentee, n.:   A person with an income who has had the forethought to 
>remove
>himself from the sphere of exaction.            -- Ambrose Bierce, "The 
>Devil's
>Dictionary"
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


Fri, 08 Nov 2002 12:12:23 +0100
Florian Litot <flitot@besancon.sema.slb.com>
Re: command
On Friday 08 November 2002 04:42 pm, you wrote:
> nobody know if it is possible to have the date in th e same time eache line

I guess there was a reply to syslog. I am sure it's documented in postgresql 
manual. Missed that last time..

 Shridhar

Fri, 8 Nov 2002 16:54:53 +0530
Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: command
CSN wrote:
> Can anybody recommend any software for creating UML
> diagrams and generating the SQL necessary to create
> the database? Dia?
> 

I use Dia 0.90 and tedia2sql Perl script (http://tedia2sql.tigris.org) 
to translate diagrams in sql scripts. It does a lot of things and if 
you can Perl, lucky you! A nice project is uml2sql from 
http://sourceforge.net/projects/uml2sql but unfortunately it's stopped.

         Regards,
            lwd.


Fri, 08 Nov 2002 09:56:17 -0200
Laurentiu Drob <lwd@cfrcta.ro>
Re: Database design software
Florian Litot <flitot@besancon.sema.slb.com> writes:
> yes it's good but can i have the date with each line?

If you turn it on in postgresql.conf.  See the manual:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html#LOGGING

			regards, tom lane

Fri, 08 Nov 2002 09:54:53 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: command 
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> On 8 Nov 2002 at 11:03, Florian Litot wrote:
> > yes it's good but can i have the date with each line?
> 
> Err.. I don't think so.

Try the log_timestamp GUC option.

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC


08 Nov 2002 10:14:32 -0500
Neil Conway <neilc@samurai.com>
Re: command
I have noted similar problems when attempting to manipulate stdin, 
stdout, stderr of postmaster.
So I use pg_ctl -l log
See pg_ctl(1) to see how they do it there.....

Florian Litot wrote:

> What is the command to launch a trace
> i try postmaster -i -D .... -d 10 >logfile
> but the file is create but nothing are in why?
> thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org





Fri, 08 Nov 2002 10:37:25 -0800
Medi Montaseri <medi.montaseri@intransa.com>
Re: [GENERAL] command