[SQL] Auto-update script from dumps?

2004-08-26 Thread Joerg Hessdoerfer
Hi! What I'm looking for is something that handles DB schema upgrades. We're building applications which require upgrades to the DB schema over time, so when we upgrade our apps we need to modify the DB. For this, we're using SQL scripts, which basically do incremental updates, e.g. from 1.2 to

Re: [SQL] To ListAdms: Is pgsql-sql operating?

2003-06-06 Thread Joerg Hessdoerfer
On Thursday 05 June 2003 18:25, you wrote: > Achilleus, > > > Is there any problem with [EMAIL PROTECTED] list? > > The mail server died on Tuesday. It's still recovering. Wow! Recovering from being dead... what a medical achievement ;-) Greetings, Joerg -- Leading SW developer - S.E.A

Re: [SQL] Continuous inserts...

2000-08-23 Thread Joerg Hessdoerfer
ps I should have mentioned that the test was done using 6.5.3 - I didn't come around to upgrade yet... Oh, yes, the mentioned rule was the ONLY rule on that database. Greetings, Joerg -- +-- Science & Engineering Applications GmbH

Re: [SQL] Continuous inserts...

2000-08-22 Thread Joerg Hessdoerfer
ted the DB very often, and the the change seemed immediate. Any ideas on how to 'promote' the rules faster?!? Greetings, Joe -- +-- Science & Engineering Applications GmbH --+ |

Re: [SQL] Continuous inserts...

2000-08-18 Thread Joerg Hessdoerfer
you have more/other fields in your table, you need to change rule's definition. Hope this helps, Joerg +-- Science & Engineering Applications GmbH --+ | | | Joerg Hessdoerfer

Re: [SQL] Continuous inserts...

2000-08-18 Thread Joerg Hessdoerfer
previous posting for slightly more detail. Greetings, Joerg +-- Science & Engineering Applications GmbH --+ | | | Joerg Hessdoerfer | | Leading SW

Re: [SQL] Continuous inserts...

2000-08-18 Thread Joerg Hessdoerfer
e copy records from b to a vacuum b Why did you suppose three tables? Did I overlook something? Greetings, Joerg +-- Science & Engineering Applications GmbH --+ | | | Joerg Hessdoerfer

[SQL]

2000-08-17 Thread Joerg Hessdoerfer
COPYing the insert table into an offline table) b) I would prefer near-to zero downtime - else the client (a near real-time app) would have to do things like determine server status, buffering etc. pp., und would get considerably more complex. Joerg Hessdoerfer wrote: >> Hi! >> >>

[SQL] Continuous inserts...

2000-08-17 Thread Joerg Hessdoerfer
lications GmbH --+ | | | Joerg Hessdoerfer | | Leading SW developer Phone:+49 (0)2203-962211 | | S.E.A GmbH Fax: -962212 | | D-51147 KoelnInternet: [E