Skip site navigation (1) Skip section navigation (2)

rule/trigger for batch update

From: "Nico" <nicohmail-postgresql(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: rule/trigger for batch update
Date: 2005-02-25 02:00:15
Message-ID: cvm0uv$26p7$ (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
I want to make a trigger or a rule. However here is the tricky part: I want 
it to happen after a batch of updates and not during one of them. It is 
already set (by means of a unique index) that maximum one record can contain 
the value 1. Point is that after every update I still have exactly one 
record where the field value is 1. Here is what is supposed to happen in the 
same batch:
UserRoleID (where value is 1) becomes 2 or 3. Which leaves no record to have 
a 1 value in this field.
The field becomes 1 in another record.
Now both actions must happen or neither.

Here is the table creation code:
CREATE TABLE "tblUser" (
    "UserID" serial NOT NULL,
    "UserName" character varying(50) NOT NULL,
    "UserPass" character varying(50) NOT NULL,
    "UserRoleID" integer DEFAULT 3 NOT NULL
CREATE UNIQUE INDEX indsuperadmin ON "tblUser" USING btree ("UserRoleID") 
WHERE ("UserRoleID" = 1);

Thanks in advance,

pgsql-jdbc by date

Next:From: Neil ConwayDate: 2005-02-25 06:48:16
Subject: Re: Where are we on stored procedures?
Previous:From: Tom LaneDate: 2005-02-25 01:34:01
Subject: Re: Where are we on stored procedures?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group