From: | Chris Dunworth <cdunworth(at)earthcomber(dot)com> |
---|---|
To: | arnaulist(at)andromeiberica(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: help with version checking |
Date: | 2006-12-28 18:32:51 |
Message-ID: | 45940DD3.3040509@earthcomber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Can you do the whole thing inside a transaction context (both the
version check and the updates)? The exception should cause the
transaction to bail out, and the updates won't proceed.
Thus:
BEGIN;
SELECT check_version();
UPDATE agenda_version set version = '1.0.0.1' where id = 1;
COMMIT;
I tried it with your script and it seemed to work for me.
Hope this helps...
-chris
Arnau wrote:
> Tom Lane wrote:
>> Arnau <arnaulist(at)andromeiberica(dot)com> writes:
>>> I don't want, if it's possible, to create a function.
>>
>> Unlike Oracle, PG makes a strong distinction between SQL and
>> programmable languages (including plpgsql). You can't write
>> plpgsql code without putting it into a function.
>>
>> regards, tom lane
>>
>
> I've tried Daniel's suggestion but the Raise doesn't terminate the
> script execution, so if doesn't do what I need. Notice the Update 1
>
> arebassa(at)beowulf:~$ psql -d dermagier -f upgrade_agenda.sql
> CREATE FUNCTION
> psql:upgrade_agenda.sql:16: ERROR: This script needs Agenda version
> 1.0.0.0, detected version 1.0.0.1
> UPDATE 1
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | roopa perumalraja | 2006-12-29 01:05:04 | Help in altering the column lenght |
Previous Message | Arnau | 2006-12-28 18:20:55 | Re: help with version checking |