Received: from qmail.crp.dnsalias.com (r-bo043-1-62.tin.it [213.45.32.62]) by postgresql.org (Postfix) with SMTP id 519FF4759B0 for ; Tue, 5 Mar 2002 03:12:54 -0500 (EST) Received: (qmail 20606 invoked by uid 64014); 5 Mar 2002 08:08:32 -0000 Received: from m.beccati@crpsoftware.it by web1 with qmail-scanner-1.03 (sweep: 2.7/3.51. . Clean. Processed in 2.032528 secs); 05 Mar 2002 08:08:32 -0000 Received: from unknown (HELO smtp.crp) (10.1.3.151) by 10.1.3.1 with SMTP; 5 Mar 2002 08:08:29 -0000 Received: (qmail 20431 invoked from network); 5 Mar 2002 08:11:45 -0000 Received: from neptune.crp (HELO neptune) (10.1.1.8) by sentinel.crp with SMTP; 5 Mar 2002 08:11:45 -0000 From: "Matteo Beccati" To: Subject: Re: thinking about versioning my database schema Date: Tue, 5 Mar 2002 09:13:16 +0100 Message-ID: <2780D698C269CB4EB303715BA48B6A10336F@sole.CRP> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-reply-to: <2780D698C269CB4EB303715BA48B6A10017759@sole.CRP> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200203/55 X-Sequence-Number: 6937 Hi, > How about a script that dumps your data, dumps your db, > reloads the table > definitions, then reloads your data? You could have a table > with rows for > every table that would keep track of the current version you > have, that > could be updated when this script ran. This is exactly what I did for the update script of my own project phpPgAds... You could take a look to the code if you're interested http://phppgads.sourceforge.net Regards -- Matteo Beccati