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/&quot;&gt;http://www.zort.ca/postgresql/&lt;/
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

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/&quot;&gt;http://www.zort.ca/postgresql/&lt;/

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

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

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

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

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.

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