Re: [GENERAL] what is PgUpT ?
От | Stephen Boyle |
---|---|
Тема | Re: [GENERAL] what is PgUpT ? |
Дата | |
Msg-id | 012401bee945$53934c10$010aa8c0@m0n7y обсуждение исходный текст |
Список | pgsql-general |
Jeremy, Amy, All PgUpT was a 'fun??' project I worked on when I was evaluating Postgres. Basically the tool 'upsizes' a microsoft Access 97 database by automatically creating a load of SQL and plpgsql files which both recreate the database and should reproduce all of the referential integrity held within the Access db. It produces: functions to enforce all integrity datafiles in a format easy to import into Postgres triggers to attach the functions to table modifications shell scripts to load all of the data and create the database ftp scripts to transfer all of the files from M$ to Linux/Unix Its been tested with 6.5 and seems to work ok although I haven't touched it for a while. There are a couple of outstanding bugs: 1. Recursive Joins 2. Multiple joins between 2 tables. There are fairly easy workarounds to both 1 and 2 ;-) The web address is http://dspace.dial.pipex.com/boylesa/pgupt/pgupt.shtml. Hope its of Use/Interest. Steve -----Original Message----- From: jeremy@xxedgexx.com <jeremy@xxedgexx.com> To: amy cheng <amycq@hotmail.com> Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>; yd80@dial.pipex.com <yd80@dial.pipex.com> Date: 17 August 1999 12:46 Subject: Re: [GENERAL] what is PgUpT ? > >wrong. > >-jeremy > >> hi, Stephen Boyle or any other experts, >> >> I saw the email in the archive of this list on foreign keys/triggers, >> seems that the triggers are created by a tool "PgUpT", what is >> that? where I can get it? >> >> amy >> >> thanks!!! >> >> #############################below are excerpt from archive >> ...... >> >> ------------------------------------------------------------------------- --- >> ---- >> -- File: create_functions.sql >> -- Description: Create functions on the database. >> ------------------------------------------------------------------------- --- >> ---- >> drop function fn_CompaniesProjects_XUXM1(); >> >> create function fn_CompaniesProjects_XUXM1() returns opaque as ' >> -- >> -- REFERENTIAL INTEGRITY CHECKING CODE BETWEEN Companies AND Projects >> -- ENSURES THAT INTEGRITY IS MAINTAINED AFTER AN UPDATE ON TABLE Companies >> (Master) >> -- Generated by PgUpT 17/07/1999 >> -- >> DECLARE >> l_Flag integer; >> BEGIN >> l_Flag := 0; >> .......................... >> ########################################end >> >> >> _______________________________________________________________ >> Get Free Email and Do More On The Web. Visit http://www.msn.com >> > > >http://www.xxedgexx.com | jeremy@xxedgexx.com >--------------------------------------------- >Y2K. We're all gonna die. >
В списке pgsql-general по дате отправления: