Re: Automatic schema updates - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Automatic schema updates
Date
Msg-id dcc563d10710311108n47950df5jf9d48a4d7051e210@mail.gmail.com
Whole thread Raw
In response to Automatic schema updates  ("Kalra, Ashwani" <ashwani.kalra@capgemini.com>)
List pgsql-general
On 10/29/07, Kalra, Ashwani <ashwani.kalra@capgemini.com> wrote:

Hi,
In our thick client application, I want to update the schema  on the user's machine automatically as normal software update process using JNLP etc

We will be using Eclipser RCP.  Is it possible?


Sure.  IF nothing else, you can just writing raw SQL and spit it out at the database.  If it's > 1 change, wrap them all together in one transaction so that if they fail, they all fail and you don't have a half-updated database.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Securing stored procedures and triggers
Next
From: "Scott Marlowe"
Date:
Subject: Re: Securing stored procedures and triggers