Thread: Postgres to Dia UML
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.
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
> 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
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. > >
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
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 > >
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