Had trouble getting ERWin to work with postgres (even with the Oracle
look alike views).

So, I wrote a small perl script which outputs XML for Dia to import.
Works pretty good.

More details can be found at:  www.zort.ca/postgresql

<a
href="http://www.zort.ca/postgresql/">http://www.zort.ca/postgresql/</
a>

BSD License, released with permission from InQuent Technologies (my
current employer).


Please send me your thoughts!

Notes:  Don't forget to change the database connection settings, and
fiddle with the StereoType groups.
--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.
Sat, 23 Jun 2001 21:18:01 -0400
"Rod Taylor" <rod.taylor@inquent.com>
Postgres to Dia UML
What is  an accsql.pm required to run your script ?

	Oleg
On Sat, 23 Jun 2001, Rod Taylor wrote:

> Had trouble getting ERWin to work with postgres (even with the Oracle
> look alike views).
>
> So, I wrote a small perl script which outputs XML for Dia to import.
> Works pretty good.
>
> More details can be found at:  www.zort.ca/postgresql
>
> <a
> href="http://www.zort.ca/postgresql/">http://www.zort.ca/postgresql/</
> a>
>
> BSD License, released with permission from InQuent Technologies (my
> current employer).
>
>
> Please send me your thoughts!
>
> Notes:  Don't forget to change the database connection settings, and
> fiddle with the StereoType groups.
> --
> Rod Taylor
>
> Your eyes are weary from staring at the CRT. You feel sleepy. Notice
> how restful it is to watch the cursor blink. Close your eyes. The
> opinions stated above are yours. You cannot imagine why you ever felt
> otherwise.
>
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Fri, 29 Jun 2001 16:47:07 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: Postgres to Dia UML
Ack.. I normally use that for internal code to simplify database
access.  I've put it up on the website, although it doesn't actually
do alot I suppose it is required.

I'll remove it when I get a chance, but for now you're welcome to use
it.

--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.

----- Original Message -----
From: "Oleg Bartunov" <oleg@sai.msu.su>
To: "Rod Taylor" <rod.taylor@inquent.com>
Cc: "Hackers List" <pgsql-hackers@postgresql.org>
Sent: Friday, June 29, 2001 9:47 AM
Subject: Re: [HACKERS] Postgres to Dia UML


> What is  an accsql.pm required to run your script ?
>
> Oleg
> On Sat, 23 Jun 2001, Rod Taylor wrote:
>
> > Had trouble getting ERWin to work with postgres (even with the
Oracle
> > look alike views).
> >
> > So, I wrote a small perl script which outputs XML for Dia to
import.
> > Works pretty good.
> >
> > More details can be found at:  www.zort.ca/postgresql
> >
> > <a
> >
href="http://www.zort.ca/postgresql/">http://www.zort.ca/postgresql/</
> > a>
> >
> > BSD License, released with permission from InQuent Technologies
(my
> > current employer).
> >
> >
> > Please send me your thoughts!
> >
> > Notes:  Don't forget to change the database connection settings,
and
> > fiddle with the StereoType groups.
> > --
> > Rod Taylor
> >
> > Your eyes are weary from staring at the CRT. You feel sleepy.
Notice
> > how restful it is to watch the cursor blink. Close your eyes. The
> > opinions stated above are yours. You cannot imagine why you ever
felt
> > otherwise.
> >
> >
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
>


Fri, 29 Jun 2001 10:13:36 -0400
"Rod Taylor" <rod.taylor@inquent.com>
Re: Postgres to Dia UML
> So, I wrote a small perl script which outputs XML for Dia to import.
> Works pretty good.

Thanks for posting a helpful script. 

I haven't kept up on perl packages, but I recall that the "docbook2man"
scripts which we use to convert our DocBook sgml reference pages to man
page format use a "SGMLS" package to help organize the sgml parse tree.

Is that package usable for XML, or are there other XML packages to help
with dealing with XML-based information? Just curious...

                     - Thomas

Fri, 29 Jun 2001 15:06:19 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: Postgres to Dia UML
Hello, I have a nightly cron script that runs: vacuumdb -a -z.  The output
of the cron script is emailed to me every night.  For the last several
weeks, about 50% of the time I get the following error at least once but
sometimes more:

NOTICE:  RegisterSharedInvalid: SI buffer overflow
NOTICE:  InvalidateSharedInvalid: cache state reset

I am wondering if this is just something that will happen sometimes, or if
it implies some type of problem.  I have not noticed any problems in using
the system.  Any input would be appreciated.

I am running PG7.0.3 from RPMs (I plan on upgrading to 7.1.2 soon) on RedHat
7.0, 800Mhz Athlon w/ 256M.  Most of the databases are reasonably small (a
few Meg) but some of them are over 1Gig.

The Postmaster command is:  /usr/bin/postmaster -i -B 5000 -N 48 -o -S 16384

The output of the vacuum command looks like:

Vacuuming template1
VACUUM
... < Several more databases > ...
Vacuuming postgres
NOTICE:  RegisterSharedInvalid: SI buffer overflow
NOTICE:  InvalidateSharedInvalid: cache state reset
VACUUM
Vacuuming jpplanning
VACUUM
... < Several more databases> ...
Vacuuming OEA
NOTICE:  RegisterSharedInvalid: SI buffer overflow
NOTICE:  InvalidateSharedInvalid: cache state reset
VACUUM
Vacuuming nutil
VACUUM
Vacuuming feedback
VACUUM
Vacuuming ctlno
VACUUM
0.21user 0.08system 21:37.58elapsed 0%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (5074major+1093minor)pagefaults 0swaps

Matt O'Connor


Fri, 29 Jun 2001 10:34:17 -0500
"Matthew T. O'Connor" <matthew@zeut.net>
Help with SI buffer overflow error
On Sat, 23 Jun 2001, Rod Taylor wrote:

Ahoi Rod,

I suggest you remove the dependency on accsql.pm, since it doesn't do
anything terribly useful, comes from an unknown source, and can be made
inline pretty easily with straight calls to DBI.

I'm currently preparing a much better abstraction module for DB connction
parameters using configuration files and the like. Contact me if you
want to take a look.

Best regards,

Alex Perel
Technical Project Leader
T. 416.341.8950 ext. 238
F. 416.341.8959
E. aperel@verticalscope.com
www.verticalscope.com

> Had trouble getting ERWin to work with postgres (even with the Oracle
> look alike views).
> 
> So, I wrote a small perl script which outputs XML for Dia to import.
> Works pretty good.
> 
> More details can be found at:  www.zort.ca/postgresql
> 
> <a
> href="http://www.zort.ca/postgresql/">http://www.zort.ca/postgresql/</
> a>
> 
> BSD License, released with permission from InQuent Technologies (my
> current employer).
> 
> 
> Please send me your thoughts!
> 
> Notes:  Don't forget to change the database connection settings, and
> fiddle with the StereoType groups.
> --
> Rod Taylor
> 
> Your eyes are weary from staring at the CRT. You feel sleepy. Notice
> how restful it is to watch the cursor blink. Close your eyes. The
> opinions stated above are yours. You cannot imagine why you ever felt
> otherwise.
> 
> 


Fri, 29 Jun 2001 12:09:05 -0400 (EDT)
Alex Perel <aperel@verticalscope.com>
Re: Postgres to Dia UML
Thomas Lockhart <lockhart@fourpalms.org> writes:

> > So, I wrote a small perl script which outputs XML for Dia to import.
> > Works pretty good.
> 
> Thanks for posting a helpful script. 
> 
> I haven't kept up on perl packages, but I recall that the "docbook2man"
> scripts which we use to convert our DocBook sgml reference pages to man
> page format use a "SGMLS" package to help organize the sgml parse tree.
> 
> Is that package usable for XML, or are there other XML packages to help
> with dealing with XML-based information? Just curious...

There is a module called XML::Parser, which is a lower level interface
to James Clark's expat library.

Regards,
Manuel.

29 Jun 2001 12:35:14 -0500
Manuel Sugawara <masm@fciencias.unam.mx>
Re: Re: Postgres to Dia UML
Hi:

On 29 Jun 2001, Manuel Sugawara wrote:

> Thomas Lockhart <lockhart@fourpalms.org> writes:
> 
> > > So, I wrote a small perl script which outputs XML for Dia to import.
> > > Works pretty good.
> > 
> > Thanks for posting a helpful script. 
> > 
> > I haven't kept up on perl packages, but I recall that the "docbook2man"
> > scripts which we use to convert our DocBook sgml reference pages to man
> > page format use a "SGMLS" package to help organize the sgml parse tree.
> > 
> > Is that package usable for XML, or are there other XML packages to help
> > with dealing with XML-based information? Just curious...
> 
> There is a module called XML::Parser, which is a lower level interface
> to James Clark's expat library.
> 
> Regards,
> Manuel.

I have made a script using XML::Parser to convert a dia file to a SQL script:

http://freshmeat.net/projects/eros/

Saludos,

Roberto Andrade Fonseca
randrade@abl.com.mx


Fri, 29 Jun 2001 13:16:29 -0500 (CDT)
"Ing. Roberto Andrade Fonseca" <randrade@abl.com.mx>
Re: Re: Postgres to Dia UML